Monday, 14 April 2014

ORA-01102: cannot mount database in EXCLUSIVE mode

Error: ORA-01102: cannot mount database in EXCLUSIVE mode

SQL> startup
ORACLE instance started.

Total System Global Area 4993982464 bytes
Fixed Size                  2236928 bytes
Variable Size             922750464 bytes
Database Buffers         4060086272 bytes
Redo Buffers                8908800 bytes
ORA-01102: cannot mount database in EXCLUSIVE mode


Reason: database is started in EXCLUSIVE mode by default. Therefore, the 
ORA-01102 error is misleading and may have occurred due to one of the 
following reasons: 

- there is still an "sgadef.dbf" file in the "ORACLE_HOME/dbs" 
directory 
- the processes for Oracle (pmon, smon, lgwr and dbwr) still exist 
- shared memory segments and semaphores still exist even though the 
database has been shutdown 
- there is a "ORACLE_HOME/dbs/lk" file 

The "lk" and "sgadef.dbf" files are used for locking shared memory. 
It seems that even though no memory is allocated, Oracle thinks memory is 
still locked. By removing the "sgadef" and "lk" files you remove any knowledge
oracle has of shared memory that is in use. Now the database can start.

SQL>
SQL> shutdown immediate
ORA-01507: database not mounted


ORACLE instance shut down.
SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
[oracle@bachdb dbs]$ ll
total 28
-rw-rw---- 1 oracle oinstall 1544 Apr  2 02:28 hc_micrdb.dat
-rw-rw---- 1 oracle oinstall 1544 Apr 14 22:44 hc_MICRDB.dat
-rw-r----- 1 oracle oinstall  941 Apr 14 22:42 initMICRDB.ora
-rw-r--r-- 1 oracle oinstall 2851 May 15  2009 init.ora
-rw-r----- 1 oracle oinstall   24 Apr  2 02:26 lkMICRDB
-rw-r----- 1 oracle oinstall 1536 Apr  2 02:29 orapwmicrdb
-rw-r----- 1 oracle oinstall 2560 Apr 14 02:34 spfilemicrdb.ora

[oracle@bachdb dbs]$ rm -rf lkMICRDB
[oracle@bachdb dbs]$ sqlplus

SQL*Plus: Release 11.2.0.3.0 Production on Mon Apr 14 22:45:00 2014

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

Enter user-name: /as sysdba
Connected to an idle instance.

SQL> startup
ORACLE instance started.

Total System Global Area 4993982464 bytes
Fixed Size                  2236928 bytes
Variable Size             922750464 bytes
Database Buffers         4060086272 bytes
Redo Buffers                8908800 bytes 
Database mounted.
Database opened.


SQL> exit

2 comments:

  1. Jadwal Daftar Sabung Ayam SV388 26 Februari 2019 - Selasa, 26 Februari 2019 – Pada Hari Tersebut Akan Di Laksanakan Berbagai Pertandingan Sabung Ayam Secara Live di Arena Sabung Ayam Thailand.

    Situs Judi Sabung Ayam Online SV388 Merupakan Situs Judi Asal Thailand Yang Sangat Terkenal Dengan Permainan Sabung Ayam Yang Fair dan Menghibur Para Penonton Judi Sabung Ayam.

    Untuk Info Lebih Lanjut Bisa Hub kami Di :
    wechat : bolavita
    line : cs_bolavita
    whatsapp : +628122222995
    BBM: BOLAVITA

    ReplyDelete
  2. Hello Everybody,
    My name is Mrs Sharon Sim. I live in Singapore and i am a happy woman today? and i told my self that any lender that rescue my family from our poor situation, i will refer any person that is looking for loan to him, he gave me happiness to me and my family, i was in need of a loan of $250,000.00 to start my life all over as i am a single mother with 3 kids I met this honest and GOD fearing man loan lender that help me with a loan of $250,000.00 SG. Dollar, he is a GOD fearing man, if you are in need of loan and you will pay back the loan please contact him tell him that is Mrs Sharon, that refer you to him. contact Dr Purva Pius, call/whats-App Contact Number +918929509036 via email:(urgentloan22@gmail.com) Thank you.

    ReplyDelete