To prepare the Oracle database, you must create a tablespace and user account on the Oracle server. The naudit tablespace and auditusr account enable the Secure Logging Server to log data to Oracle.
The auditusr account must have access to the naudit tablespace. The naudit tablespace must have an unlimited quota.This setup is the minimum that is required in order to have the Secure Logging Server connect to the Oracle database.
Log in to the Oracle server:
On Windows, log in to the server as Administrator.
On Linux or Solaris, log in to the system as the Oracle user. If you are logged into X-Windows, open a terminal window, such as konsole, xterm, or gnome-terminal.
(Conditional) On Linux or Solaris, execute SQLPlus by completing the following:
Enter the following command:
$ORACLE_HOME/bin/sqlplus system@servername
The username is system, and the servername is the database SID.
Specify the password when prompted.
(Conditional) On Windows, start SQLPlus by completing the following:
Click
> > > > .NOTE:The Oracle home name can vary depending on the Oracle configuration.
If the Start menu option is not available, execute SQLPlus from the Oracle_Home/bin directory. For example, if the Oracle_Home directory is drive:\oracle\ora10, then type the following at the command prompt:
drive:\oracle\ora10\bin\sqlplus system@servername
Specify the username and password for the system account at the login dialog box.
Specify the host string, which is usually the database SID or the global dbname (the name of the server).
At the SQLPlus prompt, create the naudit tablespace by typing the following lines.
CREATE TABLESPACE naudit
DATAFILE '/var/opt/oracle/SERVERNAME/naudit.dbf'
SIZE 10M
AUTOEXTEND ON NEXT 10M
MAXSIZE 7500M;
Press Enter at the end of each line. The semicolon at the end of the last line notifies SQLPlus that the command is finished.
Note the following about the lines:
NOTE:You do not need to create the database table; the Oracle driver, lgdora, automatically creates this table when the logging server first loads the current Channel object configuration in memory. For more information on the table structure, see Section 6.12.1, Oracle Channel Driver.
At the SQLPlus prompt, create the auditusr account by typing the following lines:
CREATE USER AUDITUSR
IDENTIFIED BY passwd
DEFAULT TABLESPACE naudit
TEMPORARY TABLESPACE TEMP;
Press Enter at the end of each line. The semicolon at the end of the last line notifies SQLPlus that the command is finished. Replace passwd with the appropriate password.
At the SQLPlus prompt, use the following commands to grant the auditusr account rights to connect to the database: