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

Article:TECH72297  |  Created: 2009-01-04  |  Updated: 2012-03-22  |  Article URL http://www.symantec.com/docs/TECH72297
Article Type
Technical Solution


Environment

Issue



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



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.

Supplemental Materials

ValueV-79-57344-832
Description

The Database script returned an error. Refer to the Database script output section in job logs for more details.


Value0xe0000340
Description

The Database script returned an error. Refer to the Database script output section in job logs for more details.



Legacy ID



327709


Article URL http://www.symantec.com/docs/TECH72297


Terms of use for this information are found in Legal Notices