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.
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
The table name is defined in the Oracle Channel object configuration page. The default table name is NAUDITLOG.
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 |
|
|
The transport name in the TNSNAMES.ORA file used by the Oracle client to connect to the Oracle database. |
|
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. |
|
The user name for the account that has access to the naudit tablespace. The default username is auditusr. |
|
The password for the audituser account, which the logging server uses to authenticate with the database. |
|
This option tests the Oracle channel configuration to verify the Oracle driver (lgdora) can connect to the database. When you click the link, you are prompted for the following:
Provide the required information, then click . 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 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 .For information on unloading the logging server, see Section H.3, Secure Logging Server Startup Commands. |