数据库无法打开ORA-09967: unable to create or open lock file

最新推荐文章于 2024-07-23 08:45:00 发布

转载最新推荐文章于 2024-07-23 08:45:00 发布 · 1.2k 阅读

文章标签：

本文记录了一次Oracle数据库启动失败的问题排查过程。由于文件权限错误导致数据库无法正常启动，通过更改文件所有者为正确的oracle用户解决了该问题。此外，还展示了如何检查内存使用情况和信号量等关键步骤。

***************
问题描述：
***************
数据库无法打开
SQL> desc v$datafile;
ERROR:
ORA-00604: error occurred at recursive SQL level 1
ORA-01116: error in opening database file 1
ORA-01110: data file 1: '/u01/oradata/memcache/system01.dbf'
ORA-27041: unable to open file
Linux Error: 13: Permission denied
Additional information: 3

SQL> select name, open_mode from v$database;
select name, open_mode from v$database
*
ERROR at line 1:
ORA-00210: cannot open the specified control file
ORA-00202: control file: '/u01/oradata/memcache/control01.ctl'
ORA-27041: unable to open file
Linux Error: 13: Permission denied
Additional information: 3

[root@C113247 ~]# cd /u01/oradata/memcache
[root@C113247 memcache]# ls -alt
total 33285348
-rw-r----- 1 root   root       12206080 Jul 23 17:30 control01.ctl
-rw-r----- 1 root   root       12206080 Jul 23 17:30 control02.ctl
-rw-r----- 1 root   root      209715712 Jul 23 17:30 redo03a.log
-rw-r----- 1 root   root     4294975488 Jul 23 17:30 undotbs101.dbf
-rw-r----- 1 root   root      524296192 Jul 23 17:29 sysaux01.dbf
-rw-r----- 1 root   root     8589942784 Jul 23 17:29 users02.dbf
-rw-r----- 1 root   root     5368717312 Jul 23 17:29 indx01.dbf
-rw-r----- 1 root   root      524296192 Jul 23 17:24 system01.dbf
-rw-r----- 1 root   root     8589942784 Jul 23 16:39 indx02.dbf
-rw-r----- 1 root   root     5368717312 Jul 1 08:08 users01.dbf
-rw-r----- 1 root   root      209715712 Jul 1 08:03 redo02a.log
-rw-r----- 1 root   root      209715712 Jun 21 01:15 redo01a.log
-rw-r----- 1 root   root      524296192 Apr 19 22:00 temp01.dbf
drwxr-xr-x 2 oracle oinstall       4096 Feb 5 15:33 .
drwxr-xr-x 4 oracle oinstall       4096 Jan 4 2010 ..
[root@C113247 memcache]# cd ..
[root@C113247 oradata]# ls -alt
total 16
drwxr-xr-x 2 oracle oinstall 4096 Feb 5 15:33 memcache
drwxr-xr-x 4 oracle oinstall 4096 Jan 4 2010 .
drwxr-xr-x 2 oracle oinstall 4096 Jan 4 2010 archive
drwxr-xr-x 4 oracle oinstall 4096 Jan 4 2010 ..
[root@C113247 oradata]# pwd
/u01/oradata
[root@C113247 oradata]# chown -R oracle:oinstall /u01/oradata/memcache/
[root@C113247 oradata]# ls -alt
total 16
drwxr-xr-x 2 oracle oinstall 4096 Feb 5 15:33 memcache
drwxr-xr-x 4 oracle oinstall 4096 Jan 4 2010 .
drwxr-xr-x 2 oracle oinstall 4096 Jan 4 2010 archive
drwxr-xr-x 4 oracle oinstall 4096 Jan 4 2010 ..
[root@C113247 oradata]# cd memcache
[root@C113247 memcache]# ls -alt
total 33285348
-rw-r----- 1 oracle oinstall   12206080 Jul 23 17:30 control01.ctl
-rw-r----- 1 oracle oinstall   12206080 Jul 23 17:30 control02.ctl
-rw-r----- 1 oracle oinstall 209715712 Jul 23 17:30 redo03a.log
-rw-r----- 1 oracle oinstall 4294975488 Jul 23 17:30 undotbs101.dbf
-rw-r----- 1 oracle oinstall 524296192 Jul 23 17:29 sysaux01.dbf
-rw-r----- 1 oracle oinstall 8589942784 Jul 23 17:29 users02.dbf
-rw-r----- 1 oracle oinstall 5368717312 Jul 23 17:29 indx01.dbf
-rw-r----- 1 oracle oinstall 524296192 Jul 23 17:24 system01.dbf
-rw-r----- 1 oracle oinstall 8589942784 Jul 23 16:39 indx02.dbf
-rw-r----- 1 oracle oinstall 5368717312 Jul 1 08:08 users01.dbf
-rw-r----- 1 oracle oinstall 209715712 Jul 1 08:03 redo02a.log
-rw-r----- 1 oracle oinstall 209715712 Jun 21 01:15 redo01a.log
-rw-r----- 1 oracle oinstall 524296192 Apr 19 22:00 temp01.dbf
drwxr-xr-x 2 oracle oinstall       4096 Feb 5 15:33 .
drwxr-xr-x 4 oracle oinstall       4096 Jan 4 2010 ..

