This discussion is archived
1 2 Previous Next 17 Replies Latest reply: Feb 2, 2007 5:13 AM by 181444 RSS

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

552320 Newbie
Currently Being Moderated
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 Expert
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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