***************
问题描述:
***************
数据库无法打开
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
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/10173379/viewspace-668879/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/10173379/viewspace-668879/