Home » RDBMS Server » Security » Audit Destination Problem (Oracle 10gR2)
Audit Destination Problem [message #550303] Sun, 08 April 2012 06:13 Go to next message
jimmybhandari
Messages: 3
Registered: February 2012
Junior Member
Hi,

I have a single instance database, version 10gR2 on linux - Cent Os, with the following settings for the audit trials
SQL> show parameter aud

NAME TYPE VALUE
audit_file_dest string /u/p3/admin/DB1/audit
audit_sys_operations boolean FALSE
audit_syslog_level string
audit_trail string NONE

The minimal audits that get generated with audit_trial = none are going to the proper destination "/u/p3/admin/DB1/audit".

The problem is that in addition to going to "/u/p3/admin/DB1/audit", some of the audit files (specifically those that get generated when i startup the database)
are also getting created in $ORACLE_HOME/rdbms/audit/ directory.

What can be the reason for this and is there a way I can prevent this from happening?

Report message to a moderator

Re: Audit Destination Problem [message #550457 is a reply to message #550303] Mon, 09 April 2012 11:55 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
Please read and follow the forum guidelines, to enable us to help you:

http://www.orafaq.com/forum/t/88153/0/

what happens after setting AUDIT_TRAIL=DB?

Report message to a moderator

Re: Audit Destination Problem [message #550471 is a reply to message #550303] Mon, 09 April 2012 13:41 Go to previous messageGo to next message
jimmybhandari
Messages: 3
Registered: February 2012
Junior Member
Hi Swan, Thanks for your reply. Just to give you more info on what happens with audit_trial=none, I am posting contents of the audit file. This gets generated when I startup the database. All other audit files go to the location I had given using audit_file_dest except this one which goes to both audit_file_dest as well as to ORACLE_HOME/rdbms/admin/audit .

The same thing is happening with audit_trial='db'. Every time I issue Startup, it generates a similar file that goes to both locations.

Report message to a moderator

Re: Audit Destination Problem [message #550476 is a reply to message #550471] Mon, 09 April 2012 13:50 Go to previous message
Michel Cadot
Messages: 68771
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Connections as SYSDBA are ALWAYS audited.

Regards
Michel

Report message to a moderator

Previous Topic: create user using java shell
Next Topic: Spanish character encryption problem in UTF8
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Wed Nov 19 19:40:00 CST 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.