环境:用虚拟机搭建的两台服务器组成的ORALCE RAC环境,都报同样的系统错误:
[oracle@jljcdb1 ~]$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.4.0 Production on 星期一 7月 27 14:01:53 2015
Copyright (c) 1982, 2013, 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
请输入用户名:
ERROR:
ORA-01017: 用户名/口令无效; 登录被拒绝
请输入用户名:
ERROR:
ORA-01017: 用户名/口令无效; 登录被拒绝
SP2-0157: 在 3 次尝试之后无法连接到 ORACLE, 退出 SQL*Plus
[oracle@jljcdb1 ~]$
ORACLE相关的文件都存放在/u01目录下面的:
[root@jljcdb1 /]# df -h
文件系统 容量 已用 可用 已用% 挂载点
/dev/mapper/VolGroup00-LogVol00
64Z 64Z 266G 100% /
/dev/mapper/VolGroup00-LogVol02
38G 432M 36G 2% /var
/dev/mapper/VolGroup00-LogVol03
49G 23G 24G 50% /u01
/dev/sda1 198M 13M 175M 7% /boot
tmpfs 16G 0 16G 0% /dev/shm
[root@jljcdb1 /]#
于是尝试在/U01目录下面建立个文件试试,也得到同样的错误:
[root@jljcdb1 /]# mkdir /u01/a
mkdir: 无法创建目录 “/u01/a”: 只读文件系统
[root@jljcdb1 /]#
用MOUNT命令查看:
[root@jljcdb1 ~]# mount
/dev/mapper/VolGroup00-LogVol00 on / type ext3 (rw)
proc on /proc type proc (rw)
sysfs on /sys type sysfs (rw)
devpts on /dev/pts type devpts (rw,gid=5,mode=620)
/dev/mapper/VolGroup00-LogVol02 on /var type ext3 (rw)
/dev/mapper/VolGroup00-LogVol03 on /u01 type ext3 (ro)
/dev/sda1 on /boot type ext3 (rw)
tmpfs on /dev/shm type tmpfs (rw)
none on /proc/sys/fs/binfmt_misc type binfmt_misc (rw)
mount: warning /etc/mtab is not writable (e.g. read-only filesystem).
It's possible that information reported by mount( is not
up to date. For actual information about system mount points
check the /proc/mounts file.
[root@jljcdb1 ~]#
查看/proc/mount文件:
[root@jljcdb1 ~]# cat /proc/mounts
rootfs / rootfs rw 0 0
/dev/root / ext3 ro,data=http://bbs.chinaunix.net/ordered 0 0
/dev /dev tmpfs rw 0 0
/proc /proc proc rw 0 0
/sys /sys sysfs rw 0 0
/proc/bus/usb /proc/bus/usb usbfs rw 0 0
devpts /dev/pts devpts rw 0 0
/dev/VolGroup00/LogVol02 /var ext3 rw,data=http://bbs.chinaunix.net/ordered 0 0
/dev/VolGroup00/LogVol03 /u01 ext3 ro ,data=http://bbs.chinaunix.net/ordered 0 0
/dev/sda1 /boot ext3 rw,data=http://bbs.chinaunix.net/ordered 0 0
tmpfs /dev/shm tmpfs rw 0 0
none /proc/sys/fs/binfmt_misc binfmt_misc rw 0 0
[root@jljcdb1 ~]#
上面的文件用ROOT用户去修改但报没有权限,不能修改。
接着利用其他网上的说法去尝试,发现仍然不行:
[root@jljcdb1 /]# mount -o remount ,rw -t ext3 /u01
mount: block device ,rw is write-protected, mounting read-only
[root@jljcdb1 /]#
[oracle@jljcdb1 ~]$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.4.0 Production on 星期一 7月 27 14:01:53 2015
Copyright (c) 1982, 2013, 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
请输入用户名:
ERROR:
ORA-01017: 用户名/口令无效; 登录被拒绝
请输入用户名:
ERROR:
ORA-01017: 用户名/口令无效; 登录被拒绝
SP2-0157: 在 3 次尝试之后无法连接到 ORACLE, 退出 SQL*Plus
[oracle@jljcdb1 ~]$
ORACLE相关的文件都存放在/u01目录下面的:
[root@jljcdb1 /]# df -h
文件系统 容量 已用 可用 已用% 挂载点
/dev/mapper/VolGroup00-LogVol00
64Z 64Z 266G 100% /
/dev/mapper/VolGroup00-LogVol02
38G 432M 36G 2% /var
/dev/mapper/VolGroup00-LogVol03
49G 23G 24G 50% /u01
/dev/sda1 198M 13M 175M 7% /boot
tmpfs 16G 0 16G 0% /dev/shm
[root@jljcdb1 /]#
于是尝试在/U01目录下面建立个文件试试,也得到同样的错误:
[root@jljcdb1 /]# mkdir /u01/a
mkdir: 无法创建目录 “/u01/a”: 只读文件系统
[root@jljcdb1 /]#
用MOUNT命令查看:
[root@jljcdb1 ~]# mount
/dev/mapper/VolGroup00-LogVol00 on / type ext3 (rw)
proc on /proc type proc (rw)
sysfs on /sys type sysfs (rw)
devpts on /dev/pts type devpts (rw,gid=5,mode=620)
/dev/mapper/VolGroup00-LogVol02 on /var type ext3 (rw)
/dev/mapper/VolGroup00-LogVol03 on /u01 type ext3 (ro)
/dev/sda1 on /boot type ext3 (rw)
tmpfs on /dev/shm type tmpfs (rw)
none on /proc/sys/fs/binfmt_misc type binfmt_misc (rw)
mount: warning /etc/mtab is not writable (e.g. read-only filesystem).
It's possible that information reported by mount( is not
up to date. For actual information about system mount points
check the /proc/mounts file.
[root@jljcdb1 ~]#
查看/proc/mount文件:
[root@jljcdb1 ~]# cat /proc/mounts
rootfs / rootfs rw 0 0
/dev/root / ext3 ro,data=http://bbs.chinaunix.net/ordered 0 0
/dev /dev tmpfs rw 0 0
/proc /proc proc rw 0 0
/sys /sys sysfs rw 0 0
/proc/bus/usb /proc/bus/usb usbfs rw 0 0
devpts /dev/pts devpts rw 0 0
/dev/VolGroup00/LogVol02 /var ext3 rw,data=http://bbs.chinaunix.net/ordered 0 0
/dev/VolGroup00/LogVol03 /u01 ext3 ro ,data=http://bbs.chinaunix.net/ordered 0 0
/dev/sda1 /boot ext3 rw,data=http://bbs.chinaunix.net/ordered 0 0
tmpfs /dev/shm tmpfs rw 0 0
none /proc/sys/fs/binfmt_misc binfmt_misc rw 0 0
[root@jljcdb1 ~]#
上面的文件用ROOT用户去修改但报没有权限,不能修改。
接着利用其他网上的说法去尝试,发现仍然不行:
[root@jljcdb1 /]# mount -o remount ,rw -t ext3 /u01
mount: block device ,rw is write-protected, mounting read-only
[root@jljcdb1 /]#
在网上找了一些文章,有的说是文件系统损坏,有的说的磁盘损坏,哪位仁兄遇到过给个解决方法啊!!
--本篇文章转自:统遭遇Read-only file system错误