ORA-09925: Unable to create audit trail file
I was received this error message when I was started my database.
[oracle@sonu ~]$ sqlplus / as sysdba
SQL*Plus: Release 12.1.0.2.0 Production on Thu Aug 31 09:22:44 2017
Copyright (c) 1982, 2014, Oracle. All rights reserved.
ERROR:
ORA-09925: Unable to create audit trail file
Linux-x86_64 Error: 30: Read-only file system
Additional information: 9925
ORA-09925: Unable to create audit trail file
Linux-x86_64 Error: 30: Read-only file system
Additional information: 9925
CAUSE
The filesystem inodes are exhausted.
Solution:-
I rebooted my machine and got following messages which pointed to some
errors encountered during filesystem check and instructed to run fsck manually.
[root@sonu ~]# init 6
Checking filesystems
/: UNEXPECTED INCONSISTENCY; RUN fsck MANUALLY.
(i.e., without -a or -p options)
*** An error occurred during the filesystem check.
*** Dropping you to a shell; the system will reboot
*** when you leave the shell.
Give root password for maintenance (or type Control-D to continue):
– I entered password for root to initiate filesystem check.
As a result I was prompted multiple no. of times to allow fixing of various filesystem errors.
(Repair filesystem) 1 # fsck
Fix(y)?
- After all the errors had been fixed, filesystem check was restarted
Restarting e2fsck from the beginning...
/: ***** FILE SYSTEM WAS MODIFIED *****
/: ***** REBOOT LINUX *****
- After filesystem had been finally checked to be correct, I exited for reboot to continue.
(Repair filesystem) 2 # exit
– After the reboot, I could successfully connect to my database as sysdba .
[oracle@sonu ~]$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.1.0 Production on Sat Jul 12 09:21:52 2014
Copyright (c) 1982, 2009, Oracle. All rights reserved.
Connected to an idle instance.
[oracle@sonu ~]$ sqlplus / as sysdba
SQL*Plus: Release 12.1.0.2.0 Production on Thu Aug 31 10:24:43 2017
Copyright (c) 1982, 2014, Oracle. All rights reserved.
Connected to an idle instance.
SQL> startup
ORACLE instance started.
Total System Global Area 1073741824 bytes
Fixed Size 2932632 bytes
Variable Size 549453928 bytes
Database Buffers 515899392 bytes
Redo Buffers 5455872 bytes
Database mounted.
Database opened.
SQL> select name from v$database;
NAME
---------
sujeet
Issue resolved.
No comments:
Post a Comment