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.
NOTE: Oracle no longer supports NetWare; therefore, the Oracle Channel object cannot be used in NetWare environments.
WARNING: For the Oracle channel to function properly, you must install the Oracle client libraries on the same server as the Secure Logging Server.
The Oracle channel drive, lgdora.*, does not create the table for the Oracle data store. Therefore, to log to an Oracle database, you must manually create the data store using the following table structure:
CREATE TABLE LOG (
"SOURCEIP" INTEGER NOT NULL,
"CLIENTTIMESTAMP" INTEGER NOT NULL,
"SERVERTIMESTAMP" INTEGER NOT NULL,
"COMPONENT" VARCHAR2(255) NOT NULL,
"EVENTID" INTEGER NOT NULL,
"SEVERITY" INTEGER NOT NULL,
"GROUPING" INTEGER NOT NULL,
"TEXT1" VARCHAR2(255),
"TEXT2" VARCHAR2(255),
"VALUE1" INTEGER NOT NULL,
"VALUE2" INTEGER NOT NULL,
"MIMETYPE" INTEGER NOT NULL,
"DATASIZE" INTEGER NOT NULL,
"DATA" RAW(2000))
TABLESPACE "USERS" PCTFREE 5 PCTUSED 60 INITRANS 2 STORAGE (INITIAL 40960
NEXT 8192 PCTINCREASE 0)
For information on configuring an Oracle Channel object, see Oracle Channel Configuration.
For more information on using Nsure Audit, see Nsure Audit Help.
A trademark symbol (®, TM, etc.) denotes a Novell trademark. An asterisk (*) denotes a third-party trademark. For information on trademarks, see Legal Notices.