by George Pujol - gpujol@interserv.com
Contents
Load your Oracle Workgroup Server software as usual. You should now have the following modules loaded in memory depending on which version (7.1, 7.2, 7.3) you are using:
ORACLE 7.1 |
ORACLE 7.2 |
ORACLE 7.3 |
COMMON |
|
Main modules: |
ORACLE71.NLM |
ORACLE72.NLM |
ORACLE73.NLM |
|
CORE3.NLM |
CORE34.NLM |
CORE35.NLM |
||
ORADRV.NLM |
||||
ORATK2.NLM |
||||
Bequeath modules: |
NTP.NLM |
|||
IPC modules: |
IPC.NLM |
|||
NTIUS.NLM |
||||
TNS modules: |
SQLTNS.NLM |
|||
TNSLIB.NLM |
||||
TNSLSNR.NLM |
||||
SPX modules: |
NTS.NLM |
|||
TCP/IP modules: |
NTIT.NLM |
|||
Optionally, you can load LSNRCTL.NLM which allows you to control the TNS listener.
You should also have a CONFIG.ORA file with at least the following entries:
[Oracle] NET2x=APPVOL1:ORANW7x\NETWORK NLS_LANG=AMERICAN_AMERICA.WE8ISO8859P1 ORACLE_HOME=APPVOL1:ORANW7x ORACLE_SRVNAME=ORACLE ORAINST=APPVOL1:ORANW7x\dbs ORA_SQLDBA_MODE=LINE OS_NAME=netware RDBMS7x=APPVOL1:ORANW7x\RDBMS7x ; The next entries are only needed if you are connecting through TCP/IP. TCP_PORT=1521 TCP_VENDOR=WINSOCK TCP_HOSTS_FILE=SYS:ETC\HOSTS TCP_SERVICES_FILE=SYS:ETC\SERVICESLISTENER.ORA File for Netware
LISTENER=(ADDRESS_LIST= (ADDRESS= (PROTOCOL=SPX) (SERVICE=ORASRV) ) (ADDRESS= (PROTOCOL=TCP) (HOST=ORAC) # Optionally you can specify the IP address here (i.e., 192.2.3.9) (PORT=1521) ) ) CONNECT_TIMEOUT_LISTENER=10 STOP_LISTENER=yes TRACE_LEVEL_LISTENER=OFF SID_LIST_LISTENER=(SID_DESC= (SID_NAME=ORCL) # SID value is limited to four characters (ORACLE_HOME=APPVOL1:ORANW7x) )
Registry Entries
HKEY_LOCAL_MACHINE
Oracle 7
Key Name: SOFTWARE\ORACLE Class Name: Application Global Data
Value 0 |
Name: NET2x |
Type: REG_SZ |
Data: D:\ORANT7x\NETWORK |
Value 1 |
Name: NLS_LANG |
Type: REG_EXPAND_SZ |
Data: AMERICAN_AMERICA.WE8ISO8859P1 |
Value 2 |
Name: NLSRTL31 |
Type: REG_EXPAND_SZ |
Data: D:ORANT7x\NLSRTL31 |
Value 3 |
Name: ORA_NLS |
Type: REG_EXPAND_SZ |
Data: D:\ORANT7x\NLSRTL31\DATA |
Value 4 |
Name: ORACLE_HOME |
Type: REG_EXPAND_SZ |
Data: D:\ORANT7x |
Value 5 |
Name: RDBMS7x |
Type: REG_EXPAND_SZ |
Data: D:\ORANT7x\RDBMS7x |
Value 6 |
Name: ORACLE_SID |
Type: REG_EXPAND_SZ |
Data: ORCL |
Value 7 |
Name: TCP_HOSTS_FILE |
Type: REG_SZ |
Data: D:\WINNT\SYSTEM32\DRIVERS\ETC\HOSTS |
Value 8 |
Name: TCP_PORT |
Type: REG_DWORD |
Data: 0x5f5 |
Value 9 |
Name: TCP_SERVICES_FILE |
Type: REG_SZ |
Data: D:\WINNT\SYSTEM32\DRIVERS\ETC\SERVICES |
Value 10 |
Name: TCP_VENDOR |
Type: REG_SZ |
Data: WINSOCK |
Value 11 |
Name: ORACLE_PRIORITY |
Type: REG_EXPAND_SZ |
Data: CLASS:normal;DEF:normal |
Key Name: SOFTWARE\ORACLE\SECURITY
Class Name: Application Global Data
Value 0 |
Name: ORA_ORCL_STARTMODE |
Type: REG_SZ |
Data: TRUE |
Value 1 |
Name: ORA_ORCL_STARTTYPE |
Type: REG_DWORD |
Data: 0x4a |
Value 2 |
Name: ORA_ORCL_TNS |
Type: REG_SZ |
Data: TRUE |
Key Name: SYSTEM\CurrentControlSet\Control\Session Manager\Environment
Class Name: <NO CLASS>
Value 0 |
Name: ORACLE.SID |
Type: REG_SZ |
Data: ORCL |
Value 1 |
Name: Path |
Type: REG_EXPAND_SZ |
Data: %SystemRoot%\system32;%SystemRoot%;D:\PUBLIC\ORANT7x\BIN;……… |
Key Name: SYSTEM\CurrentControlSet\Services\OracleStartORCL
Class Name: <NO CLASS>
Value 0 |
Name: DependOnGroup |
Type: REG_MULTI_SZ |
Data: |
Value 1 |
Name: DependOnService |
Type: REG_MULTI_SZ |
Data: OracleServiceORCL |
Value 2 |
Name: DisplayName |
Type: REG_SZ |
Data: OracleStartORCL |
Value 3 |
Name: ErrorControl |
Type: REG_DWORD |
Data: 0x1 |
Value 4 |
Name: ImagePath |
Type: REG_EXPAND_SZ |
Data: d:\public\orant7x\bin\strtdb7x.exe |
Value 5 |
Name: ObjectName |
Type: REG_SZ |
Data: LocalSystem |
Value 6 |
Name: Start |
Type: REG_DWORD |
Data: 0x2 |
Value 7 |
Name: Type |
Type: REG_DWORD |
Data: 0x10 |
Key Name: SYSTEM\CurrentControlSet\Services\OracleStartORCL\Security
Class Name: <NO CLASS>
Value 0 |
Name: Security |
Type: REG_BINARY |
Data: 00000000 01 00 14 80 C0 00 00 00 CC 00 00 00 14 00 00 00 ........ |
Key Name: SYSTEM\CurrentControlSet\Services\OracleServiceORCL
Class Name: <NO CLASS>
Value 0 |
Name: DisplayName |
Type: REG_SZ |
Data: OracleServiceORCL |
Value 1 |
Name: ErrorControl |
Type: REG_DWORD |
Data: 0x1 |
Value 2 |
Name: ImagePath |
Type: REG_EXPAND_SZ |
Data: d:\public\orant7x\bin\oracle7x.exe ORCL |
Value 3 |
Name: ObjectName |
Type: REG_SZ |
Data: LocalSystem |
Value 4 |
Name: Start |
Type: REG_DWORD |
Data: 0x2 |
Value 5 |
Name: Type |
Type: REG_DWORD |
Data: 0x10 |
Key Name: SYSTEM\CurrentControlSet\Services\OracleServiceORCL\Security
Class Name: <NO CLASS>
Value 0 |
Name: Security |
Type: REG_BINARY |
Data: 00000000 01 00 14 80 C0 00 00 00 CC 00 00 00 14 00 00 00 ........ |
Key Name: SYSTEM\CurrentControlSet\Services\OracleTNSListener
Class Name: <NO CLASS>
Value 0 |
Name: DisplayName |
Type: REG_SZ |
Data: OracleTNSListener |
|
Value 1 |
Name: ErrorControl |
Type: REG_DWORD |
Data: 0x1 |
|
Value 2 |
Name: ImagePath |
Type: REG_EXPAND_SZ |
Data: D:\PUBLIC\ORANT7x\BIN\TNSLSNR.EXE |
|
Value 3 |
Name: ObjectName |
Type: REG_SZ |
Data: LocalSystem |
|
Value 4 |
Name: Start |
Type: REG_DWORD |
Data: 0x2 |
|
Value 5 |
Name: Type |
Type: REG_DWORD |
Data: 0x10 |
|
Key Name: SYSTEM\CurrentControlSet\Services\OracleTNSListener\Security
Class Name: <NO CLASS>
Value 0 |
Name: Security |
Type: REG_BINARY |
Data: 00000000 01 00 14 80 C0 00 00 00 CC 00 00 00 14 00 00 00 ........ |
Oracle 8
Key Name: SOFTWARE\ORACLE Class Name: Application Global Data
Value 0 |
Name: NET80 |
Type: REG_SZ |
Data: D:\ORANT8\NET80 |
Value 1 |
Name: NLS_LANG |
Type: REG_EXPAND_SZ |
Data: AMERICAN_AMERICA.WE8ISO8859P1 |
Value 2 |
Name: NLSRTL33 |
Type: REG_EXPAND_SZ |
Data: D:ORANT80\NLSRTL33 |
Value 3 |
Name: ORA_NLS33 |
Type: REG_EXPAND_SZ |
Data: D:\ORANT80\NLSRTL33\DATA |
Value 4 |
Name: ORACLE_HOME |
Type: REG_EXPAND_SZ |
Data: D:\ORANT8 |
Value 5 |
Name: RDBMS80 |
Type: REG_EXPAND_SZ |
Data: D:\ORANT8\RDBMS80 |
Value 6 |
Name: ORACLE_SID |
Type: REG_EXPAND_SZ |
Data: ORCL |
Value 7 |
Name: TCP_HOSTS_FILE |
Type: REG_SZ |
Data: D:\WINNT\SYSTEM32\DRIVERS\ETC\HOSTS |
Value 8 |
Name: TCP_PORT |
Type: REG_DWORD |
Data: 0x5f5 |
Value 9 |
Name: TCP_SERVICES_FILE |
Type: REG_SZ |
Data: D:\WINNT\SYSTEM32\DRIVERS\ETC\SERVICES |
Value 10 |
Name: TCP_VENDOR |
Type: REG_SZ |
Data: WINSOCK |
Value 11 |
Name: ORACLE_PRIORITY |
Type: REG_EXPAND_SZ |
Data: CLASS:normal;DEF:normal |
Key Name: SOFTWARE\ORACLE\SECURITY
Class Name: Application Global Data
Value 0 |
Name: ORA_ORCL_STARTMODE |
Type: REG_SZ |
Data: TRUE |
Value 1 |
Name: ORA_ORCL_STARTTYPE |
Type: REG_DWORD |
Data: 0x4a |
Value 2 |
Name: ORA_ORCL_TNS |
Type: REG_SZ |
Data: TRUE |
Key Name: SYSTEM\CurrentControlSet\Control\Session Manager\Environment
Class Name: <NO CLASS>
Value 0 |
Name: ORACLE.SID |
Type: REG_SZ |
Data: ORCL |
Value 1 |
Name: Path |
Type: REG_EXPAND_SZ |
Data: %SystemRoot%\system32;%SystemRoot%;D:\PUBLIC\ORANT80\BIN;……… |
Key Name: SYSTEM\CurrentControlSet\Services\OracleStartORCL
Class Name: <NO CLASS>
Value 0 |
Name: DependOnGroup |
Type: REG_MULTI_SZ |
Data: 0x0 |
Value 1 |
Name: DependOnService |
Type: REG_MULTI_SZ |
Data: OracleServiceORCL |
Value 2 |
Name: DisplayName |
Type: REG_SZ |
Data: OracleStartORCL |
Value 3 |
Name: ErrorControl |
Type: REG_DWORD |
Data: 0x1 |
Value 4 |
Name: ImagePath |
Type: REG_EXPAND_SZ |
Data: d:\public\orant80\bin\strtdb80.exe |
Value 5 |
Name: ObjectName |
Type: REG_SZ |
Data: LocalSystem |
Value 6 |
Name: Start |
Type: REG_DWORD |
Data: 0x2 |
Value 7 |
Name: Type |
Type: REG_DWORD |
Data: 0x16 |
Key Name: SYSTEM\CurrentControlSet\Services\OracleStartORCL\Security
Class Name: <NO CLASS>
Value 0 |
Name: Security |
Type: REG_BINARY |
Data: 00000000 01 00 14 80 C0 00 00 00 CC 00 00 00 14 00 00 00 ........ |
Key Name: SYSTEM\CurrentControlSet\Services\OracleServiceORCL
Class Name: <NO CLASS>
Value 0 |
Name: DisplayName |
Type: REG_SZ |
Data: OracleServiceORCL |
Value 1 |
Name: ErrorControl |
Type: REG_DWORD |
Data: 0x1 |
Value 2 |
Name: ImagePath |
Type: REG_EXPAND_SZ |
Data: d:\public\orant8\bin\oracle80.exe ORCL |
Value 3 |
Name: ObjectName |
Type: REG_SZ |
Data: LocalSystem |
Value 4 |
Name: Start |
Type: REG_DWORD |
Data: 0x2 |
Value 5 |
Name: Type |
Type: REG_DWORD |
Data: 0x110 |
Key Name: SYSTEM\CurrentControlSet\Services\OracleServiceORCL\Security
Class Name: <NO CLASS>
Value 0 |
Name: Security |
Type: REG_BINARY |
Data: 00000000 01 00 14 80 C0 00 00 00 CC 00 00 00 14 00 00 00 ........ |
Key Name: SYSTEM\CurrentControlSet\Services\OracleTNSListener80
Class Name: <NO CLASS>
Value 0 |
Name: DisplayName |
Type: REG_SZ |
Data: OracleTNSListener80 |
|
Value 1 |
Name: ErrorControl |
Type: REG_DWORD |
Data: 0x1 |
|
Value 2 |
Name: ImagePath |
Type: REG_EXPAND_SZ |
Data: D:\PUBLIC\ORANT8\BIN\TNSLSNR80.EXE |
|
Value 3 |
Name: ObjectName |
Type: REG_SZ |
Data: LocalSystem |
|
Value 4 |
Name: Start |
Type: REG_DWORD |
Data: 0x2 |
|
Value 5 |
Name: Type |
Type: REG_DWORD |
Data: 0x10 |
|
Key Name: SYSTEM\CurrentControlSet\Services\OracleTNSListener80\Security
Class Name: <NO CLASS>
Value 0 |
Name: Security |
Type: REG_BINARY |
Data: 00000000 01 00 14 80 C0 00 00 00 CC 00 00 00 14 00 00 00 ........ |
LISTENER.ORA File for Windows NT
LISTENER=(ADDRESS_LIST= (ADDRESS= (PROTOCOL=SPX) (SERVICE=SPX_ORACLE) ) (ADDRESS= (PROTOCOL=TCP) (HOST=ORAC) # Optionally you can specify the IP address here (i.e., 192.2.3.9) (PORT=1521) ) (ADDRESS= (PROTOCOL=NMP) (SERVER=TECRA) (PIPE=ORAPIPE) ) ) STARTUP_WAIT_TIME_LISTENER=0 CONNECT_TIMEOUT_LISTENER=10 TRACE_LEVEL_LISTENER=OFF SID_LIST_LISTENER=(SID_DESC= (SID_NAME=ORCL) # SID value is limited to four characters (ORACLE_HOME=D:\PUBLIC\ORANT7x)(*) )
(*) Oracle 8: ORACLE_HOME=D:\PUBLIC\ORANT8
SERVICES
orac 1521/tcp oracle
# Oracle recommends setting this port to either 1521 or 1527
# when using SQL*Net Version 2.
First Page
Client Setup (16-bit)
Client Setup (32-bit)
Multiple Server Connections