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

本文介绍了解决Oracle数据库启动时遇到ORA-01102错误的方法。此错误通常发生在尝试以独占模式挂载数据库时。文章详细说明了导致此问题的原因，并提供了一种解决方案：更改其中一个数据库的DB_UNIQUE_NAME。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

While starting out of two DBs one DB getting error: ORA-01102: cannot mount database in EXCLUSIVE mode (文档 ID 2152488.1)

9876

文档 ID

…

While starting out of two DBs one DB getting error: ORA-01102: cannot mount database in EXCLUSIVE mode (文档 ID 2152488.1)

In this Document

Applies to:

Oracle Database - Standard Edition - Version 11.2.0.3 to 12.1.0.2 [Release 11.2 to 12.1]
Information in this document applies to any platform.

Symptoms

Have 2 databases (prod and test) on the same machine, when startup the DB "test" and then try to startup the DB "prod" following error is coming.

[oracle@dbtest ~]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.3.0 Production on Tue Jun 7 08:18:15 2016

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

Connected to an idle instance.

SQL> startup
ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance
ORACLE instance started.

Total System Global Area 2622255104 bytes
Fixed Size 2231232 bytes
Variable Size 1627391040 bytes
Database Buffers 973078528 bytes
Redo Buffers 19554304 bytes
ORA-01102: cannot mount database in EXCLUSIVE mode

If the process done backwards, (startup first prod and then test, ) then get the same error ora-01102

Cause

Both the DBs have same db_unique_name

DB_UNIQUE_NAME specifies a globally unique name for the database.

Solution

Change DB_UNIQUE_NAME of one database:

1.) Shutdown Db (test DB)
2.) Shutdown Db (prod DB )

3.) Startup DB ( test DB)

4.) alter system set db_unique_name='<<TEST_NEW>>' scope=spfile;

5.) Shutdown and startup the DB (Test DB).

6.) Startup DB ( Prod )