ORA-01102: cannot mount database in EXCLUSIVE mode

I received this error message when I was trying to mount the primary database in my dataguard configuration.

SQL> alter database mount;
alter database mount
*
ERROR at line 1:
ORA-01102: cannot mount database in EXCLUSIVE mode

Here is how I resolved it:

- Shutdown the primary database

SQL> shu immediate;
ORA-01507: database not mounted

– Find out all the processes belonging to the database still running

[oracle@EDP1R3P0-pc00sby1 dbs]$ ps -ef |grep ora_|grep pc00sb

– Kill all the processes

[oracle@EDP1R3P0-pc00sby1 dbs]$ kill -9 32231

– Check that there are no more processes running

[oracle@EDP1R3P0-pc00sby1 dbs]$ ps -ef |grep ora_|grep pc00sb

– startup the database – succeeeds

SQL> startup
ORACLE instance started.

Total System Global Area  439406592 bytes
Fixed Size                  1337072 bytes
Variable Size             348129552 bytes
Database Buffers           83886080 bytes
Redo Buffers                6053888 bytes
Database mounted.
Database opened.

—————————————————————-
Related links:

Home

11g R2 RAC Index

INS-08109 unexpected error occured while validating inputs at state ‘InstallOptions’
ORA-15040: diskgroup is incomplete
PROT-35: The configured Oracle Cluster Registry locations are not accessible
PRVF-5636 : The DNS response time for an unreachable node exceeded 15000 ms

 

10 thoughts on “ORA-01102: cannot mount database in EXCLUSIVE mode

  1. Thanks…But every time I restart my server, the same problem returns. How to get rid of this problem once and for all. Thanks again ..in advance.

Leave a Reply to wajid Cancel reply