Home » Infrastructure » Unix » ColdBackUp (11G)
ColdBackUp [message #609199] Mon, 03 March 2014 21:31 Go to next message
ujjal_roy
Messages: 3
Registered: March 2014
Location: Karnataka
Junior Member

I am getting this error while restoring the DB.

sqlplus sys/sys as sysdba


ERROR:
ORA-09925: Unable to create audit trail file


Enter user-name:
Re: ColdBackUp [message #609201 is a reply to message #609199] Mon, 03 March 2014 21:42 Go to previous messageGo to next message
BlackSwan
Messages: 23158
Registered: January 2009
Senior Member
Welcome to this forum.

09925, 00000,  "Unable to create audit trail file"
// *Cause:  ORACLE was not able to create the file being used to hold
//          audit trail records.
// *Action: Check the UNIX error number for a possible operating system error.
//          If there is no error, contact ORACLE customer support.



Please read and follow the forum guidelines, to enable us to help you:

http://www.orafaq.com/forum/t/88153/0/

Re: ColdBackUp [message #609204 is a reply to message #609201] Mon, 03 March 2014 22:13 Go to previous messageGo to next message
ujjal_roy
Messages: 3
Registered: March 2014
Location: Karnataka
Junior Member
Thanks BlackSwan for the reply.

Yes there is no UNIX error.
I have mentioned the location audit dest in pfile like .audit_file_dest='/home/oratest1/UBR_NEWDB/admin/newdbu/adump'.

How shall I check if ORACLE_HOME is 100% ?
How shall I check the audit directory if it is writable or not.?

Please help me to resolve this error ERROR:
ORA-09925: Unable to create audit trail file
Re: ColdBackUp [message #609205 is a reply to message #609204] Mon, 03 March 2014 22:24 Go to previous message
BlackSwan
Messages: 23158
Registered: January 2009
Senior Member
>How shall I check if ORACLE_HOME is 100% ?

post results from OS command below

df -k

>How shall I check the audit directory if it is writable or not.?

post results from OS commands below

id
ls -ltr /home/oratest1/UBR_NEWDB/admin/newdbu/adump/
ls -ld /home/oratest1/UBR_NEWDB/admin/newdbu/adump/
ls -ld /home/oratest1/UBR_NEWDB/admin/newdbu/
ls -ld /home/oratest1/UBR_NEWDB/admin/
ls -ld /home/oratest1/UBR_NEWDB/
ls -ld /home/oratest1/
ls -ld /home/

[Updated on: Mon, 03 March 2014 22:24]

Report message to a moderator

Previous Topic: AIX Scripts with SQLPLUS Commands
Next Topic: Add User in Linux
Goto Forum:
  


Current Time: Sun Dec 21 16:39:31 CST 2014

Total time taken to generate the page: 0.06576 seconds