If the Oracle database is not hosted on the Nsure Audit server, you need to install and configure the Oracle client tools on the Nsure Audit server. You can use either the Oracle 9 Client or greater or the Instant Client.
This section includes information on installing and configuring the Instant Client:
If you are using the Oracle client, use the Oracle documentation for installation information, and then follow the configuration tasks in this section.
Download the Instant Client for Linux or Solaris from the Oracle Instant Client web page.
IMPORTANT:On Linux and Solaris systems, the 32-bit version of the Oracle client is required. The 64-bit version does not work because Nsure Audit is compiled as a 32-bit application.
(Conditional) On Linux, as user root install the Oracle Instant Client RPM on the Secure Logging Server:
rpm -Uvh oracle-instantclient-basic-10.1.0.3-1.i386.rpm
(Conditional) On Solaris, as user root extract the Oracle Instant Client zip to the Secure Logging Server in a directory such as /usr/lib/oracle/10.1.0.3/client/lib.
Change to the Oracle client directory:
cd /usr/lib/oracle/10.1.0.3/client/lib
Create a symbolic link so that Nsure Audit can find its linked library:
ln -s libclntsh.so.10.1 libclntsh.so.9.0
Set up TNS for the database by creating a tnsnames.ora file in the /opt/novell/naudit directory.
You can also copy the tnsnames.ora file from the $ORACLE_HOME/admin/network folder on the Oracle server.
Add the following lines to the tnsnames.ora file:
(DESCRIPTION
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = SERVER_DNS_NAME)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = SERVER_DNS_NAME)
(SID=ORACLE_SID)
[Optional. If you use the SID, do not use SERVICE_NAME.]
)
)
Note the following about the lines:
If you are unsure of what to put in the SERVICE_NAME line, run lsnrctl status from the Oracle_Home/bin directory. Find the line that says Service followed by a name in quotes. The name in quotes is the name to provide in SERVER_DNS_NAME.
You can use the Oracle SID of the server instead of SERVICE_NAME. The SID is usually the server name.
Add the LD_LIBRARY_PATH and TNS_ADMIN paths to /etc/init.d/novell-naudit.
Open /etc/init.d/novell-naudit in a text editor, such as vi.
In the novell-naudit init file, complete the following:
Change the LD_LIBRARY_PATH= to the following:
export LD_LIBRARY_PATH=/usr/lib:/opt/novell/naudit:/usr/lib/oracle/10.1.0.3/client/lib:$LD_LIBRARY_PATH
Add the following below the LD_LIBRARY_PATH line:
export TNS_ADMIN=/opt/novell/naudit
Change the export LD_LIBRARY_PATH LC_ALL line to the following:
export LC_ALL
Save the file and exit the text editor.
Optionally, you can add the LD_LIBRARY_PATH and TNS_ADMIN paths to the profile script /etc/profile.
Download the Instant Client for Windows from the Oracle Instant Client web page. Download both the Basic and ODBC packages.
Create a drive:\oracle folder; unzip the instantclient-odbc-win32-10.1.0.3-20050113.zip to this folder.
Unzip the contents of instantclient-basic-win32-10.1.0.3-20050113.zip to drive:\oracle.
Be sure to put oci.dll in the same folder as odbc_install.bat.
To install the ODBC driver, double-click odbc_install.bat.
The file might also appear as odbc_install if file extensions are hidden.
Add certain environment variables to the Windows system variables:
Right-click
.Click
> > .In
, click .To add a TNS_ADMIN environment variable, enter TNS_ADMIN in the drive:\oracle in the Variable Value field. Click .
field andIn
, click .To add an ORACLE_HOME environment variable, enter ORACLE_HOME in the drive:\oracle in the field.
field andCreate a tnsnames.ora file in the drive:\oracle folder.
Verify that Notepad doesn’t append a .txt extension to the file.
Add the following lines to the tnsnames.ora file:
SERVERNAME =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = SERVER_DNS_NAME)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = SERVER_DNS_NAME)
)
)
Note the following about the lines:
If you are unsure of what to put in the SERVICE_NAME line, run lsnrctl status from the Oracle_Home/bin directory. Find the line that says Service followed by a name in quotes. The name in quotes is the name to provide in SERVER_DNS_NAME.
Save the file and close Notepad.
Reboot the server in order to get the ORACLE_HOME variable working.