Oracle backups fail with error 0xe0000340 - The Database script returned an error. Refer to the Database script output section in job logs for more details. ORA-09925: Unable to create audit trail file

  • Modified Date:
  • Article ID:000039253

Problem

Oracle backups fail with error 0xe0000340 - The Database script returned an error. Refer to the Database script output section in job logs for more details. ORA-09925: Unable to create audit trail file

Error Message

When backing up an Oracle instance, the backup job fails almost immediately with the following information showing in the RMAN section of the job log:
 
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of startup command at 07/10/2009 12:22:15
RMAN-04014: startup failed: ORA-09925: Unable to create audit trail file
 

Cause

This problem usually appears when the credentials used to access the Linux hosts is other than "oracle".

Solution

Verify the current configuration of the Oracle auditing by entering to SQL*Plus:

SQL> show parameter audit;

Auditing is disabled by default, but can be enabled by setting the AUDIT_TRAIL variable
Accepted values: { none | os | db | db,extended | xml | xml,extended }

When OS or XML extended option is used the AUDIT_FILE_DEST variable specifies the OS directory used for the audit trail file.

1) Set AUDIT_TRAIL = OS, so all the audit records are written to the OS audit trail.
2) Set AUDIT_FILE_DEST pointing to a existing folder in the Linux host.

To set AUDIT_TRAIL and AUDIT_FILE_DEST edit the initSID.ora file (where SID is the database name in the $ORACLE_HOME/dbs directory) and add the following lines:

audit_trail OS
audit_file_dest /u01/app/oracle/admin/orcl/adu

Also it can be done dynamically using SQL*Plus commands. Contact your Oracle DBA for further information.

3) Verify that the account used to access to the Linux host has these two variables in his environment.
4) Verify that the account used to access to the Linux host has enough permissions to write to the specified folder.

Note:
Windows Servers does not use the AUDIT_FILE_DEST parameter. Operating System auditing changes are recorded in the Event Viewer.
 

 

Terms of use for this information are found in Legal Notices.

Search

Survey

Did this article answer your question or resolve your issue?

No
Yes

Did this article save you the trouble of contacting technical support?

No
Yes

How can we make this article more helpful?

Email Address (Optional)