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
-
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.
- 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 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;
- 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.