This discussion is archived
12 Replies Latest reply: Feb 19, 2013 7:30 AM by 972355 RSS

ORA-01102: cannot mount database in EXCLUSIVE mode

972355 Newbie
Currently Being Moderated
Good Morning to all ;

Please see following details. Really i tried to set "password" using orapwd utility.
I shut my DB normally. then i up DB.

export ORACLE_SID=testdb
$ sqlplus /nolog

SQL*Plus: Release 10.2.0.1.0 - Production on Tue Feb 19 12:08:48 2013
Copyright (c) 1982, 2005, Oracle. All rights reserved.

SQL> conn sys as sysdba
Enter password:
Connected to an idle instance.

SQL> startup
ORACLE instance started.

Total System Global Area 285212672 bytes
Fixed Size 1218992 bytes
Variable Size 79693392 bytes
Database Buffers 201326592 bytes
Redo Buffers 2973696 bytes
ORA-01102: cannot mount database in EXCLUSIVE mode


MY DB was working fine. I set newpassword for my DB using orapwd utility at *"EXCLUSIVE"* mode.
Here please see what i did :


SQL> show parameter pass;

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
remote_login_passwordfile string EXCLUSIVE

SQL> grant sysdba to x;
grant sysdba to x
*
ERROR at line 1:
ORA-01994: GRANT failed: password file missing or disabled

UNDER DBS DIR:

SQL> !
$ orapwd file=orapwtest password=system entries=3 force=y

*$ exit*

SQL> grant sysdba to x;
grant sysdba to x
*
ERROR at line 1:
ORA-01994: GRANT failed: password file missing or disabled

SQL> show parameter pass;

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
remote_login_passwordfile string EXCLUSIVE

I shut my DB. Again i  up mY DB ..

i am getting error : ORA-01102: cannot mount database in EXCLUSIVE mode

select log_mode from v$database;
select log_mode from v$database
*
ERROR at line 1:
ORA-01507: database not mounted

ALERT LOG DETAILS :

