Friday , August 18 2017
Home / Oracle DBA / ORA-01102: cannot mount database in EXCLUSIVE mode

ORA-01102: cannot mount database in EXCLUSIVE mode

ORA-01102 ORA-09968 Error While Starting Oracle Database:
 
[oracle@dba1 ~]$ export ORACLE_SID=crd
[oracle@dba1 ~]$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.1.0 Production on Thu Jul 20 12:51:49 2017
Copyright (c) 1982, 2009, Oracle. All rights reserved.
Connected to an idle instance.
SQL> startup
ORACLE instance started.
Total System Global Area 284565504 bytes
Fixed Size 1336036 bytes
Variable Size 100666652 bytes
Database Buffers 176160768 bytes
Redo Buffers 6402048 bytes
ORA-01102: cannot mount database in EXCLUSIVE mode

* Database alert log might show following error.
thu 24 Jul 20 12:47 2017
ALTER DATABASE MOUNT
sculkget: failed to lock /u01/app/oracle/product/11.2.0/dbhome_1/dbs/lkCRD exclusive
sculkget: lock held by PID: 64
ORA-09968: unable to lock file
Linux-x86_64 Error: 11: Resource temporarily unavailable

*You might have already ensured that no other instances of this Oracle database is running on this server.
[oracle@dba1 ~]$ ps -ef|grep pmon
oracle 19353 1 0 09:16 ? 00:00:00 ora_pmon_chsr
oracle 25257 19498 0 13:12 pts/1 00:00:00 grep pmon
SOLUTION :
*Check for the file pointed by alert log. In my case it was $ORACLE_HOME/dbs/lkCRD i.e lk<SID>. Delete this file and starup the instance.

[oracle@dba1 ~]$ cd /u01/app/oracle/product/11.2.0/dbhome_1/dbs
[oracle@dba1 dbs]$ ls -lrt
total 48
-rw-r--r-- 1 oracle oinstall 2851 May 15 2009 init.ora
drwx------ 2 oracle oinstall 4096 Jul 14 17:51 peshm_DBUA0_0
-rw-rw---- 1 oracle oinstall 1544 Jul 14 17:51 hc_DBUA0.dat
drwx------ 2 oracle oinstall 4096 Jul 14 17:53 peshm_chsr_0
-rw-rw---- 1 oracle oinstall 1544 Jul 14 17:53 hc_chsr.dat
-rw-r----- 1 oracle oinstall 24 Jul 14 18:25 lkCHSR
-rw-r----- 1 oracle oinstall 2560 Jul 15 18:23 spfilechsr.ora.bkp
drwx------ 2 oracle oinstall 4096 Jul 20 12:44 peshm_crd_0
-rw-rw---- 1 oracle oinstall 1544 Jul 20 12:45 hc_crd.dat
-rw-r----- 1 oracle oinstall 24 Jul 20 12:47 lkCRD
-rw-r----- 1 oracle oinstall 1536 Jul 20 12:48 orapwcrd
-rw-r----- 1 oracle oinstall 3584 Jul 20 12:49 spfilecrd.ora

[oracle@dba1 dbs]$ rm -rf lkCRD
[oracle@dba1 dbs]$ cd
[oracle@dba1 ~]$ export ORACLE_SID=crd
[oracle@dba1 ~]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.1.0 Production on Thu Jul 20 13:15:06 2017

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

Connected to an idle instance.

SQL> startup
ORACLE instance started.

Total System Global Area 284565504 bytes
Fixed Size 1336036 bytes
Variable Size 100666652 bytes
Database Buffers 176160768 bytes
Redo Buffers 6402048 bytes
Database mounted.
Database opened.
SQL>

Comments

comments

Check Also

How to switch on primary database to physical standby database

After configuration data guard then data is switching  into primary database  to standby database : …

Leave a Reply

Your email address will not be published. Required fields are marked *