Connecting Borland Database Engine applications to Oracle Workgroup Server 7 (Updated for Oracle 8)

by George Pujol - gpujol@interserv.com


Server Setup

Contents


NETWARE
Netware Loadable Modules

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.

CONFIG.ORA File

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\SERVICES
LISTENER.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)
                           )

WINDOWS NT
Services

Using Control Panel check that the following NT services are properly started:
- OracleStartORCL
- OracleServiceORCL
- OracleTNSListener

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

TCP/IP Server Files
HOSTS

192.2.3.9 orac # an arbitrary IP address.

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


Copyright ã 1999, George Pujol - Pujol Computer Consulting Inc.
This document cannot be modified without prior consent from Pujol Computer Consulting Inc.