Sunday 14 May 2017

Problem Mounting Database in Exclusive Mode | ORA-01102

Problem Mounting Database in Exclusive Mode | ORA-01102

For those who are experienced with installing and configuring Oracle Database in UNIX/LINUX Distributions, this is the error that they face at least once in a lifetime. Although I have seen the same issue so many time that I can't remember but the approach I use to resolve the error has always been same.

ORA-01102: cannot mount database in exclusive mode
Cause: Some other instance has the database mounted exclusive or shared.
Action: Shut down the other instance or mount in a compatible mode.

ORA-01102 occurs when the Instance is already up in parallel mode and you are trying to open the same instance again by using the Startup command because it showed you that you are connected to idle instance in the first place.

As the action suggests that you should shut down the other instance and for that follow the below mentioned steps to resolve this issue:

Verify if there are existing oracle processes for the database :

  $ ps -ef | grep $ORACLE_SID

Kill the hanging processes to release the lock on the file handle :

  $ kill -9 <PID>

No comments:

Post a Comment