因为整个oracle相关的目录所有者都被改为了root，我没有把所有的改回来。
故还是起不来

SQL> startup mount;
ORA-10997: another startup/shutdown operation of this instance inprogress
ORA-09967: unable to create or open lock file
Linux Error: 13: Permission denied

把oracle相关的目录所有者都改为oracle就可以了

分析中：
查看内存和信号量
[oracle@C113247 bdump]$ ipcs

------ Shared Memory Segments --------
key shmid owner perms bytes nattch status

------ Semaphore Arrays --------
key semid owner perms nsems

------ Message Queues --------
key msqid owner perms used-bytes messages

[oracle@C113247 bdump]$ ps -ef |grep ora_
oracle 18393 16846 0 17:58 pts/2 00:00:00 grep ora_
[oracle@C113247 bdump]$ ipcs -sb|grep oracle
ipcs: invalid option -- b
[oracle@C113247 bdump]$ ipcs |grep oracle
[oracle@C113247 bdump]$ ipcs -as|grep oracle
[oracle@C113247 bdump]$ sysresv

IPC Resources for ORACLE_SID "memcache" :
Shared Memory
ID KEY
No shared memory segments used
Semaphores:
ID KEY
No semaphore resources used
Oracle Instance not alive for sid "memcache"

[oracle@C113247 bdump]$ free
             total       used       free     shared    buffers     cached
Mem:       4150664    3668084     482580          0     118300    3048240
-/+ buffers/cache:     501544    3649120
Swap:      5668856        208    5668648
[oracle@C113247 bdump]$ vmstat 5 10
procs -----------memory---------- ---swap-- -----io---- --system-- ----cpu----
r b   swpd   free   buff cache   si   so    bi    bo   in    cs us sy id wa
0 0    208 482580 118300 3048240    0    0     0     7    0     0 0 0 99 0
0 0    208 482580 118300 3048240    0    0     0    31 1075    91 0 0 100 0
0 0    208 482580 118300 3048240    0    0     0    32 1058    93 0 0 100 0
1 0    208 482580 118300 3048240    0    0     0    26 1074    91 0 0 100 0
0 0    208 482644 118300 3048240    0    0     0    23 1051    95 0 0 100 0
0 0    208 482644 118300 3048240    0    0     0    29 1071    92 0 0 100 0
0 0    208 482580 118300 3048240    0    0     0    22 1051   100 0 0 99 0
0 0    208 482644 118300 3048240    0    0     0    22 1065    90 0 0 100 0
0 0    208 482644 118300 3048240    0    0     0    22 1057   101 0 0 100 0
0 0    208 482580 118300 3048240    0    0     0    19 1054    93 0 0 100 0