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
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