OraFAQ Forum: Security » Audit Destination Problem

Home » RDBMS Server » Security » Audit Destination Problem (Oracle 10gR2)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Audit Destination Problem [message #550303]

Sun, 08 April 2012 06:13

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

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

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.

Attachment: ora_4396.aud.txt.txt
(Size: 0.75KB, Downloaded 443 times)

Report message to a moderator

Re: Audit Destination Problem [message #550476 is a reply to message #550471]

Mon, 09 April 2012 13:50

Michel Cadot
Messages: 67946
Registered: March 2007
Location: Nanterre, France, http://...

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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Sep 19 08:58:08 CDT 2021