Home » RDBMS Server » Server Administration » ORA-09925: Unable to create audit trail file (Suse 9 oracle 10g)
ORA-09925: Unable to create audit trail file [message #385361] Mon, 09 February 2009 04:52 Go to next message
ora_2007
Messages: 430
Registered: July 2007
Location: Mumbai
Senior Member
I am process of migration of database from one server to other.

I have same OS Suse 9 unix same oracle version oracle 10.2.0.1

1. Now i have copied All databfiles from 1 server to other.
2. copied control files redo log files
3. Copied spfile
4. all dump files

Now where i want to start the database it gives me an error.
How can i resolve it?

SQL> startup
ORA-09925: Unable to create audit trail file
Linux Error: 2: No such file or directory
Additional information: 9925
SQL> startup

drwxrwxrwx 2 oracle oinstall 1360 2009-02-09 16:17 adump

I checked the permisssions but it have all permissins

Please help
Re: ORA-09925: Unable to create audit trail file [message #385371 is a reply to message #385361] Mon, 09 February 2009 05:35 Go to previous messageGo to next message
Michel Cadot
Messages: 64111
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
What did you check?
Post it as you did it.
And post it FORMATTED.

Regards
Michel
Re: ORA-09925: Unable to create audit trail file [message #385375 is a reply to message #385361] Mon, 09 February 2009 05:52 Go to previous message
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
I would guess that you've got the AUDIT_TRAIL parameter set to OS, and the AUDIT_FILE_DEST parameter set to a diretory that doesn't exist on your new server.
Previous Topic: LWGR - when will trigger DBWR ?
Next Topic: 10gR1 to 10gR2 (merged)
Goto Forum:
  


Current Time: Mon Dec 05 15:07:50 CST 2016

Total time taken to generate the page: 0.15677 seconds