Link to home
Start Free TrialLog in
Avatar of chalie001
chalie001

asked on

ORA-00205: error in identifying control file, check alert log for more info

hi am in database 12c am having this error when connecting to my database in solaris

Enter user-name: /as sysdba
ERROR:
ORA-09925: Unable to create audit trail file
Solaris-AMD64 Error: 2: No such file or directory
Additional information: 9925
ORA-09925: Unable to create audit trail file
Solaris-AMD64 Error: 2: No such file or directory
Additional information: 9925
ASKER CERTIFIED SOLUTION
Avatar of schwertner
schwertner
Flag of Antarctica image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
The next possible reason is that the logical device to which this directory belongs is out of space due big amount of .aud files. If it is so drop the files and ask for instructions how to reconfigure the Oracle instance to clean periodically the directory.
It is also not easy to clean the directory if there are many files.

use this statement many times:

find . -maxdepth 1 -type f -name "*.aud" -mtime +20 -exec rm -f {} \;

If there is error instead +20 type +200 and decrease this value in every next run until deleting all the .aud files