- Oracle requires a small amount of additional environmental configuration in the OpenLink Request Broker session rule book (
c:\Program Files\OpenLink Software\UDA\bin\oplrqb.ini
).
- Edit the file
c:\Program Files\OpenLink Software\UDA\bin\oplrqb.ini
with a suitable text editor such as Wordpad.
- Locate and edit the [Environment xxxxx] section where xxxxx matches your target database to ensure that any relevant environment variables pertaining to your system and target database are correct. You may need to consult with your database administrator to verify these.
- The following examples depict the environment sections for Oracle:
Oracle 9 (Full Client)
[Environment ORACLE9]
ORACLE_HOME = D:\oracle\product\9.2.1\Db_1
;ORACLE_SID = ORCL
;ORACLE_SERVER = T
;TWO_TASK = P:
;ODBC_CATALOGS = Y ; Uncomment after loading odbccat9.sql
;MULTIPLEX_LDA = 5 ; Allow 5 OpenLink clients on a single lda
;OPL_USR_TBLS_FIRST=Y ; Sort SQLTables starting with user tables
Oracle 10 (Full Client)
[Environment ORACLE10]
ORACLE_HOME = D:\oracle\product\10.1.0\Db_1
;ORACLE_SID = ORCL
;ORACLE_SERVER = T
;TWO_TASK = P:
;ODBC_CATALOGS = Y ; Uncomment after loading odbccat9.sql
;MULTIPLEX_LDA = 5 ; Allow 5 OpenLink clients on a single lda
;OPL_USR_TBLS_FIRST=Y ; Sort SQLTables starting with user tables
;OCI_CONNPOOL_MIN = 0 ; if not set defaults to 0
;OCI_CONNPOOL_MAX = 0 ; if not set defaults to OCI_CONNPOOL_MIN
;OCI_CONNPOOL_INCR = 1 ; if not set defaults to 1
;OCI_CONNPOOL_WAIT = TRUE ; if not set defaults to TRUE
Oracle 10 (Instant Client)
[Environment ORACLE10]
ORACLE_HOME = C:\Instant_client_10_2
;ORACLE_SID = ORCL
;ORACLE_SERVER = T
;TWO_TASK = P:
;ODBC_CATALOGS = Y ; Uncomment after loading odbccat9.sql
;MULTIPLEX_LDA = 5 ; Allow 5 OpenLink clients on a single lda
;OPL_USR_TBLS_FIRST=Y ; Sort SQLTables starting with user tables
;OCI_CONNPOOL_MIN = 0 ; if not set defaults to 0
;OCI_CONNPOOL_MAX = 0 ; if not set defaults to OCI_CONNPOOL_MIN
;OCI_CONNPOOL_INCR = 1 ; if not set defaults to 1
;OCI_CONNPOOL_WAIT = TRUE ; if not set defaults to TRUE
Make sure to save the changes after editing the oplrqb.ini
file.