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;