%META:TOPICPARENT{name="ConfigureUDAFeatures"}% = Making Connections through the Oracle Instant Client = 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: * {{{[username[:password]@]//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 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: * [[http://www.oracle.com/technology/tech/oci/instantclient/ic-faq.html#A4428|connection string formats]] * [[http://www.oracle.com/technology/tech/oci/instantclient/index.html|Oracle 10g Instant Client]] 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. %TOC% == Single-Tier == === Single-Tier on a Unix-like OS === # Log in to your client machine. # Use the sh or bash command to open a bourne or bash shell. # cd into the root of your Single-Tier driver installation. # Execute this command: {{{. ./openlink.sh}}} # Execute this command: {{{echo $ORACLE_HOME}}} # Use export to set {{{ORACLE_HOME}}} to the root of your local Instant Client Installation, as needed. # Use the echo command to display your library path. For example: #* AIX: {{{echo $LIBPATH}}} #* HP-UX: {{{echo $SHLIB_PATH}}} #* Other: {{{echo $LD_LIBRARY_PATH}}} # Use export to append the root of the Instant Client installation to your library path, as needed. # cd into the bin sub-directory of your Single-Tier driver installation. # Use a text editor to open the {{{openlink.ini}}} file. # 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 ;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 }}} # Pass the root of your Instant Client installation as {{{ORACLE_HOME}}}. # Save your changes and exit the file. === Single-Tier on Windows === # Log in to your client machine. # Expand the Windows Control Panel. # Locate the System utility. # Click on the Advanced tab. # Click the Environment button. # Scroll through the User and System variables. # Set an ORACLE_HOME variable that points to the root of the local Instant Client installation, if it does not exist. # Add the root of the Instant Client installation to PATH, if it is not already present. # Exit the System utility. == Multi-Tier == === Multi-Tier with Oracle Database Agent on a Unix-like OS === # Log in to the machine that contains your Multi-Tier server components. # Use the sh or bash command to open a bourne or bash shell. # cd into the root of your Multi-Tier installation. # Execute this command: {{{. ./openlink.sh}}} # Execute this command: {{{echo $ORACLE_HOME}}} # Use export to set {{{ORACLE_HOME}}} to the root of your local Instant Client Installation, as needed. # Use the echo command to display your library path. For example: #* AIX: {{{echo $LIBPATH}}} #* HP/UX: {{{echo $SHLIB_PATH}}} #* Other: {{{echo $LD_LIBRARY_PATH}}} # Use export to append the root of the Instant Client installation to your library path, as needed. # cd into the bin sub-directory of your Multi-Tier installation. # Use a text editor to open the {{{oplrqb.ini}}} file. # 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 }}} # Pass the root of your Instant Client installation to {{{ORACLE_HOME}}}. # Pass the root of your Instant Client installation to the relevant library path variable. # Ensure no semicolon appears in front of the relevant library path variable. # Save your changes and exit the file. # Start or restart the OpenLink Request Broker service. For example: {{{ ./oplshut -fy ./oplrqb +loglevel 7 +logfile oplrqb.log }}} === Multi-Tier with Oracle Database Agent on a Windows host === # Log in to the machine that contains your Multi-Tier server components installation. # Expand the Windows Control Panel. # Locate the System utility. # Click on the Advanced tab. # Click the Environment button. # Scroll through the User and System variables. # Set an {{{ORACLE_HOME}}} variable that points to the root of the Instant Client installation, if it does not exist. # Add the root of the Instant Client installation to {{{PATH}}}, if it is not already present. # Exit the System utility. # Use Notepad to open the {{{oplrqb.ini}}} file that appears in the bin sub-directory of the Multi-Tier installation. # 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 }}} # Pass the root of your Instant Client installation to {{{ORACLE_HOME}}}. # Pass the root of your Instant Client installation to the relevant library path variable. # Ensure no semicolon appears in front of the relevant library path variable. # Save your changes and exit the file. # Open your Windows Control Panel. # Locate the Services utility. (It may be in the Administrative Tools sub-folder.) # Launch Services. # Locate the OpenLink Request Broker Service in the list box. # Restart the OpenLink Request Broker service.