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.

Report message to a moderator

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: 26766
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.

Report message to a moderator

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.

Report message to a moderator

Previous Topic: Issues after Upgrading to 10g
Next Topic: how we can track daily inserted record in tables
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Mon Dec 02 05:56:06 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.