Got an infamous "ORA-09925: Unable to create audit trail file" error while trying to log in to sqlplus as sysdba via command line:
sqlplus / as sysdba
I did some research and 90% of cases where this error came up while creating a database via command line, while the user tried to log in to sqlplus in order to startup the database from pfile, the problem was permissions issue - not sufficient permissions to write to the adump directory. It happened to be something different in my case.
Cause: An instance for that ORACLE_SID was alredy started. I ran ps -ef | grep pmon
and saw that the instance was already running and therefore I was getting the error
Solution: Run ps -ef | grep pmon, copy the process id and kill the process using kill processid command.
sqlplus / as sysdba
I did some research and 90% of cases where this error came up while creating a database via command line, while the user tried to log in to sqlplus in order to startup the database from pfile, the problem was permissions issue - not sufficient permissions to write to the adump directory. It happened to be something different in my case.
Cause: An instance for that ORACLE_SID was alredy started. I ran ps -ef | grep pmon
and saw that the instance was already running and therefore I was getting the error
Solution: Run ps -ef | grep pmon, copy the process id and kill the process using kill processid command.
No comments:
Post a Comment