Exclusive mode... ORA 01102..
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Exclusive mode... ORA 01102..

  1. #1
    Join Date
    Oct 2000
    Posts
    449
    I have 2 instances on the server (8.1.6)
    Till noon it was fine..
    Now that I try to start up the 2nd instance, I set the ORACLE_SID and HOME and PATH to respective paths and when I start the db it says:
    ORA-01102: cannot mount database in EXCLUSIVE mode
    Why is this. The other DB is simply fine.. When I log into the unix as oracle user, the default profile is set to the other db and then when i need this 2nd instance I change and use..
    But not anymore, I tried shutting down the 1st.. same problem.. Why?
    Thx..

  2. #2
    Join Date
    Jan 2001
    Posts
    60
    Hi
    I have taken it from manual ,i am not sure how practically it works .

    Cause: An instance tried to mount the database in exclusive mode, but some other instance has already mounted the database in exclusive or parallel mode.

    Action: Either mount the database in parallel mode or shut down all other instances before mounting the database in exclusive mode

    Thanks
    lnr
    html code is off

  3. #3
    Join Date
    Jun 2000
    Location
    Chennai/India
    Posts
    90
    Hi,
    Have you tried the other way round, mount the second DB and then trying to mount the first DB ?
    Rgds
    Ganesh .R
    A Winner never Quits, A Quitter never Wins
    Ganesh .R

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width