Home » RDBMS Server » Server Administration » connect / as sysdba fails with ORA-09925 error (10g Linux Redhat.)
connect / as sysdba fails with ORA-09925 error [message #287293] Tue, 11 December 2007 20:22 Go to next message
geeklol
Messages: 59
Registered: March 2005
Member
I just installed a cluster database on 10g RAC, filesystem (NO ASM). One of the databases starts up correctly but the other gives me the following error while trying to connect / as sysdba.

SQL> connect / as sysdba
ERROR:
ORA-09925: Unable to create audit trail file
Linux-x86_64 Error: 2: No such file or directory
Additional information: 9925
ORA-01075: you are currently logged on

my audit_file_dest is set to the correct path and adump directory where the audit_file_dest is pointing has write permissions to the oracle user.

Any idea?

Thank you.
Re: connect / as sysdba fails with ORA-09925 error [message #287295 is a reply to message #287293] Tue, 11 December 2007 20:28 Go to previous messageGo to next message
BlackSwan
Messages: 25036
Registered: January 2009
Location: SoCal
Senior Member
>my audit_file_dest is set to the correct path and adump directory where the audit_file_dest is pointing has write permissions to the oracle user.
When a user disputes the validity of any Oracle/system error message, my only response is "Prove it!".

As Oracle user "touch" a file in the adump folder.
Re: connect / as sysdba fails with ORA-09925 error [message #287298 is a reply to message #287293] Tue, 11 December 2007 21:36 Go to previous message
monto
Messages: 60
Registered: November 2007
Location: DALLAS
Member
can you see that directory from this node?seems like the filesystem its on is not shared i,e other node is not able to see it.
Previous Topic: Issues after Upgrading to 10g
Next Topic: how we can track daily inserted record in tables
Goto Forum:
  


Current Time: Sun Dec 04 02:31:43 CST 2016

Total time taken to generate the page: 0.05924 seconds