ALTER DATABASE   MOUNT
Tue Feb 19 12:08:59 2013
sculkget: failed to lock /u01/app/oracle/product/10.2.0/db_1/dbs/lkTESTDB exclusive
sculkget: lock held by PID: 8364
Tue Feb 19 12:08:59 2013
ORA-09968: unable to lock file
Linux Error: 11: Resource temporarily unavailable
Additional information: 8364
Tue Feb 19 12:08:59 2013
ORA-1102 signalled during: ALTER DATABASE   MOUNT...
  • 1. Re: ORA-01102: cannot mount database in EXCLUSIVE mode
    asahide Expert
    Currently Being Moderated
    Hi,

    This FAQ may help you.
    <<http://www.orafaq.com/forum/t/40030/0/>>
    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.
    Regards,
  • 2. Re: ORA-01102: cannot mount database in EXCLUSIVE mode
    Sunny kichloo Expert
    Currently Being Moderated
    Refer this thread

    http://arjudba.blogspot.in/2010/01/ora-01102-cannot-mount-database-in.html
  • 3. Re: ORA-01102: cannot mount database in EXCLUSIVE mode
    Osama_Mustafa Oracle ACE
    Currently Being Moderated
    post
    ps -ef | grep pmon
  • 4. Re: ORA-01102: cannot mount database in EXCLUSIVE mode
    JohnWatson Guru
    Currently Being Moderated
    This instance name
    export ORACLE_SID=testdb
    does not match this password file name
    $ orapwd file=orapwtest password=system entries=3 force=y
    --
    John Watson
    Oracle Certified Master DBA
    http://skillbuilders.com
  • 5. Re: ORA-01102: cannot mount database in EXCLUSIVE mode
    Hemant K Chitale Oracle ACE
    Currently Being Moderated
    I shut my DB normally
    What was the command ?
    What are the messages in the alert.log file relating to the shutdown ?

    Do you have multiple instances (with different SIDs) on the same server ?


    Hemant K Chitale
  • 6. Re: ORA-01102: cannot mount database in EXCLUSIVE mode
    LaserSoft Journeyer
    Currently Being Moderated
    >
    ALTER DATABASE MOUNT
    Tue Feb 19 12:08:59 2013
    sculkget: failed to lock /u01/app/oracle/product/10.2.0/db_1/dbs/lkTESTDB exclusive
    sculkget: lock held by PID: 8364
    >

    post

    $ps -ef|grep 8364

    Probably you are trying to start instance with the same files are accessible,
    however you can rename that file and they will be created.
  • 7. Re: ORA-01102: cannot mount database in EXCLUSIVE mode
    972355 Newbie
    Currently Being Moderated
    $ ps -ef | grep pmon
    oracle 4610 4553 0 13:34 pts/1 00:00:00 grep pmon

    $ export ORACLE_SID=testdb
    $ sqlplus /nolog

    SQL*Plus: Release 10.2.0.1.0 - Production on Tue Feb 19 13:34:27 2013
    Copyright (c) 1982, 2005, Oracle. All rights reserved.

    SQL> conn sys as sysdba
    Enter password:
    Connected to an idle instance.

    SQL> startup
    ORACLE instance started.

    Total System Global Area 285212672 bytes
    Fixed Size 1218992 bytes
    Variable Size 79693392 bytes
    Database Buffers 201326592 bytes
    Redo Buffers 2973696 bytes
    Database mounted.
    Database opened.

    SQL> show parameter pass;

    NAME TYPE VALUE
    ------------------------------------ ----------- ------------------------------
    remote_login_passwordfile string EXCLUSIVE

    SQL> grant sysdba to x;
    grant sysdba to x
    *
    ERROR at line 1:
    ORA-01994: GRANT failed: password file missing or disabled


    SQL> !
    $ cd $ORACLE_HOME
    $ cd dbs/

    $ orapwd file=orapwtestdb password=system force=y entries=3
    $ exit
    exit
    SQL> show parameter pass;

    NAME TYPE VALUE
    ------------------------------------ ----------- ------------------------------
    remote_login_passwordfile string EXCLUSIVE

    SQL> grant sysdba to x;
    Grant succeeded.


    and one more , watson
    i set password multiple times using orapwd utility.
    Already i changed SID_name from orapwtest to orapwtestdb.
    Yes. I'm sure .. Now My DB is working. Still i 'm not clear.

    What was  the error.
    How it was automatically  cleared.

    Thanks to all;


    one more question :

    When checking alerty log : sculkget: failed to lock /u01/app/oracle/product/10.2.0/db_1/dbs/lkTESTDB exclusive

    what's the purpose of  lksid_file under dbs directory ..
  • 8. Re: ORA-01102: cannot mount database in EXCLUSIVE mode
    Girish Sharma Guru
    Currently Being Moderated
    You are having two questions :

    1.How your ORA-01102 gone ?
    2.How you are now able to grant sysdba to a; ?

    For 1st question :

    The "lk<sid>" and "sgadef<sid>.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.

    For 2nd questions :

    Your instance name is testdb, while you created password file name as orapwd file=orapwtest... and when you are going to say grant sysdba to a; oracle is not finding orapw<sid>.ora file so it was giving you ORA-01994: GRANT failed: password file missing or disabled.

    Now when you said :
    orapwd file=orapwtestdb ... so, you are doing right i.e. orapw<sid> so your grant sysdba to a; got succeed. No magic, you did correct, oracle always works correct :)

    Regards
    Girish Sharma
  • 9. Re: ORA-01102: cannot mount database in EXCLUSIVE mode
    972355 Newbie
    Currently Being Moderated
    Hello to all;

    I am getting error continuously
    ERROR at line 1:
    ORA-01102: cannot mount database in EXCLUSIVE mode

    *>> I created DB in silent mode >>*

    $ dbca -silent -createDatabase \
    -templateName General_Purpose.dbc \
    -gdbName MYDB \
    -sid MYDB \
    -sysPassword mysyspasswd \
    -systemPassword mysystempasswd \
    -emConfiguration NONE \
    -datafileDestination /u02/oracle/oradata \
    -recoveryAreaDestination /u02/oracle/orafra \
    -storageType FS \
    -characterSet AL32UTF8 \
    -nationalCharacterSet UTF8 \
    -registerWithDirService false \
    -listeners LISTENER_1521;
    Copying database files
    1% complete
    3% complete
    11% complete
    18% complete
    26% complete
    37% complete
    Creating and starting Oracle instance
    40% complete
    45% complete
    50% complete
    55% complete
    56% complete
    60% complete
    62% complete
    Completing Database Creation
    66% complete
    70% complete
    73% complete
    85% complete
    96% complete
    100% complete
    Look at the log file "/u01/app/oracle/product/10.2.0/db_1/cfgtoollogs/dbca/MYDB/MYDB.l og" for further details.

    *>> Connecting MYDB >>*


    $ export ORACLE_SID=mydb
    $ sqlplus /nolog

    SQL*Plus: Release 10.2.0.1.0 - Production on Tue Feb 19 20:24:00 2013
    Copyright (c) 1982, 2005, Oracle. All rights reserved.

    SQL> conn /as sysdba
    Connected to an idle instance.
    SQL> startup
    ORA-01078: failure in processing system parameters
    LRM-00109: could not open parameter file '/u01/app/oracle/product/10.2.0/db_1/dbs/initmydb.ora'

    SQL> startup pfile='/u01/app/oracle/admin/MYDB/pfile/initmydb.ora' nomount;
    ORACLE instance started.

    Total System Global Area 285212672 bytes
    Fixed Size 1218992 bytes
    Variable Size 92276304 bytes
    Database Buffers 188743680 bytes
    Redo Buffers 2973696 bytes

    SQL> select name from v$database;
    select name from v$database
    *
    ERROR at line 1:
    ORA-01507: database not mounted


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


    SQL> alter database mount;
    alter database mount
    ***
    ERROR at line 1:
    ORA-01102: cannot mount database in EXCLUSIVE mode
  • 10. Re: ORA-01102: cannot mount database in EXCLUSIVE mode
    JohnWatson Guru
    Currently Being Moderated
    969352 wrote:

    $ export ORACLE_SID=mydb
    $ sqlplus /nolog
    export ORACLE_SID=MYDB
  • 11. Re: ORA-01102: cannot mount database in EXCLUSIVE mode
    sb92075 Guru
    Currently Being Moderated
    969352 wrote:
    Hello to all;

    I am getting error continuously
    ERROR at line 1:
    ORA-01102: cannot mount database in EXCLUSIVE mode

    *>> I created DB in silent mode >>*

    $ dbca -silent -createDatabase \
    -templateName General_Purpose.dbc \
    -gdbName MYDB \
    -sid MYDB \
    -sysPassword mysyspasswd \
    -systemPassword mysystempasswd \
    -emConfiguration NONE \
    -datafileDestination /u02/oracle/oradata \
    -recoveryAreaDestination /u02/oracle/orafra \
    -storageType FS \
    -characterSet AL32UTF8 \
    -nationalCharacterSet UTF8 \
    -registerWithDirService false \
    -listeners LISTENER_1521;
    Copying database files
    1% complete
    3% complete
    11% complete
    18% complete
    26% complete
    37% complete
    Creating and starting Oracle instance
    40% complete
    45% complete
    50% complete
    55% complete
    56% complete
    60% complete
    62% complete
    Completing Database Creation
    66% complete
    70% complete
    73% complete
    85% complete
    96% complete
    100% complete
    Look at the log file "/u01/app/oracle/product/10.2.0/db_1/cfgtoollogs/dbca/MYDB/MYDB.l og" for further details.

    *>> Connecting MYDB >>*


    $ export ORACLE_SID=mydb
    on any *?NIX* ORACLE_SID is CaseSenSitive

    "MYDB" is different from "mydb"

    what occurs when you do as below?

    $ export ORACLE_SID=MYDB
  • 12. Re: ORA-01102: cannot mount database in EXCLUSIVE mode
    972355 Newbie
    Currently Being Moderated
    Thanks Watson and Sb; I up my database.


    SQL> startup
    ORACLE instance started.

    Total System Global Area 285212672 bytes
    Fixed Size 1218992 bytes
    Variable Size 92276304 bytes
    Database Buffers 188743680 bytes
    Redo Buffers 2973696 bytes
    Database mounted.
    Database opened.
    SQL> select name from v$database;

    NAME
    ---------
    MYDB

    Thanks to all and all replies ..

    *Any specific commands to open my database automatically ? [ in silent mode installation using DBCA ].*

    +I faced some problems with SILENT MODE. [ Some confusions and also lagging to understand editing response files]+
    +I will start a new thread for silent mode [installation and  DB Creation] .+

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points