Re: Oracle Auditing

From: sandeep pande <sandy.soft80_at_gmail.com>
Date: Thu, 13 May 2010 20:43:56 -0700 (PDT)
Message-ID: <7fe78eff-3b00-4c2f-ac54-fcd0ac9dc1b1_at_s4g2000prh.googlegroups.com>

On Mar 16, 6:21 pm, The Magnet <a..._at_unsu.com> wrote:
> Hi,
>
> Previously one of our DBA's must have turned on auditing.  We get this
> error in RMAN:
>
> RMAN-00571:
> ===========================================================
> RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS
> ===============
> RMAN-00571:
> ===========================================================
> RMAN-00554: initialization of internal recovery manager package failed
> RMAN-04005: error from target database:
> ORA-09925: Unable to create audit trail file
> Linux-x86_64 Error: 2: No such file or directory
>
> However, it looks like auditing is turned off:
>
> SQL> show parameter audit
>
> NAME                                 TYPE        VALUE
> ------------------------------------ -----------
> ------------------------------
> audit_file_dest                      string      /opt/oracle/product/
> ora10/rdbms/audit
> audit_sys_operations                 boolean     FALSE
> audit_syslog_level                   string
> audit_trail                          string      NONE
>
> Any thoughts?  I'm looking through the Oracle docs buy cannot find
> anything on this being that it shows auditing is turned off.  Because
> there were so many files being created we removed the directory.  But
> we want to stop the auditing altogether.
>
> Thanks

Hi,
Connections to the database as SYSDBA are always audited regardless if auditing is enabled or not. You can either recreate the original auditing directory or change the audit destination parameter to another directory.

Regards
Sandy Received on Thu May 13 2010 - 22:43:56 CDT