Error Caused by ORA-09925: Unable to create audit trail file
When I practiced manual Oracle database creation today, I set the path in the parameter file audit_file_dest incorrectly and reported an error during startupnomount,
After modification, sqlplus cannot log on again.
ERROR:
ORA-09925: Unable to create audit trail file
Linux Error: 2: No such file or directory
Additional information: 9925
ORA-01075: you are currently logged on
I couldn't find the reason, and then I found a post on the Internet to explain this situation. I tried it and it worked.
[Oracle @ Allen adump] $ ps-ef | grep smon
Oracle 2479 1 0? 00:00:00 ora_smon_allen
Oracle 27854 1 0? 00:00:00 ora_smon_prod
Oracle 27946 27885 0 00:00:00 pts/6 grep smon
[Oracle @ Allen adump] $ kill-9 27854
Use sqlplus to log on.
Installing Oracle 12C in Linux-6-64
Install Oracle 11gR2 (x64) in CentOS 6.4)
Steps for installing Oracle 11gR2 in vmwarevm
Install Oracle 11g XE R2 In Debian