发现磁盘变为只读模式，sqlplus登陆报错，怀疑为LINUX服务器长时间没有重启，文件节点过高的原因，使用fsck检查后，服务器恢复到可读写模式，注意做fsck前需要做好备份，fsck可能会导致数据块损坏，最好是不做fsck重启一下服务器,注意重启服务器过程可能会比较慢，数据量大的情况下可能半小时都起不来，要有心理准备
oracle2@SH01020189 dbs]$ sqlplus "/as sysdba"
SQL*Plus: Release
10.2.0.4.0 - Production on Mon Mar 26 09:25:45 2012
Copyright (c) 1982,
2007, 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-01075: you are
currently logged on
Enter user-name:
df
[oracle2@SH01020189
oracle2]$ touch test
touch:
cannot touch `test': Read-only file system
[
[root@uat
/]# fsck /dev/VolGroup00/LogVol03
fsck
1.39 (29-May-2006)
e2fsck
1.39 (29-May-2006)
/dev/VolGroup00/LogVol03:
recovering journal
/dev/VolGroup00/LogVol03
contains a file system with errors, check forced.
Pass
1: Checking inodes, blocks, and sizes
Deleted
inode 1127863 has zero dtime. Fix? yes
Inode
1509788, i_size is 144367682, should be 147365888. Fix? yes
Inode
1509788, i_blocks is 282264, should be 288120. Fix? yes
Inode
3868959, i_size is 21838773, should be 21843968. Fix? yes
Inode
3868959, i_blocks is 42712, should be 42720. Fix? yes
Running
additional passes to resolve blocks claimed by more than one inode...
Pass
1B: Rescanning for multiply-claimed blocks
Multiply-claimed
block(s) in inode 1509318: 5184641 5184642 5184643 5184644 5184645
Multiply-claimed
block(s) in inode 1509521: 5184640
Multiply-claimed
block(s) in inode 3872162: 5184640 5184641 5184642 5184643 5184644 5184645
Pass
1C: Scanning directories for inodes with multiply-claimed blocks
Pass
1D: Reconciling multiply-claimed blocks
(There
are 3 inodes containing multiply-claimed blocks.)
File
/oracle/oradata/uatdb/control01.ctl (inode #1509318, mod time Wed Sep 28
15:31:22 2011)
has 5 multiply-claimed block(s), shared with 1 file(s):
/weblogic/user_projects/domains/base_domain/logs/weblogic_2011-09-25_00-00-01
(inode #3872162, mod time Sun Sep 25 23:59:54 2011)
Clone
multiply-claimed blocks? yes
File
/oracle/admin/uatdb/udump/uatdb_ora_4893.trc (inode #1509521, mod time Fri Sep
16 17:07:59 2011)
has 1 multiply-claimed block(s), shared with 1 file(s):
/weblogic/user_projects/domains/base_domain/logs/weblogic_2011-09-25_00-00-01
(inode #3872162, mod time Sun Sep 25 23:59:54 2011)
Clone
multiply-claimed blocks? yes
File
/weblogic/user_projects/domains/base_domain/logs/weblogic_2011-09-25_00-00-01
(inode #3872162, mod time Sun Sep 25 23:59:54 2011)
has 6 multiply-claimed block(s), shared with 2 file(s):
/oracle/oradata/uatdb/control01.ctl (inode #1509318, mod time Wed Sep 28
15:31:22 2011)
/oracle/admin/uatdb/udump/uatdb_ora_4893.trc (inode #1509521, mod time Fri Sep
16 17:07:59 2011)
Multiply-claimed
blocks already reassigned or cloned.
Pass
2: Checking directory structure
Pass
3: Checking directory connectivity
Pass
4: Checking reference counts
Pass
5: Checking group summary information
Block
bitmap differences: -1128179 +1171287 +(14323770--14323771)
+(14324232--14324259)
Fix?
yes
Free
blocks count wrong for group #1 (6, counted=0).
Fix?
yes
Free
blocks count wrong for group #34 (606, counted=607).
Fix?
yes
Free
blocks count wrong for group #35 (42, counted=41).
Fix?
yes
Free
blocks count wrong for group #369 (9, counted=4).
Fix?
yes
Free
blocks count wrong for group #370 (41, counted=24).
Fix?
yes
Free
blocks count wrong for group #434 (4394, counted=4393).
Fix?
yes
Free
blocks count wrong for group #435 (310, counted=325).
Fix?
yes
Free
blocks count wrong for group #436 (2222, counted=2207).
Fix?
yes
Free
blocks count wrong for group #437 (459, counted=429).
Fix?
yes
Free
blocks count wrong (37382787, counted=37382728).
Fix?
yes
Inode
bitmap differences: -1127863 -1127882 +1127886
Fix?
yes
Free
inodes count wrong for group #34 (18995, counted=18996).
Fix?
yes
Free
inodes count wrong (78583054, counted=78583055).
Fix?
yes
/dev/VolGroup00/LogVol03:
***** FILE SYSTEM WAS MODIFIED *****
/dev/VolGroup00/LogVol03:
60145/78643200 files (2.0% non-contiguous), 41260472/78643200 blocks