12 Replies Latest reply: Feb 19, 2013 9:30 AM by 972355 RSS

    ORA-01102: cannot mount database in EXCLUSIVE mode

    972355
      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
          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
            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
              post
              ps -ef | grep pmon
              • 4. Re: ORA-01102: cannot mount database in EXCLUSIVE mode
                JohnWatson
                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
                  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
                    >
                    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
                      $ 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
                        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
                          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
                            969352 wrote:

                            $ export ORACLE_SID=mydb
                            $ sqlplus /nolog
                            export ORACLE_SID=MYDB
                            • 11. Re: ORA-01102: cannot mount database in EXCLUSIVE mode
                              sb92075
                              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
                                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] .+