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:
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
useful me
Thanks
Even I got same error I killed all the other sid process running . Now I am able to open the database.
Excellent!
Simple and clear explanation made me to drive easy!!!!
Thank you
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.
Please refer to following link:
http://www.dba-oracle.com/t_ora_01102_cannot_mount_database_in_exclusive_mode.htm
Hope it helps
regards
Anju Garg
super, the above solution “(killing the processes) is working fine, thanks
very useful
Thanks for your time and feedback.
Your comments and suggestions are always welcome.
regards
Anju Garg
Thanks, very useful.
Regards
Roberto
Excelent! Thanks!