Novell Documentation: Novell Audit 2.0 - Installing and Configuring the Oracle Client

D.4 Installing and Configuring the Oracle Client

If the Oracle database is not hosted on the Novell Audit server, you need to install and configure the Oracle client tools on the Novell 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.

D.4.1 Installing and Configuring the Instant Client for Linux or Solaris

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 Novell 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 Novell 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:
- For SERVERNAME, provide the name of the server or Oracle SID (usually this is in CAPS).
- For SERVER_DNS_NAME on the ADDRESS= line, provide the actual DNS name or IP address of the server.
- For SERVER_DNS_NAME on the SERVICE_NAME= line, provide the DNS name of the server or the global database name. The only time this should have to be different from the DNS name is when the DNS name contains dashes. Dashes are not allowed in global database names. If a different global database name is used, provide it here.
  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:
1. 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
```
2. Add the following below the LD_LIBRARY_PATH line:
```
export TNS_ADMIN=/opt/novell/naudit
```
3. 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.

D.4.2 Installing and Configuring the Instant Client for Windows

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:
1. Right-click My Computer.
2. Click Properties > Advanced > Environment Variables.
3. In System Variables, click New.
4. To add a TNS_ADMIN environment variable, enter TNS_ADMIN in the Variable Name field and drive:\oracle in the Variable Value field. Click OK.
5. In System Variables, click New.
6. To add an ORACLE_HOME environment variable, enter ORACLE_HOME in the Variable Name field and drive:\oracle in the Variable Value field.
Create 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:
- For SERVERNAME, provide the name of the server or Oracle SID (usually this is in CAPS).
- For SERVER_DNS_NAME on the ADDRESS= line, provide the actual DNS name or IP address of the server.
- For SERVER_DNS_NAME on the SERVICE_NAME= line, provide the DNS name of the server or the global database name. The only time this should have to be different from the DNS name is when the DNS name contains dashes. Dashes are not allowed in global database names. If a different global database name is used, provide it here.
  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.