Wednesday, June 24, 2015

ORA-01102 cannot mount database in EXCLUSIVE mode

Users might receive error “ORA-01102” when trying to startup

01102, 00000, "cannot mount database in EXCLUSIVE mode"
// *Cause: Some other instance has the database mounted exclusive or shared.
// *Action: Shutdown other instance or mount in a compatible mode.

 You will receive this error when instance is already opening in parallel. You can resolve this issue by shutting down all the instances before mounting the database.

Verify that no background processes running owner as oracle
Ps –ef |grep <$ORACLE_SID>

If you found any processes then shutdown the instance, if you are not able to shutdown then you can kill by using “kill -9 <processed>.

Now you should be able to startup without any issues.

Regards
Satishbabu Gunukula, Oracle ACE
Posted by at
Labels: , , , , , ,

9 comments:

  1. AnnaDecember 25, 2015 at 9:52 PM

    Great and Useful Article.

    Java Online Training

    Java Course Online

    Java EE course

    Java Course in Chennai

    Java Training in Chennai

    Java Training Institutes in Chennai

    Java Interview Questions

    Java Interview Questions

    ReplyDelete
  2. sarah saadNovember 28, 2017 at 6:24 AM

    شركة نقل اثاث بالرياض
    شركة نقل اثاث بجدة
    شركة نقل اثاث بمكة

    ReplyDelete
  3. Pablo M.May 24, 2018 at 9:28 AM

    This text is sensational. hotsexyescort.com

    ReplyDelete
  4. product keyJune 20, 2018 at 1:42 AM

    Good post. Thank for sharing. You can visit my web: microsoft office 2013 product key

    ReplyDelete
  5. good daysOctober 14, 2018 at 4:54 AM

    شركة تنظيف بالاحساء
    شركة تنظيف مجالس بالاحساء شركة تنظيف مجالس بالاحساء
    شركة تنظيف كنب بالاحساء شركة تنظيف كنب بالاحساء
    شركة تنظيف منازل بمكة شركة تنظيف منازل بمكة

    ReplyDelete
  6. Background RemovalDecember 11, 2018 at 9:08 AM

    Background Removal Services (BRS) is one of the best Clipping path service provider around the world. We offer our global customers: Raster to Vector Services, Photo Restoration Services Prices, Photo Neck Joint Service, Exposure Color Correction Service, Jewelry Photo, Retouching Services, Photo Color Correction Service, Image Mirror Effect Service, Cheap Retouching Services, Deep Etching Service,

    ReplyDelete
  7. Best Hand Held MassagerFebruary 2, 2019 at 3:45 AM

    Best Handheld Massager the best handheld back massager Reviews site. You should know about handheld massager’s size, price range etc. How each of them can benefit you.

    ReplyDelete
  8. Web HostingFebruary 23, 2019 at 10:06 AM

    Host your website at sernethosting and experience true cloud hosting technology. SSD VPS hosting for a fast & secure website. The best 2019's price in the market guaranteed!

    ReplyDelete
  9. Iprint CalendarApril 12, 2019 at 3:50 AM

    Download and customize editable 2019 monthly calendar template in word, xls/xlsx, and pdf format

    ReplyDelete

Subscribe to: Post Comments (Atom)