启动一个数据库时,碰到这个错误:
[oracle]$ sqlplus "/ as sysdba" SQL*Plus: Release 10.2.0.4.0 - Production on Mon Jan 4 10:40:36 2010 Copyright (c) 1982, 2007, Oracle. All Rights Reserved. ERROR: ORA-09925: Unable to create audit trail file Linux Error: 30: Read-only file system Additional information: 9925 ORA-09925: Unable to create audit trail file Linux Error: 30: Read-only file system Additional information: 9925
[@more@]从上面输出的错误来看,第一个判断是不能创建审计跟踪文件,可能是audit_file_dest所指的目录没有相应的权限,但查看一下pfile/spfile都没有audit相关的参数配置。这里有点奇怪的是,数据库根本就没有开, nomount状态都没有,只是各简单地登录SQLPLUS,停顿了一会,就报上面的错误。这根本就没有机会去读pfile/spfile。上 面错误的最后两行错误,还是提到了操作系统上的问题:只读文件系统。确认一下错误:
[oracle]$ touch aa.txt
touch: cannot touch `aa.txt': Read-only file system
问题基本确定了。把整个文件系统重新加载成可以读写的,数据库就可以正常启动了。 Oracle给的错误提示还是有点意思,怎么会报不能创建跟踪文件,这个时候根本就没有初始化数据库。 用strace跟踪SQLPLUS,没有看懂,贴上错误前后的信息:
gettimeofday({1262574606, 467237}, NULL) = 0 open("/etc/hostid", O_RDONLY|O_LARGEFILE) = -1 ENOENT (No such file or directory) open("/etc/hostid", O_RDONLY|O_LARGEFILE) = -1 ENOENT (No such file or directory) uname({sys="Linux", node="linuxhost.company.com", ...}) = 0 write(9, "126663s3!(346377277t"..., 438) = 438 read(10, "vf11", 2064) = 11 write(9, "vf12", 11) = 11 read(10, "vf12", 2064) = 11 read(10, "3436411n4"..., 2064) = 227 getcwd("/opt/product/oracle/10.2/db/dbs", 256) = 32 rt_sigaction(SIGTSTP, {SIG_IGN}, {SIG_IGN}, 8) = 0 ioctl(0, SNDCTL_TMR_TIMEBASE or TCGETS, {B38400 opost isig icanon echo ...}) = 0 readlink("/proc/self/fd/0", "/dev/pts/6", 4095) = 10 getuid32() = 503 gettimeofday({1262574606, 472711}, NULL) = 0 write(9, "126663s4241234346377277t"..., 438) = 438 read(10, "vf11vf12", 2064) = 22 write(9, "vf12", 11) = 11 read(10, "1M6411305&"..., 2064) = 333 lseek(4, 512, SEEK_SET) = 512 read(4, "24527"..., 512) = 512 lseek(4, 1024, SEEK_SET) = 1024 read(4, "26*Rh201236350374n1#1?1M125113071346132"..., 512) = 512 lseek(4, 5120, SEEK_SET) = 5120 read(4, "r351V352220353240356320357344"..., 512) = 512 write(1, "ERROR:n", 7ERROR: ) = 7 write(1, "ORA-09925: Unable to create audi"..., 45ORA-09925: Unable to create audit trail file ) = 45 write(1, "Linux Error: 30: Read-only file "..., 39Linux Error: 30: Read-only file system ) = 39 write(1, "Additional information: 9925n", 29Additional information: 9925 ) = 29 write(1, "ORA-09925: Unable to create audi"..., 45ORA-09925: Unable to create audit trail file ) = 45 write(1, "Linux Error: 30: Read-only file "..., 39Linux Error: 30: Read-only file system ) = 39 write(1, "Additional information: 9925n", 29Additional information: 9925 ) = 29 write(1, "n", 1 ) = 1 write(1, "n", 1 ) = 1 lseek(4, 512, SEEK_SET) = 512 read(4, "24527"..., 512) = 512 lseek(4, 1024, SEEK_SET) = 1024 read(4, "26*Rh201236350374n1#1?1M125113071346132"..., 512) = 512 lseek(4, 4608, SEEK_SET) = 4608 read(4, "17240b241v242211253236254271"..., 512) = 512 write(1, "Enter user-name: ", 17Enter user-name: ) = 17 fstat64(0, {st_mode=S_IFCHR|0620, st_rdev=makedev(136, 6), ...}) = 0 mmap2(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1,
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/45188/viewspace-1030383/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/45188/viewspace-1030383/