OraFAQ Forum: Unix » ColdBackUp

Home » Infrastructure » Unix » ColdBackUp (11G)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

ColdBackUp [message #609199]

Mon, 03 March 2014 21:31

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:

Report message to a moderator

Re: ColdBackUp [message #609201 is a reply to message #609199]

Mon, 03 March 2014 21:42

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

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/

Report message to a moderator

Re: ColdBackUp [message #609204 is a reply to message #609201]

Mon, 03 March 2014 22:13

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

Report message to a moderator

Re: ColdBackUp [message #609205 is a reply to message #609204]

Mon, 03 March 2014 22:24

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Nov 22 16:28:01 CST 2024