11 Replies Latest reply: Mar 18, 2013 11:50 AM by TSharma-Oracle RSS

    ORA-01102: cannot mount database in EXCLUSIVE mode

    973295
      Hi ,

      To give a small background , today I was getting the following error while trying to connect to one of the schema.
      I am seeing the same error on my EM console too.

      ORA-01033: ORACLE initialization or shutdown in progress (DBD ERROR: OCISessionBegin)

      To resolve this issues , I thought of doing a manual start up . The shutdown was successful and failed to mount the DB . I am getting this error "ORA-01102: cannot mount database in EXCLUSIVE mode"

      SQL> shutdown abort;
      ORACLE instance shut down.
      SQL> startup;
      ORACLE instance started.

      Total System Global Area 1653518336 bytes
      Fixed Size 2176288 bytes
      Variable Size 1275071200 bytes
      Database Buffers 369098752 bytes
      Redo Buffers 7172096 bytes
      ORA-01102: cannot mount database in EXCLUSIVE mode

      Could someone help me in resolving this issue? I am using Oracle 11.2.0 on Window 7

      Thanks,
      Lakshmi
        • 1. Re: ORA-01102: cannot mount database in EXCLUSIVE mode
          TSharma-Oracle
          I think there is some lock being held on oracle by a previous shutdown.

          Try do this:

          Shutdown abort;

          Go to the task manager and kill 'oracle.exe'. Kill if there is any sqlplus.exe and tnslsnr.exe also.

          startup database;

          Also, How many databases are running on this windows 7 machine?
          • 2. Re: ORA-01102: cannot mount database in EXCLUSIVE mode
            EdStevens
            970292 wrote:
            Hi ,

            To give a small background , today I was getting the following error while trying to connect to one of the schema.
            I am seeing the same error on my EM console too.

            ORA-01033: ORACLE initialization or shutdown in progress (DBD ERROR: OCISessionBegin)

            To resolve this issues , I thought of doing a manual start up . The shutdown was successful and failed to mount the DB . I am getting this error "ORA-01102: cannot mount database in EXCLUSIVE mode"

            SQL> shutdown abort;
            ORACLE instance shut down.
            SQL> startup;
            ORACLE instance started.

            Total System Global Area 1653518336 bytes
            Fixed Size 2176288 bytes
            Variable Size 1275071200 bytes
            Database Buffers 369098752 bytes
            Redo Buffers 7172096 bytes
            ORA-01102: cannot mount database in EXCLUSIVE mode

            Could someone help me in resolving this issue? I am using Oracle 11.2.0 on Window 7
            What edition of Windows? Home? Pro? Ultimate?
            >
            Thanks,
            Lakshmi
            • 3. Re: ORA-01102: cannot mount database in EXCLUSIVE mode
              973295
              Thanks for your response .

              I could see two processes oracle.exe . I could not kill one of them .

              C:\windows\system32>tasklist

              Image Name PID Session Name Session# Mem Usage
              ========================= ======== ================ =========== ============
              oracle.exe 2856 Services 0 268,388 K
              oracle.exe 5408 Services 0 211,972 K

              Though I kill both the process . (Process 2856 always shows up ) . Killing the process 5408 stops the Oracleservice.

              Also only one DB is set up on this machine.

              Thanks,
              • 4. Re: ORA-01102: cannot mount database in EXCLUSIVE mode
                973295
                Windows 7 Professional edition
                • 5. Re: ORA-01102: cannot mount database in EXCLUSIVE mode
                  TSharma-Oracle
                  Do you have Oracle restart setup on your machine?

                  How many databases are running on this machine?
                  • 6. Re: ORA-01102: cannot mount database in EXCLUSIVE mode
                    973295
                    There is only one DB instance running on my machine .
                    I don't have restart set up .
                    • 7. Re: ORA-01102: cannot mount database in EXCLUSIVE mode
                      TSharma-Oracle
                      Go to the command prompt and run this command and post the result

                      crsctl stop has
                      • 8. Re: ORA-01102: cannot mount database in EXCLUSIVE mode
                        973295
                        I am not able to execute this command

                        C:\windows\system32>crsctl stop has
                        'crsctl' is not recognized as an internal or external command,
                        operable program or batch file.

                        (Do I need to install any utility ?)

                        I just of sharing the output the listerner status

                        C:\windows\system32>lsnrctl status

                        LSNRCTL for 32-bit Windows: Version 10.1.0.5.0 - Production on 15-MAR-2013 16:44
                        :04

                        Copyright (c) 1991, 2004, Oracle. All rights reserved.

                        Connecting to (ADDRESS=(PROTOCOL=tcp)(PORT=1521))
                        STATUS of the LISTENER
                        ------------------------------------
                        Alias LISTENER
                        Version TNSLSNR for 64-bit Windows: Version 11.2.0.1.0 - Produ
                        ction
                        Start Date 15-MAR-2013 15:34:26
                        Uptime 0 days 1 hr. 9 min. 38 sec
                        Trace Level off
                        Security ON: Local OS Authentication
                        SNMP OFF
                        Listener Parameter File C:\POSSuiteApps\OracleDB\product\11.2.0\dbhome_1\netwo
                        rk\admin\listener.ora
                        Listener Log File c:\possuiteapps\oracledb\diag\tnslsnr\lapattab-us\list
                        ener\alert\log.xml
                        Listening Endpoints Summary...
                        (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=lapattab-us.us.oracle.com)(PORT=1521
                        )))
                        (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC1521ipc)))
                        Services Summary...
                        Service "CLRExtProc" has 1 instance(s).
                        Instance "CLRExtProc", status UNKNOWN, has 1 handler(s) for this service...
                        Service "orcl.us.oracle.com" has 1 instance(s).
                        Instance "orcl", status BLOCKED, has 1 handler(s) for this service...
                        The command completed successfully
                        • 9. Re: ORA-01102: cannot mount database in EXCLUSIVE mode
                          Osama_Mustafa
                          Could someone help me in resolving this issue? I am using Oracle 11.2.0 on Window 7
                          which version of windows 7 you are using ?
                          • 10. Re: ORA-01102: cannot mount database in EXCLUSIVE mode
                            973295
                            I am using Windows 7 Professional edition (64 bit) .

                            Also , I tried restarting my machine which killed one of the oracle.exe process and I was able to start and mount the DB successfully .

                            Thanks!

                            Edited by: 970292 on Mar 18, 2013 11:46 AM
                            • 11. Re: ORA-01102: cannot mount database in EXCLUSIVE mode
                              TSharma-Oracle
                              This is what I was trying to achieve by getting your process killed. In Windows , "Restart always works" ;)
                              Please mark your question answered if your problem is resolved.