Our Single-Tier "Lite" Edition drivers and Multi-Tier "Enterprise" Edition database agents can communicate with remote Oracle databases through the Oracle Instant Client libraries. Instant Client allows you to run applications without installing the full Oracle client (SQL*Net or Net8/9/10/11) or having an ORACLE_HOME. It supports two basic connection string formats:
Naming methods that use a configuration file (such as tnsnames.ora or sqlnet.ora) for name translation are also possible, if the environment variable TNS_ADMIN is set to point to the directory containing the file.
Oracle documentation:
Additionally, the ORACLE_HOME and relevant library path variables must point to the root of the Oracle Instant Client installation.
These variables appear in the environment and various configuration files.
Follow the instructions appropriate to your driver and OS, to ensure that your environment and configuration files are properly configured.
[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 ;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
[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
./oplshut -fy ./oplrqb +loglevel 7 +logfile oplrqb.log
[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