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

原创 2013年12月05日 19:28:53
重新建库时遇到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>
问题解决。

【oracle案例】ORA-01102: cannot mount database in EXCLUSIVE mode

ORA-01102: cannot mount database in EXCLUSIVE mode 今天在fedora上安装完10g后,测试数据库是否安装成功。STARTUP数据库时,发生如下...

ORA-01102: cannot mount database in EXCLUSIVE mode 处理方法

报错现象: 数据库报出 ORA-01102 错误,无法 mount [oracle@edbjr2p2 ~]$ sqlplus / as sysdba SQL*Plus: Release 11.2.0....

Oracle ORA-01102故障: cannot mount database in EXCLUSIVE mode

SQL> conn /as sysdba Connected to an idle instance. SQL> startup oracle instance started. Tota...

错误 ORA-01102: cannot mount database in EXCLUSIVE mode 的处理方法

今天启动数据库时报错了! SQL> startup mount         ORACLE instance started.   Total System Global A...
  • lzwgood
  • lzwgood
  • 2014年05月20日 15:09
  • 4478

ORA-01102: cannot mount database in EXCLUSIVE mode

ORA-01102: cannot mount database in EXCLUSIVE mode场景再现:SQL> startupORACLE instance started.Total Sys...
  • luj999
  • luj999
  • 2011年06月27日 13:00
  • 217

While starting out of two DBs one DB getting error: ORA-01102: cannot mount database in EXCLUSIVE mo

While starting out of two DBs one DB getting error: ORA-01102: cannot mount database in EXCLUSIVE mo...
  • loryliu
  • loryliu
  • 2016年09月06日 16:50
  • 360

Oracle 错误:cannot mount database in EXCLUSIVE mode

refer:http://www.hellodba.com/Cases/case-unexception_down.htm=======================================...

RMAN-06817: Pluggable Database CHARLESPDB cannot be backed up in NOARCHIVELOG mode.

RMAN-06817

ORA-19602: cannot backup or copy active file in NOARCHIVELOG mode

今天在发出全备份命令rman>backup database 时出现了以上错误 Cause: You tried to copy or backup a file that was not clos...
  • yywzgh
  • yywzgh
  • 2012年06月06日 23:28
  • 645

Database Vault 重新建库

如果数据库安装了DatabaseVault功能,由于某些原因需要重新建库的话,整个过程以及Database Vault的功能恢复如下:1.      禁用Database Vault关闭相应的程序$ ...
内容举报
返回顶部
收藏助手
不良信息举报
您举报文章:重新建库时遇到ORA-01102cannot mount database in EXCLUSIVE mode
举报原因:
原因补充:

(最多只允许输入30个字)