来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/163177/viewspace-755475/
oracle 11.2.0.1 for linux ,在startup或startup mount时,时,报ORA-的错误。
alert日志中有如下信息:
ALTER DATABASE MOUNT
ORA-00210: ???????????
ORA-00202: ????: ''/home/oracle/oracle/flash_recovery_area/cnyz/control02.ctl''
ORA-27086: ?????? - ??????
Linux-x86_64 Error: 11: Resource temporarily unavailable
Additional information: 8
Additional information: 5831
ORA-00210: ???????????
ORA-00202: ????: ''/home/oracle/oracle/oradata/cnyz/control01.ctl''
ORA-27086: ?????? - ??????
Linux-x86_64 Error: 11: Resource temporarily unavailable
Additional information: 8
Additional information: 5831
Thu Mar 07 11:29:47 2013
Checker run found 2 new persistent data failures
ORA-205 signalled during: ALTER DATABASE MOUNT...
思路:
1、看一下"lk" and "sgadef.dbf"这两个文件是不是存在着,如果存在将其删掉;
2、看是不是有后台进程存在;
3、看一下oracle的共享内存段及信号集(semaphores)是不是还存在着;
实际操作:
[oracle@linux ~]$ cd $ORACLE_HOME/dbs
[oracle@linux dbs]$ ls
hc_SID.dat initdw.ora init.ora lkSID orapwSID spfileSID.ora
[oracle@linux dbs]$ rm lkSID
[oracle@linux dbs]$ ls
hc_SID.dat initdw.ora init.ora orapwSID spfileSID.ora
[oracle@linux dbs]$ ps -ef|grep ora_|grep SID
oracle 4981 1 0 09:00 ? 00:00:00 ora_pmon_SID
oracle 4983 1 0 09:00 ? 00:00:00 ora_psp0_SID
oracle 4985 1 0 09:00 ? 00:00:00 ora_mman_SID
oracle 4987 1 0 09:00 ? 00:00:00 ora_dbw0_SID
oracle 4989 1 0 09:00 ? 00:00:00 ora_lgwr_SID
oracle 4991 1 0 09:00 ? 00:00:01 ora_ckpt_SID
oracle 4993 1 0 09:00 ? 00:00:01 ora_smon_SID
oracle 4995 1 0 09:00 ? 00:00:00 ora_reco_SID
oracle 4997 1 0 09:00 ? 00:00:00 ora_cjq0_SID
oracle 4999 1 0 09:00 ? 00:00:07 ora_mmon_SID
oracle 5001 1 0 09:00 ? 00:00:00 ora_mmnl_SID
oracle 5003 1 0 09:00 ? 00:00:00 ora_d000_SID
oracle 5005 1 0 09:00 ? 00:00:00 ora_s000_SID
oracle 5023 1 0 09:00 ? 00:00:00 ora_qmnc_SID
oracle 5133 1 0 09:00 ? 00:00:00 ora_q000_SID
oracle 5139 1 0 09:00 ? 00:00:00 ora_q001_SID
oracle 31755 1 1 13:21 ? 00:00:00 ora_j000_SID
[oracle@linux dbs]$ ps -ef|grep ora_|grep SID|grep pmon
oracle 4981 1 0 09:00 ? 00:00:00 ora_pmon_SID
[oracle@linux dbs]$ kill -9 4981
[oracle@linux dbs]$ ps -ef|grep ora_|grep SID|grep pmon
[oracle@linux dbs]$ ipcs -m
------ Shared Memory Segments --------
key shmid owner perms bytes nattch status
重新startup数据库,问题解决。