Configuring the Oracle adapter

You must configure Security Directory Integrator to locate the JDBC OCI driver and Oracle Net Services.

About this task

To use OCI communication, the adapter must have access to the JDBC OCI driver and the Oracle Net Services files, tnsnames.ora and sqlnet.ora.
Note: To locate the JDBC OCI driver, you must amend the path variable to include the ORACLE_HOME/bin directory or the Instant Client directory. Depending on the Security Directory Integrator service, you must configure the path variable slightly differently, as described in the following steps.

Procedure

  1. Determine which Security Directory Integrator service is used on your server.

    There are two Security Directory Integrator services that can exist or coexist on your Security Directory Integrator target.

    • The IBM® Security Identity Adapter, which is called ITDIAsService.exe.
    • The IBM Security Directory Integrator service, which is called ibmdiservice.exe.
  2. For the ITDIAsService service, edit the ImagePath registry variable in the following location: HKLM\SYSTEM\ControlSet001\Service\IBM Security Identity Adapter.
    Note: The value of ImagePath is an expandable String Value of REG_EXPAND_SZ Type.
    • For a Database Client installation, edit the ImagePath variable to include %ORACLE_HOME%\bin as follows:
    "C:\Program Files\IBM\TDI\V7.2\timsol\ITDIAsService.exe" … 
    -Djava.library.path ="C:\Program Files\IBM\TDI\V7.2\libs;
    %ORACLE_HOME%\bin;%PATH%" …
    Note: Use %ORACLE_HOME% in the ImagePath variable only when ORACLE_HOME is defined as a System variable on Windows. Otherwise, you must explicitly include the Oracle home bin directory as follows:
    "C:\Program Files\IBM\TDI\V7.2\timsol\ITDIAsService.exe" …
    -Djava.library.path ="C:\Program Files\IBM\TDI\V7.2\libs;
    C:\app\administrator\product\11.2.0\client_1\bin;%PATH%" …
    • For an Instant Client installation, edit the ImagePath variable to include the directory of the Instant Client files as follows:
      "C:\Program Files\IBM\TDI\V7.2\timsol\ITDIAsService.exe" …
      -Djava.library.path ="C:\Program Files\IBM\TDI\V7.2\libs;
      C:\app\administrator\product\11.2.0\client_1;%PATH%" …
  3. For the ibmdiservice service, edit the path variable in the ibmdiservice.props properties file. This properties file is in the following directory:
    C:\Program Files\IBM\TDI\V7.2\timsol
    • For a Database Client installation, edit the path variable to include the Oracle home bin directory as follows:
      path=C:\Program Files\IBM\TDI\V7.2\jvm\jre\bin;C:\Program Files\IBM\TDI\V7.2\
      libs;C:\app\administrator\product\11.2.0\client_1\bin;
    • For an Instant Client installation, set the path variable to the Oracle home directory as follows:
      path=C:\Program Files\IBM\TDI\V7.2\jvm\jre\bin;C:\Program Files\IBM\TDI\V7.2\
      libs;C:\app\administrator\product\11.2.0\client_1;
  4. For both services, you must configure Security Directory Integrator to locate the Oracle Net Services files as follows:
    • For a Database Client installation, define the ORACLE_HOME environment variable in the Windows registry so that Security Directory Integrator can locate the Oracle Net Services files.
      Note: Alternatively, you can define the ORACLE_HOME as a System variable in Windows.

      An example ORACLE_HOME environment value is:

      ORACLE_HOME=C:\app\administrator\product\11.2.0\client_1
    • For an Instant Client installation, you must define the TNS_ADMIN environment variable, which is an Oracle Client variable, to point to the location (directory) of the ONS configuration files.

      An example TNS_ADMIN environment value is:

      TNS_ADMIN=C:\app\administrator\product\11.2.0\client_1
      Note: If you define ORACLE_HOME, the JDBC OCI driver locates the Oracle Net Services files in the network\admin directory of the Oracle home directory. If you define TNS_ADMIN, the JDBC OCI driver locates the Oracle Net Services files in the specified directory.