A P P E N D I X E S - - - - - - - - - - Appendix A. Networked Oracle ---------------- ; ORACLE.INI file for MS-WINDOWS ; local=t:e35m:test ORACLE_HOME=M:\ORAWIN NLS_LANG=RUSSIAN_RUSSIA.CL8MSWINDOW31 ....... USERNAME=DBEZRUKO TCP_VENDOR=NOVLWP ; Novell Lan Workplace TCP_HOSTS_FILE=M:\NET\TCP\HOSTS ; Hosts file NETWORK21=M:\ORAWIN\network TCP_PORT=1525 ; port for SQL*NET v1 . . . . ------------------------------------------------ rem CONFIG.ORA for MS-DOS ORACLE_HOME=C:\ORACLE6 MACHINE_TYPE=J LOCAL=t:e35m:test ; To fast switching between rem LOCAL = x:ora7 ; between servers (by default) remote=x:ora7 LANGUAGE=Russian_USSR.RU8PC866 ;v6 tools NLS_LANG=RUSSIAN_CIS.RU8PC866 ;v7 tools USERNAME=BEZRUKOV TCP_HOSTS_FILE=C:\NET\TCP\HOSTS TCP_SERVICES_FILE=C:\NET\TCP\SERVICES utility_MSG=C:\ORACLE6\DBS dynamic_memory=8000 ORAKITPATH=C:\ORACLE6\DBS MULTIVERSION_ORACLE_HOME=TRUE DOSMEM_SEARCH=PROT,REAL RDBMS70=C:\ORACLE6\RDBMS70 PRO15=C:\ORACLE6\PRO15 RDBMS_DFLT=RDBMS70 . . . ------------------------------------------------ # Oracle Corporation 1993 # Sample SQLNET.ORA file. # This is a sample file for the client side. # This file should be changed appropriately # for any given network/machine. # 5/15/93 - Created Mason Ng # # set level of "verbosity" of tracing # automatic_ipc = OFF trace_unique_client = ON trace_level_client = OFF trace_directory_client = C:\tmp netman.trace_level=off netman.trace_file=netman netman.trace_directory=C:\ORAWIN\network\trace ----------------------------------------------- # Oracle Corporation 1993 # Sample tnsnames.ora file. # This is a sample file for the client side. # This file should be changed appropriately for # any given network/machine. test=(DESCRIPTION= (ADDRESS= (PROTOCOL=tcp)(PORT=1521)(HOST=e35m)) (CONNECT_DATA=(SID=test) )) vbnk=(DESCRIPTION= (ADDRESS= (PROTOCOL=tcp)(PORT=1521)(HOST=e35m)) (CONNECT_DATA=(SID=vbnk) )) sys4=(DESCRIPTION= (ADDRESS= (PROTOCOL=tcp)(PORT=1521)(HOST=e35m)) (CONNECT_DATA=(SID=sys4) )) sco=(DESCRIPTION = (ADDRESS= (PROTOCOL = tcp)(PORT = 1521 )(HOST = vabank )) (CONNECT_DATA=(SID = bank) )) # # Dedicated server # # Important Note #1: if (SERVER=DEDICATED) is not presented then # (SERVER=MULTI-THREADED) is assumed. # # Important Note #2: if MTS is not installed on the server side # then dedicated server is ALWAYS used, even # if (SERVER=MULTI-THREADED) is specified. # # If you want to be sure to force a client to use the MTS, # include: # USE_DEDICATED_SERVER=OFF # in client side SQLNET.ORA file. # dnw=(DESCRIPTION= (ADDRESS=(PROTOCOL=SPX) (SERVICE=NET2) ) (CONNECT_DATA=(SID=ORA7) (SERVER=DEDICATED) ) ) # # Multithread server # mnw=(DESCRIPTION= (ADDRESS=(PROTOCOL=SPX) (SERVICE=NET2) ) (CONNECT_DATA=(SID=ORA7) (SERVER=MULTI-THREADED) ) ) ----------------------------------------------- # # LISTENER.ORA file (from NetWare) # LISTENER = (ADDRESS_LIST= (ADDRESS=(PROTOCOL=SPX)(SERVICE=NET2)) ) CONNECT_TIMEOUT_LISTENER=10 STOP_LISTENER=yes TRACE_LEVEL_LISTENER = ON SID_LIST_LISTENER=(SID_DESC= (SID_NAME=ORA7) (ORACLE_HOME=SYS:ORANW)) ----------------------------------------------- # # INIT.ORA parameters for multithread server # # ORACLE_SID on UNIX platforms: MTS_SERVICE=ORA7 MTS_DISPATCHERS="SPX,2" MTS_LISTENER_ADDRESS="(ADDRESS=(PROTOCOL=SPX)(SERVICE=NET2))" MTS_SERVERS=3 MTS_MAX_SERVERS=5 MTS_MAX_DISPATCHERS=4 # # Process names are # d000 - dispatchers and # S000 - servers ----------------------------------------------- ; ; c:\windows\ORACLE.INI configuration file ; [Oracle] local=test ;local=t:e35m:test ORACLE_HOME=Q:\ORAWIN NLS_LANG=American_America.CL8MSWINDOW31 ;NLS_LANG=Russian_CIS.CL8MSWINDOW31 ;NLS_LANG=American_America.WE8ISO8859P1 ORACLE_TEMP=C:\TMP ORACLE_LOCAL=C:\TMP CA_UPREFS=C:\WINDOWS CA_GPREFS=Q:\ORAWIN ORAINST=Q:\ORAWIN\dbs OB20=Q:\ORAWIN\BOOK20 OB21=Q:\ORAWIN\BOOK21 TCP_VENDOR=NOVLWP TCP_HOSTS_FILE=C:\NET\TCP\HOSTS ;TCP_SERVICES_FILE=Q:\ORAWIN\TCP\SERVICES.HLP TCP_PORT=1525 HAMMER=Q:\ORAWIN\BOOK21\HAMMER VGS21=Q:\ORAWIN\CDE2 DE15=Q:\ORAWIN\CDE2 OCL25=Q:\ORAWIN\CDE2 TK21=Q:\ORAWIN\CDE2 TK21_ICON=Q:\ORAWIN\CDE2\ICONS;Q:\ORAWIN\FORMS45\DEMOS\ICONS;Q:\ORAWIN\GRAPH25\DEMOS\FORMS MM20=Q:\ORAWIN\CDE2 RDBMS70=Q:\ORAWIN\RDBMS70 RDBMS70_CONTROL=Q:\ORAWIN\DBS RDBMS70_ARCHIVE=Q:\ORAWIN\RDBMS70\ARCHIVE RDBMS71=Q:\ORAWIN\rdbms71 PRO14=Q:\ORAWIN\PRO14 PRO15=Q:\ORAWIN\PRO15 PRO16=Q:\ORAWIN\pro16 SQLPATH=Q:\ORAWIN\DBS PLUS31=Q:\ORAWIN\PLUS31 EXECUTE_SQL=PLUS31 VGS20=Q:\ORAWIN\dbs DE1016=Q:\ORAWIN\DBS OCL20=Q:\ORAWIN\dbs TK20=Q:\ORAWIN\DBS OH1010=Q:\ORAWIN\DBS MM107=Q:\ORAWIN\DBS SUPNOTES=Q:\ORAWIN\supnotes CDHOME=S: ORACLE_VOLUME=S:\ office20=Q:\ORAWIN\OFFICE20 username=BEZRUKOV coauthor=Q:\ORAWIN\coauthor cohome=Q:\ORAWIN\COAUTHOR context=Q:\ORAWIN\context coauthor20=Q:\ORAWIN\coauth20 oacore10=Q:\ORAWIN\oacore10 oahome=Q:\ORAWIN NETWORK21=C:\ORAWIN\network TNS_ADMIN=C:\ORAWIN\network\admin SQLTR=Q:\ORAWIN\SQLTR MSHELP=Q:\ORAWIN\MSHELP TOOLS_GROUP=Personal Oracle7 VS10=Q:\ORAWIN\VS10 HELP_GROUP=Personal Oracle7 GLUEOFF=Q:\ORAWIN\GLUEOFF\MESG EGLUE11=Q:\ORAWIN OOMGRF20=Q:\ORAWIN\OOMGRF20 ORAKITPATH=Q:\ORAWIN\dbs UTILITY_MSG=Q:\ORAWIN\dbs ORACLE_TIO=VIDEO PLSQL20=Q:\ORAWIN\PLSQL20 BROWSER10=Q:\ORAWIN\BROWSE10 SQLNET DBNAME oracle7=2: FORMS45_DEFAULTFONT="Tms Rmn.10" ;FORMS45_DEFAULTFONT="Helv.10" [CDE] FORMS45=Q:\ORAWIN\FORMS45 GRAPHICS25=Q:\ORAWIN\GRAPH25 ORAPLSQLLOADPATH=Q:\ORAWIN\FORMS45\DEMOS\GRAPHICS GRAPHICS_PATH=Q:\ORAWIN\FORMS45\DEMOS\GRAPHICS RW25=Q:\ORAWIN\REPORT25 ODBC10=Q:\ORAWIN\OCA\ODBC10 UB=Q:\ORAWIN\DBS PB15=Q:\ORAWIN\PB15 GRAPHICS25_PATH=Q:\ORAWIN\FORMS45\DEMOS\GRAPHICS;Q:\ORAWIN\GRAPH25\DEMOS\FORMS;Q:\ORAWIN\FORMS45\DEMOS\DYNCHART FORMS45_PATH=Q:\ORAWIN\FORMS45\PLSQLLIB;Q:\BLACK.RCK\KUMARAN;C:\KUMARAN;Q:\ORAWIN\GRAPH25\DEMOS\FORMS REPORTS25_PATH=Q:\ORAWIN\REPORT25\DEMO;Q:\ORAWIN\REPORT25\DEMO\REQFILES;Q:\ORAWIN\REPORT25\DEMO\BITMAP BROWSER20=Q:\ORAWIN\BROWSE20 ODQ40=Q:\ORAWIN\ODQ40 ; RTWKB=Q:\ORAWIN\RTWKB