OpenLink UDA Wiki Web

UdaWikiWeb.ConfigureOracleInstantClientSupport

  • Topic
  • Discussion
    • UdaWikiWeb.ConfigureOracleInstantClientSupport(Last) -- DAVWikiAdmin? , 2008-09-09 17:17:02 Edit
    [TXT]
    [PLAIN]
    [DOCBOOK]
    WebDAV System Administrator 2008-09-09 16:17:02

    Configure Oracle Instant Client Support

    OpenLink's Single-Tier (Lite Edition) drivers and Multi-Tier database agents can communicate with remote Oracle DBMSs via a local copy of the Oracle Instant Client libraries. Instant Client allows you to run applications without installing the standard Oracle client (SQL*Net or Net8) or having an ORACLE_HOME. It supports two basic connection string formats:

    • //host:[port][/service name]

    e.g. dbase-server-5:4321/ORDERS

    • an Oracle Net keyword-value pair such as
    (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp) (HOST=dlsun242)
    (PORT=5521)) (CONNECT_DATA=(SERVICE_NAME=bjava21)))

    Naming methods that require a configuration file (such as tnsnames.ora or sqlnet.ora) for name translation can also be used if the environment variable TNS_ADMIN is set to point to the directory containing the file.


    Additionally, the ORACLE_HOME and relevant library path variables need to point to the root of the Oracle Instant Client installation. These variables appear in the environment and various OpenLink configuration files.

    Use the following instructions to ensure that your environment and configuration files are properly configured.

    Single-Tier Unix

    1. Login to your client machine.

    2. Use the sh or bash command to open a bourne or bash shell.

    3. cd into the root of your OpenLink installation.

    4. Execute this command: . ./openlink.sh

    5. Execute this command: echo $ORACLE_HOME

    6. Use export to set ORACLE_HOME to the root of your local Instant Client Installation, as needed.

    7. Use the echo command to display your library path. For example:

    • AIX: echo $LIBPATH
    • HP/UX: echo $SHLIB_PATH
    • Other: echo $LD_LIBRARY_PATH

    8. Use export to append the root of the Instant Client installation to your library path, as needed.

    9. cd into the bin sub-directory of your OpenLink installation.

    10. Use a text editor to open the openlink.ini file.

    11. Locate the [Environment Oracle] section that applies to you. For example: 

    [Environment Oracle 9.x]
ORACLE_HOME        = /dbs3/oracle/oracle9i/32bit/v9.2.0.1.0
ORACLE_SID         = ora9264
;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
SHOW_REMARKS       = N  ; Retrieve SQLColumns REMARKS field
CURSOR_SENSITIVITY = LOW        ; Set to HIGH after loading odbccat9.sql
;OCI_PREFETCH_ROWS      = 100   ; Number of rows to prefetch
;OCI_PREFETCH_MEMORY    = 65535 ; Amount of memory to use for prefetching
;NLS_LANG               = AMERICAN_AMERICA.UTF8 ; Unicode connection

[Environment Oracle 10.x]
ORACLE_HOME        = /dbs3/oracle/instantclient_10_2
ORACLE_SID         = ora10g64
;ORACLE_SERVER          = T
;TWO_TASK               = P:
;ODBC_CATALOGS          = Y     ; Uncomment after loading odbccat10.sql
;MULTIPLEX_LDA          = 5     ; Allow 5 OpenLink clients on a single lda

;MULTIPLEX_LDA          = 5     ; Allow 5 OpenLink clients on a single lda
;OPL_USR_TBLS_FIRST     = Y     ; Sort SQLTables starting with user tables
SHOW_REMARKS       = N  ; Retrieve SQLColumns REMARKS field
CURSOR_SENSITIVITY = LOW        ; Set to HIGH after loading odbccat10.sql
;OCI_PREFETCH_ROWS      = 100   ; Number of rows to prefetch
;OCI_PREFETCH_MEMORY    = 65535 ; Amount of memory to use for prefetching
;NLS_LANG               = AMERICAN_AMERICA.UTF8 ; Unicode connection


    12. Pass the root of your Instant Client installation to ORACLE_HOME.

    13. Save your changes and exit the file.

    Single-Tier Windows

    1. Login to your client machine.

    2. Expand the Windows Control Panel.

    3. Locate the System utility.

    4. Click on the Advanced tab.

    5. Click the Environment button.

    6. Scroll through the User and System variables.

    7. Set an ORACLE_HOME variable that points to the root of the local Instant Client installation, if it does not exist.

    8. Add the root of the Instant Client installation to PATH, if it is not already present.

    9. Exit the System utility.

    Multi-Tier Unix


    1. Login to the machine that contains your OpenLink Multi-Tier server components.

    2. Use the sh or bash command to open a bourne or bash shell.

    3. cd into the root of your OpenLink installation.

    4. Execute this command: . ./openlink.sh

    5. Execute this command: echo $ORACLE_HOME

    6. Use export to set ORACLE_HOME to the root of your local Instant Client Installation, as needed.

    7. Use the echo command to display your library path. For example:

    • AIX: echo $LIBPATH
    • HP/UX: echo $SHLIB_PATH
    • Other: echo $LD_LIBRARY_PATH

    8. Use export to append the root of the Instant Client installation to your library path, as needed.

    9. cd into the bin sub-directory of your OpenLink installation.

    10. Use a text editor to open the oplrqb.ini file.

    11. Locate the [Environment ORACLE] section that applies to you. For example: 

    [Environment ORACLE90]
