InTrust 11.6 - Preparing for Auditing Oracle

Setting Up ODBC

To provide for collection of Oracle audit trails, you have to install and tune the Oracle ODBC driver on the Windows-based computer responsible for data gathering. You can either install the driver from your Oracle Client CD or download and configure Oracle Instant Client.

Installing ODBC driver from the Oracle Client CD

To install and configure Oracle ODBC driver from the Oracle Client CD, for example, for Oracle 9i Release 2:

1. When running the setup, select the Custom installation type.
2. Select components to install:
   • Oracle Windows Interfaces 9.2.0.1.0—this component contains Oracle ODBC driver
   • Oracle Network Utilities 9.2.0.1.0—this component will help you create TNS names automatically with Net Manager
   • SQL *Plus 9.2.0.1.0—this component can be used to verify database connection settings
3. Follow the installation steps. During the installation, you should specify the Oracle home directory (default value is OraHome92).
4. When the installation is complete, run Net Manager by selecting Start | Program Files | Oracle in [Oracle home directory] | Configuration and Migration Tools | Net Manager.
5. Select Local | Service Naming, and then click Create. Follow the Net Service Name Wizard to configure the net service name.
6. After you complete the wizard, save the configuration.

Downloading Oracle Instant Client

1. Download “Instant Client Package—Basic” and “Instant Client Package—ODBC” for Microsoft Windows from https://www.oracle.com/database/technologies/instant-client.html.
2. Carry out the installation procedure described in the Instant Client release notes (https://www.oracle.com/database/technologies/releasenote-odbc-ic.html), in particular:
   • Unpack both Instant Client packages into a target directory, for example, c:\Oracle\InstantClient.
   • In the PATH system environment variable, specify the target directory name.
   • In a command shell window (DOS-like), run the odbc_install.exe file from the package.
   • After its execution, in the ORACLE_HOME and TNS_ADMIN system environment variables, specify the target directory name (C:\Oracle\InstantClient for our example).
3. Generate a TNSNAMES.ORA file, either using the Net Manager (choose Local Net Service Name Configuration) on your Oracle server, or manually. This file will look like the following:
   TnsName=
    (DESCRIPTION =
     (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = MyOracleServer)(PORT = Port)
      )
     )
     (CONNECT_DATA =
      (SERVICE_NAME = MyOracleService)
     )
    )
   Here you need to specify:
   • TNS name—can be the same as the database name; this name will be later used in the connection string to identify the database to connect to
   • Oracle Server name—the computer hosting Oracle database (for example, MyOracleServer); an IP address can be used
   • Port—the default is 1521
   • Oracle service name—the database to connect to (for example, MyOracleService)
4. Save the file, and reboot the computer.