6.12 Oracle

The Oracle channel allows the logging server to log events to an Oracle database. The logging server can use the Oracle channel to create the central data store or a filtered database.

The Oracle channel driver is used only on platforms where Oracle can run natively, such as Windows, Linux, and Solaris. If you are running the Secure Logging Server on NetWare, create a JDBC channel to connect to the Oracle server. For more information, see Section 6.7, JDBC.

NOTE: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.

For the Oracle channel to function properly, you must install the Oracle client libraries on the same server as the Secure Logging Server.

6.12.1 Oracle Channel Driver

When the Oracle Channel object configuration is loaded in the logging server’s memory, the Oracle channel driver, lgdora, automatically creates the following table structure for the Oracle data store:

Figure 6-3 Oracle Table Structure

Image displaying Oracle table format

The table name is defined in the Oracle Channel object configuration page. The default table name is NAUDITLOG.

6.12.2 Oracle Channel Object

The Oracle Channel object stores the information the Oracle driver needs to write events to an Oracle database.

The following table provides a description of each Channel object attribute.

IMPORTANT:You must restart the logging server to effect any changes in Channel object configuration. For more information, see Section H.3, Secure Logging Server Startup Commands.

Table 6-14 Oracle Channel Object Attributes

Attribute

Description

Configuration

 

Database

 

Name

The transport name in the TNSNAMES.ORA file used by the Oracle client to connect to the Oracle database.

Table

The name of the database table to which the logging server writes events.

The Oracle Server channel driver, lgdora, automatically creates this table when the logging server first loads the current Channel object configuration in memory. For information on the table structure, see Section 6.12.1, Oracle Channel Driver.

Do not use hyphens, spaces, or other special characters in the table name. The default table name is NAUDITLOG.

NOTE:To use the Novell Audit Reporting Application’s reports with an Oracle database, you must create a table view. For information on this procedure, see Section D.9, Creating a View in Oracle.

User

The user name for the account that has access to the naudit tablespace. The default username is auditusr.

Password

The password for the audituser account, which the logging server uses to authenticate with the database.

Test Credentials

This option tests the Oracle channel configuration to verify the Oracle driver (lgdora) can connect to the database.

When you click the Test Credentials link, you are prompted for the following:

  • JDBC Class: The package and name of the Java Class providing JDBC connectivity.

  • Host: The IP Address or host name of the database server. If a host name is specified, only the first address associated with that name is used.

Provide the required information, then click OK. The Oracle driver tests the Oracle Channel object configuration by attempting to make a connection to the Oracle database.

Status

Allows you to enable or disable the Channel object. By default, all Channel objects are enabled. This means that the logging server loads the Channel object’s configuration in memory at startup.

IMPORTANT:The Channel object must be located in a supported Channel container for the logging server to use it. For more information on the logging server’s Channel Container property, see Logging Server Object Attributes .

If you select the Disabled option, you must restart the Secure Logging Server for the setting to become effective. Thereafter, the logging server cannot load the object’s configuration until you select Enabled.

For information on unloading the logging server, see Section H.3, Secure Logging Server Startup Commands.