ORACLE_HOME        = /dbs3/oracle/oracle9i/32bit/v9.2.0.1.0
ORACLE_SID         = ora9264
;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
SHOW_REMARKS       = N  ; Retrieve SQLColumns REMARKS field
CURSOR_SENSITIVITY = LOW        ; Set to HIGH after loading odbccat9.sql
;OCI_PREFETCH_ROWS  = 100       ; Number of rows to prefetch
;OCI_PREFETCH_MEMORY = 65535    ; Amount of memory to use for prefetching
LD_LIBRARY_PATH = /dbs3/oracle/oracle9i/32bit/v9.2.0.1.0/lib
;SHLIB_PATH      =
;LIBPATH         = /dbs/oracle81/lib    ; Find AIX shared libraries
;NLS_LANG        = AMERICAN_AMERICA.UTF8 ; Uncomment for Unicode connections

[Environment ORACLE100]
ORACLE_HOME        = /dbs3/oracle/instantclient_10_2
ORACLE_SID         = ora10g64
;ORACLE_SERVER      = T
;TWO_TASK           = P:
;ODBC_CATALOGS      = Y         ; Uncomment after loading odbccat10.sql
;MULTIPLEX_LDA      = 5         ; Allow 5 OpenLink clients on a single lda
;OPL_USR_TBLS_FIRST = Y         ; Sort SQLTables starting with user tables
SHOW_REMARKS       = N  ; Retrieve SQLColumns REMARKS field
CURSOR_SENSITIVITY = LOW        ; Set to HIGH after loading odbccat10.sql
;OCI_PREFETCH_ROWS  = 100       ; Number of rows to prefetch
;OCI_PREFETCH_MEMORY = 65535    ; Amount of memory to use for prefetching
;LD_LIBRARY_PATH = /dbs/oracle100/lib   ; Find shared libraries
;SHLIB_PATH      = /dbs/oracle100/lib   ; Find HP/UX shared libraries
;LIBPATH         = /dbs/oracle100/lib   ; Find AIX shared libraries
;NLS_LANG        = AMERICAN_AMERICA.UTF8 ; Uncomment for Unicode connections


    12. Pass the root of your Instant Client installation to ORACLE_HOME.

    13. Pass the roof of your Instant Client installation to the relevant library path variable.

    14. Ensure no semicolon appears in front of the relevant library path variable.

    15. Save your changes and exit the file.

    16. Start or restart the OpenLink Request Broker service. For example: 

    ./oplshut -fy
./oplrqb +loglevel 7 +logfile oplrqb.log

    Multi-Tier Windows

    1. Login to the machine that contains your OpenLink server components installation.

    2. Expand the Windows Control Panel.

    3. Locate the System utility.

    4. Click on the Advanced tab.

    5. Click the Environment button.

    6. Scroll through the User and System variables.

    7. Set an ORACLE_HOME variable that points to the root of the Instant Client installation, if it does not exist.

    8. Add the root of the Instant Client installation to PATH, if it is not already present.

    9. Exit the System utility.

    10. Use Notepad to open the oplrqb.ini file that appears in the bin sub-directory of the OpenLink installation.

    11. Locate the [Environment ORACLE] section that applies to you. For example: 

    [Environment ORACLE90]
ORACLE_HOME        = /dbs3/oracle/oracle9i/32bit/v9.2.0.1.0
ORACLE_SID         = ora9264
;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
SHOW_REMARKS       = N  ; Retrieve SQLColumns REMARKS field
CURSOR_SENSITIVITY = LOW        ; Set to HIGH after loading odbccat9.sql
;OCI_PREFETCH_ROWS  = 100       ; Number of rows to prefetch
;OCI_PREFETCH_MEMORY = 65535    ; Amount of memory to use for prefetching
LD_LIBRARY_PATH = /dbs3/oracle/oracle9i/32bit/v9.2.0.1.0/lib
;SHLIB_PATH      =
;LIBPATH         = /dbs/oracle81/lib    ; Find AIX shared libraries
;NLS_LANG        = AMERICAN_AMERICA.UTF8 ; Uncomment for Unicode connections

[Environment ORACLE100]
ORACLE_HOME        = /dbs3/oracle/instantclient_10_2
ORACLE_SID         = ora10g64
;ORACLE_SERVER      = T
;TWO_TASK           = P:
;ODBC_CATALOGS      = Y         ; Uncomment after loading odbccat10.sql
;MULTIPLEX_LDA      = 5         ; Allow 5 OpenLink clients on a single lda
;OPL_USR_TBLS_FIRST = Y         ; Sort SQLTables starting with user tables
SHOW_REMARKS       = N  ; Retrieve SQLColumns REMARKS field
CURSOR_SENSITIVITY = LOW        ; Set to HIGH after loading odbccat10.sql
;OCI_PREFETCH_ROWS  = 100       ; Number of rows to prefetch
;OCI_PREFETCH_MEMORY = 65535    ; Amount of memory to use for prefetching
;LD_LIBRARY_PATH = /dbs/oracle100/lib   ; Find shared libraries
;SHLIB_PATH      = /dbs/oracle100/lib   ; Find HP/UX shared libraries
;LIBPATH         = /dbs/oracle100/lib   ; Find AIX shared libraries
;NLS_LANG        = AMERICAN_AMERICA.UTF8 ; Uncomment for Unicode connections


    12. Pass the root of your Instant Client installation to ORACLE_HOME.

    13. Pass the roof of your Instant Client installation to the relevant library path variable.

    14. Ensure no semicolon appears in front of the relevant library path variable.

    15. Save your changes and exit the file.

    16. Open your Windows Control Panel.

    17. Locate the Services utlity. (It may be in the Administrative Tools sub-folder.)

    18. Launch Services.

    19. Locate the OpenLink Request Broker Service in the list box.

    20. Restart the OpenLink Request Broker service.