11-2
User Guide for Cisco Security MARS Local Controller
78-17020-01
Chapter 11 Configuring Database Applications
Oracle Database Server Generic
SQL> conn / as sysdba;
SQL> @$ORACLE_HOME/rdbms/admin/cataudit.sql
Step 2
Enable auditing to the database by adding the following entry to the Oracle instance initialization file,
usually named init<SID>.ora
AUDIT_TRAIL=DB
This file is usually located in $ORACLE_BASE/admin/<SID>/pfile, where <SID> is the name of the
Oracle instance.
If a binary initialization file is used for this instance, make sure you update it first. This file is usually
located in $ORACLE_HOME/dbs and named spfile<SID>.ora. Ask your DBA about the location of
these files as well as the policies applied for this server.
Step 3
Restart the database to activate the change made to the initialization file.
[oracle@server]$ sqlplus /nolog
SQL> conn / as sysdba;
SQL> shutdown immediate;
SQL> startup;
Step 4
Turn on all the logs that you want to audit. The following example is turning on the “audit session”.
SQL> audit session;
Audit succeeded.
Step 5
Repeat the previous step for all the logs that you want to audit.
Step 6
Create a user account on this server and grant select privilege for the view dba_audit_trail. Our example
assumes the user has login name “pnuser”.
SQL> grant select on dba_audit_trail to pnuser
You’ll use “pnuser” as the value for “User Name” in the MARS setup.
Step 7
To test that everything was properly configured, audit logs are written to the database and “pnuser” has
read access to them, execute the following commands:
[
oracle@server]$ sqlplus pnuser/<password>@<oracle_server>
SQL> select count(*) from dba_audit_trail;
COUNT(*)
----------
3
If the above count is anything but zero, congratulations, you have successfully configured the Oracle
Server! You will have to repeat the above procedure for every Oracle server that you want to report audit
logs to MARS.
Add the Oracle Database Server to MARS
To represent the Oracle database server in the web interface, follow these steps:
Step 1
Click
Admin >
Security and Monitor Devices >
Add
.
Содержание CS-MARS-20-K9 - Security MARS 20
Страница 20: ...Contents xx User Guide for Cisco Security MARS Local Controller 78 17020 01 ...
Страница 356: ...17 16 User Guide for Cisco Security MARS Local Controller 78 17020 01 Chapter 17 Network Summary Summary Page ...
Страница 420: ...20 28 User Guide for Cisco Security MARS Local Controller 78 17020 01 Chapter 20 Queries and Reports Reports ...
Страница 580: ...Glossary GL 4 User Guide for Cisco Security MARS Local Controller 78 17020 01 ...