Home » RDBMS Server » Server Administration » help please!
help please! [message #63484] Fri, 08 October 2004 14:20 Go to next message
bforacular
Messages: 1
Registered: October 2004
Junior Member
I just finished installing oracle 9.2 on my linux box and tried sqlplus for the first time but I get the following error message. How can I resolve it?

Thanks in advance!

sqlplus> connect / as sysdba

ORA-09925: Unable to create audit trail file
Linux Error: 2: No such file or directory
Additional information: 9925
ORA-09925: Unable to create audit trail file
Linux Error: 2: No such file or directory
Additional information: 9925
Re: help please! [message #63526 is a reply to message #63484] Wed, 13 October 2004 04:36 Go to previous message
Mark
Messages: 284
Registered: July 1998
Senior Member
It seems your init.ora parameter audit_trail is set to use the operating system's audit log and not Oracle's internal aud$ table. Either resolve the problem or deactivate the audit_trail parameter.

If you can't login to issue commands, then crash Oracle at the operating system level and then you can "connect / as sysdba" and then you can "startup nomount" and then you can change your spfile's audit_trail value, and then open the database.

-Mark
9i OCP
Previous Topic: No. DBWr Processes
Next Topic: Where to get 7.3.4 for HPUX 11i
Goto Forum:
  


Current Time: Thu Jan 09 22:45:47 CST 2025