1 2 Previous Next 17 Replies Latest reply: Feb 2, 2007 7:13 AM by 181444 RSS

    Pls need your help!! ORA-01102: cannot mount database in EXCLUSIVE mode

    552320
      I really appreciate if you can help me.

      In the test environment Oracle 10g r2, I was trying to change some init.ora parameters and some flashback database parameters. Flashback required to start in mount exclusive, and the init parameters only start mount. I do not know the difference between mount and mount exclusive. i used start mount exclusive to alter all the parameters. At the end, I used ALTER DATABASE OPEN. Now, I can't start the database. The following is the error that I am getting. Can you explain the difference between start mount and start mount exclusive.
      Thanks, Terry
      -----------------------------------------------------------------------------------------------
      Connected to:
      Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bit Production
      With the Partitioning, OLAP and Data Mining options

      SQL> startup mount;
      ORA-01081: cannot start already-running ORACLE - shut it down first
      SQL> shutdown immediate;
      ORA-01507: database not mounted


      ORACLE instance shut down.
      SQL> startup mount;
      ORACLE instance started.

      Total System Global Area 612368384 bytes
      Fixed Size 1980616 bytes
      Variable Size 230688568 bytes
      Database Buffers 377487360 bytes
      Redo Buffers 2211840 bytes
      ORA-01102: cannot mount database in EXCLUSIVE mode
        • 1. Re: Pls need your help!! ORA-01102: cannot mount database in EXCLUSIVE mode
          181444
          For a non-RAC database startup mount and startup mount exclusive are the same.

          The boiler plate did not indicate RAC is installed and in use. The database parameter cluster_database should be set to FALSE (default).

          Check the alert log for any signs or real erros. If none you might try doing a shutdown abort. Then start the database normally and let it do its thing (recover). Then shutdown immediate and try to make your change.

          But check the alert log and the udump, bdump destinations to make sure there are no serious problems going on first.

          If you are RAC in spite of the boiler plate you have to shutdown all instances before you can start one instance in exclusive mode.

          HTH -- Mark D Powell --
          • 2. Re: Pls need your help!! ORA-01102: cannot mount database in EXCLUSIVE mode
            97979
            start mount and start mount exclusive is the same because default for start mount is exclusive mode.

            if you use UNIX/LINUX

            post the output of the ls -l $ORACLE/dbs

            The database may not shutdown properly. Do you did any change to the init file? also look into alter.log for more infomation
            • 3. Re: Pls need your help!! ORA-01102: cannot mount database in EXCLUSIVE mode
              552320
              Mark,

              I checked the alert logs, and i only found the following error. I do not think that's the issue: Error in the log file Thank you so much for your help, Terry
              ---------------------------------------------------------------------------------------
              Thu Feb 1 13:54:59 2007
              ALTER DATABASE MOUNT
              Thu Feb 1 13:54:59 2007
              sculkget: failed to lock /export/home/oracle/products/10.2.0//dbs/lkORCL exclusive
              sculkget: lock held by PID: 12712
              Thu Feb 1 13:54:59 2007
              ORA-09968: unable to lock file
              SVR4 Error: 11: Resource temporarily unavailable
              Additional information: 12712
              Thu Feb 1 13:54:59 2007
              ORA-1102 signalled during: ALTER DATABASE MOUNT...
              Thu Feb 1 13:54:59 2007
              ALTER DATABASE ARCHIVELOG
              ORA-1507 signalled during: ALTER DATABASE ARCHIVELOG...
              Thu Feb 1 13:54:59 2007
              ALTER DATABASE OPEN
              ORA-1507 signalled during: ALTER DATABASE OPEN...
              Thu Feb 1 13:54:59 2007
              ALTER SYSTEM SET user_dump_dest='//export/home/oracle/admin/orcl/bkControl' SCOPE=BOTH;
              Thu Feb 1 13:54:59 2007
              ALTER DATABASE BACKUP CONTROLFILE TO TRACE

              I shutdown abort and start it, but it comes with the same error:
              ----------------------------------------------------------------------------------------
              SQL> shutdown abort
              ORACLE instance shut down.
              SQL> startup
              ORACLE instance started.

              Total System Global Area 612368384 bytes
              Fixed Size 1980616 bytes
              Variable Size 234882872 bytes
              Database Buffers 373293056 bytes
              Redo Buffers 2211840 bytes
              ORA-01102: cannot mount database in EXCLUSIVE mode
              • 4. Re: Pls need your help!! ORA-01102: cannot mount database in EXCLUSIVE mode
                509719
                Its looks like you have two Oracle instance running. If this is the case you can never start second instance in exclusive mode.

                you can verify it by looking at oracle system process.

                Does restarting your server helped.
                • 5. Re: Pls need your help!! ORA-01102: cannot mount database in EXCLUSIVE mode
                  552320
                  Thre are two instance running. The system is not a RAC. I can't stop the server because developers are using the other instance for testing. Do you have any ideas how can I fix this instance without restarting the server? Thank you so much for your assistance, Terry
                  • 6. Re: Pls need your help!! ORA-01102: cannot mount database in EXCLUSIVE mode
                    97979
                    This mean you database not shutdown properly. If is it the only database in this server you can reboot the OS and it normally it will fix the problem. Or you can try this if you can't reboot the OS:
                    startup force
                    Key:
                    FORCE
                    Shut down the current Oracle instance (if it is running) with
                    SHUTDOWN mode ABORT, before restarting it.
                    If the current instance is running and FORCE is not specified,
                    an error results. FORCE is useful while debugging and under abnormal
                    circumstances. It should not normally be used.
                    • 7. Re: Pls need your help!! ORA-01102: cannot mount database in EXCLUSIVE mode
                      97979
                      Its looks like you have two Oracle instance running.
                      If this is the case you can never start second
                      instance in exclusive mode.
                      that is not true that you can't run two instance in one machie. The only thing that is true is that you can't start two database have same SID in same machine. So if two instance have different SID then make sure which SID you are handle with. In you alert log it seem SID=ORCL
                      • 8. Re: Pls need your help!! ORA-01102: cannot mount database in EXCLUSIVE mode
                        552320
                        I STARTUP FORCE, and it came with the same error. Error at the bottom. Thanks

                        ---------------------------------------------------------------------------------------------------

                        SQL> startup
                        ORA-01081: cannot start already-running ORACLE - shut it down first
                        SQL> shutdown immediate
                        ORA-01507: database not mounted


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

                        Total System Global Area 612368384 bytes
                        Fixed Size 1980616 bytes
                        Variable Size 234882872 bytes
                        Database Buffers 373293056 bytes
                        Redo Buffers 2211840 bytes
                        ORA-01102: cannot mount database in EXCLUSIVE mode
                        • 9. Re: Pls need your help!! ORA-01102: cannot mount database in EXCLUSIVE mode
                          97979
                          if you use UNIX/LUNIX

                          post output for those:

                          ls -l $ORACLE/dbs
                          ps -ef|grep ora_
                          • 10. Re: Pls need your help!! ORA-01102: cannot mount database in EXCLUSIVE mode
                            552320
                            sidney$ ps -ef| grep ora_
                            oracle 13663 1 0 16:39:46 ? 0:00 ora_mmon_orcl
                            oracle 13150 1 0 14:46:07 ? 0:00 ora_q000_orcl
                            oracle 13105 1 0 14:45:29 ? 0:02 ora_dbw0_orcl
                            oracle 13107 1 0 14:45:29 ? 0:01 ora_lgwr_orcl
                            oracle 13117 1 0 14:45:30 ? 0:04 ora_mmon_orcl
                            oracle 13099 1 0 14:45:28 ? 0:01 ora_pmon_orcl
                            oracle 13119 1 0 14:45:30 ? 0:05 ora_mmnl_orcl
                            oracle 13113 1 0 14:45:30 ? 0:00 ora_reco_orcl
                            oracle 13115 1 0 14:45:30 ? 0:01 ora_cjq0_orcl
                            oracle 13136 1 0 14:45:51 ? 0:00 ora_arc0_orcl
                            oracle 13152 1 0 14:46:07 ? 0:00 ora_q001_orcl
                            oracle 13126 1 0 14:45:36 ? 0:01 ora_rvwr_orcl
                            oracle 13680 13615 0 16:46:00 pts/6 0:00 grep ora_
                            oracle 13667 1 0 16:39:46 ? 0:00 ora_d000_orcl
                            oracle 13101 1 0 14:45:28 ? 0:01 ora_psp0_orcl
                            oracle 13142 1 0 14:45:56 ? 0:00 ora_qmnc_orcl
                            oracle 13138 1 0 14:45:52 ? 0:00 ora_arc1_orcl
                            oracle 13121 1 0 14:45:30 ? 0:00 ora_d000_orcl
                            oracle 13655 1 0 16:39:45 ? 0:00 ora_ckpt_orcl
                            oracle 13103 1 0 14:45:28 ? 0:01 ora_mman_orcl
                            oracle 13669 1 0 16:39:46 ? 0:00 ora_s000_orcl
                            oracle 13653 1 0 16:39:45 ? 0:00 ora_lgwr_orcl
                            oracle 13649 1 0 16:39:44 ? 0:01 ora_mman_orcl
                            oracle 13123 1 0 14:45:31 ? 0:00 ora_s000_orcl
                            oracle 13647 1 0 16:39:44 ? 0:00 ora_psp0_orcl
                            oracle 13659 1 0 16:39:45 ? 0:00 ora_reco_orcl
                            oracle 13111 1 0 14:45:29 ? 0:04 ora_smon_orcl
                            oracle 13109 1 0 14:45:29 ? 0:04 ora_ckpt_orcl
                            oracle 13665 1 0 16:39:46 ? 0:00 ora_mmnl_orcl
                            oracle 13678 1 0 16:45:05 ? 0:00 ora_j000_orcl
                            oracle 13651 1 0 16:39:45 ? 0:00 ora_dbw0_orcl
                            oracle 13657 1 0 16:39:45 ? 0:00 ora_smon_orcl
                            oracle 13645 1 0 16:39:44 ? 0:00 ora_pmon_orcl
                            oracle 13661 1 0 16:39:46 ? 0:00 ora_cjq0_orcl
                            sidney$
                            • 11. Re: Pls need your help!! ORA-01102: cannot mount database in EXCLUSIVE mode
                              509719
                              Looks like there was an instance failure last time.
                              Was databse shutdown normal last time.


                              oracle 13099 1 0 14:45:28 ? 0:01 ora_pmon_orcl
                              oracle 13645 1 0 16:39:44 ? 0:00 ora_pmon_orcl
                              oracle 13111 1 0 14:45:29 ? 0:04 ora_smon_orcl
                              oracle 13657 1 0 16:39:45 ? 0:00 ora_smon_orcl
                              • 12. Re: Pls need your help!! ORA-01102: cannot mount database in EXCLUSIVE mode
                                509719
                                You can kill pmon processes if required and next time you start the server instance recovery will be done and everything will comeback normal.
                                • 13. Re: Pls need your help!! ORA-01102: cannot mount database in EXCLUSIVE mode
                                  97979
                                  From the output you have two smon there, that mean you either use the wrong SID or you have a runaway oracle instance there:

                                  oracle 13111 1 0 14:45:29 ? 0:04 ora_smon_orcl
                                  oracle 13657 1 0 16:39:45 ? 0:00 ora_smon_orcl

                                  First you need clear what SID orcl for and make sure it is this database you want to start up. You said you have two instance there but I only see one SID. If you do have two instances you need figure out what the other SID is. When you 100% sure you want to handle ORCL instance in this server. do this:
                                  shutdown abort
                                  ps -ef|grep ora_smon
                                  if you see any output like this:
                                  oracle 13657 1 0 16:39:45 ? 0:00 ora_smon_orcl
                                  do the same again.( shutdown abort ps -ef|grep ora_smon)
                                  if they still not go away you have to reboot the sever or kill them manually by :

                                  kill -9

                                  it is dangerous to do this , so better ask system admin help you or reboot the server.
                                  • 14. Re: Pls need your help!! ORA-01102: cannot mount database in EXCLUSIVE mode
                                    509719
                                    Its looks like you have two Oracle instance running.
                                    If this is the case you can never start second
                                    instance in exclusive mode.
                                    that is not true that you can't run two instance in one machie.
                                    Anything is possible.
                                    1 2 Previous Next