重新建库时遇到ORA-01102cannot mount database in EXCLUSIVE mode

来源:互联网 发布:雨人软件是什么 编辑:程序博客网 时间:2024/06/08 11:09
重新建库时遇到ORA-01102: cannot mount database in EXCLUSIVE mode

症状
建库时出现ORA-01102: cannot mount database in EXCLUSIVE mode
分析
新建库的实例名与之前刚刚删掉的实例名一致,查看是否有原来实例的残留进程
ps -ef查看,果然:
[root@saprac4 ~]# ps -ef| grep ora_
root 2976 2652 0 15:33 pts/3 00:00:00 grep ora_
oracle 4897 1 0 14:47 ? 00:00:00 ora_pmon_rac4
oracle 4899 1 0 14:47 ? 00:00:00 ora_vktm_rac4
oracle 4903 1 0 14:47 ? 00:00:00 ora_diag_rac4
oracle 4905 1 0 14:47 ? 00:00:00 ora_dbrm_rac4
oracle 4907 1 0 14:47 ? 00:00:00 ora_ping_rac4
oracle 4909 1 0 14:47 ? 00:00:00 ora_psp0_rac4
oracle 4911 1 0 14:47 ? 00:00:00 ora_acms_rac4
oracle 4913 1 0 14:47 ? 00:00:00 ora_dskm_rac4
oracle 4915 1 0 14:47 ? 00:00:00 ora_dia0_rac4
oracle 4924 1 0 14:47 ? 00:00:00 ora_lmon_rac4
oracle 4926 1 0 14:47 ? 00:00:00 ora_lmd0_rac4
oracle 4928 1 0 14:47 ? 00:00:00 ora_lms0_rac4
oracle 4932 1 0 14:47 ? 00:00:00 ora_rms0_rac4
oracle 4934 1 0 14:47 ? 00:00:00 ora_mman_rac4
oracle 4936 1 0 14:47 ? 00:00:00 ora_dbw0_rac4
oracle 4938 1 0 14:47 ? 00:00:00 ora_lgwr_rac4
oracle 4940 1 0 14:47 ? 00:00:00 ora_ckpt_rac4
oracle 4942 1 0 14:47 ? 00:00:00 ora_smon_rac4
oracle 4944 1 0 14:47 ? 00:00:00 ora_reco_rac4
oracle 4950 1 0 14:47 ? 00:00:00 ora_mmon_rac4
oracle 4954 1 0 14:47 ? 00:00:00 ora_mmnl_rac4
oracle 4956 1 0 14:47 ? 00:00:00 ora_d000_rac4
oracle 4958 1 0 14:47 ? 00:00:00 ora_s000_rac4
oracle 4963 1 0 14:47 ? 00:00:00 ora_lck0_rac4
oracle 4971 1 0 14:47 ? 00:00:00 ora_rsmn_rac4
解决方案:
登陆数据库并shutdown原库。
[oracle@saprac4 ~]$ sqlplus / as sysdba

SQL*Plus: Release 11.1.0.6.0 - Production on Thu Dec 5 15:34:12 2013

Copyright (c) 1982, 2007, Oracle. All rights reserved.


Connected to:
Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 - 64bit Production
With the Partitioning, Real Application Clusters, OLAP, Data Mining
and Real Application Testing options

SQL> shutdown abort
ORACLE instance shut down.
SQL>
问题解决。