ora-01102 cannot mount database in exclusive mode.
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: ora-01102 cannot mount database in exclusive mode.

  1. #1
    Join Date
    Nov 2001
    Location
    chicago
    Posts
    13
    i have 2 databases 'oracle' and 'praveen' on same server.
    operating system is windows NT.
    when i startup the database it is giving the error
    ora-01102 cannot mount the database in exclusive mode.
    is this problem because of two databases or any other problem?.
    what is exclusive mode?.
    should i have to change the mode to startup the database?.
    where i should i have to change?.
    can i open 2 databases at a particular point of time by giving startup pfile='.....................' for differnet init.ora files of different databases?.
    is it possible.
    give me the solution .
    i will thankfull.



    kreddy

  2. #2
    Join Date
    Aug 2001
    Location
    Waterloo, On
    Posts
    547
    This error occurs if some other instance has the database mounted exclusive or shared. You can have two databases running on the same machine but you should have sufficient real memory for SGAs of both the databases.

    Is the problem because Instance names are same? Do you have different init.ora files (with different names) for both databases?

    Raminder Singh

    Oracle Certified DBA: Oracle 8i, 9i


    Mail me at raminderahluwalia@rediffmail.com.

  3. #3
    Join Date
    Nov 2001
    Location
    chicago
    Posts
    13
    thank u for reply,
    but i have same name 'init.ora' for 2 different database 'oracle' and 'praveen'.
    can i change the name os the file 'init.ora' now?.
    if so how is it?.
    i have sufficient rel memory for sga's of both databases.
    i want to run the 2 databases at a time.

    kreddy

  4. #4
    Join Date
    May 2000
    Location
    Huntsville, AL. USA
    Posts
    52

    Specify the init file name when starting up the db

    Since you have two instances, you will need to specify the pfile (initfile) when starting the database. If you do this then you shouldn't get that error.

    STARTUP PFILE=PATH\FILENAME (this will be path/name of init file for that instance)

    HTH,
    Rainman

  5. #5
    Join Date
    Aug 2001
    Location
    Waterloo, On
    Posts
    547
    Since the parameter DB_NAME is different, you cannot have same init.ora for both databases. Copy your init.ora with OS commands, change the required parameters in the second init.ora and then open both databases one by one with pfile=' '.

    Raminder Singh

    Oracle Certified DBA: Oracle 8i, 9i


    Mail me at raminderahluwalia@rediffmail.com.

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