DBAsupport.com Forums - Powered by vBulletin
Results 1 to 6 of 6

Thread: ORA-01102

  1. #1
    Join Date
    Jan 2002
    Posts
    94

    Question

    Hi,

    when I try to mount oracle8i database on Win2000 with svrmgrl I got the error message ora-01102 (not possible to mount database in exclusive mode). I guess, the reason is an another started instance but I do not know from any other startet instance. Is there a view to 'see' all started instances?

    Chris

  2. #2
    Join Date
    Dec 2001
    Posts
    221
    if you are in Windows environment -

    you can check the services in control panel.
    you can even check it from the Processes tab in Task Manager

    Santosh Jadhav
    8i OCP DBA

  3. #3
    Join Date
    Apr 2002
    Location
    Germany.Laudenbach
    Posts
    448
    Hello,
    Look at this, probably it helps

    http://www.orafaq.com/msgboard/windows/messages/851.htm

    There is no view accessible for viewing all Databases, i think

    Orca

  4. #4
    Join Date
    Apr 2002
    Location
    Germany.Laudenbach
    Posts
    448
    The services-dialog is not a help checking which db is online;
    The OracleService can be started but the db can still be down.

    Probably if there is a OracleStart... Service started then the Instance is already opened by startup.

    Look in registry, there are some entries which controls the startup-properties of the db.

    Orca

  5. #5
    Join Date
    Jan 2002
    Posts
    94
    The behavior of oracle is confusing sometimes!

    On svrmgrl I tried to mount the database an got the error message. So I made 'shutdown immediate' and tried to mount again. No success.

    I started the instance manager connected as internal and started the instance. NO PROBLEM!

    That is not a solution I think.

    Is the default value of the startup command 'exclusive' or what could be reason for this behavior?

    Chris

  6. #6
    Join Date
    May 2002
    Posts
    22
    I am also having the same problem.but i am having two databases on mu Oracle Server which in On Win NT.I am also having two services on server one for each database.i have set both services startup automatically.i have also try to startup another database with
    startup pfile=path of init.ora file
    i getting the same error.
    i have also posted my problem.I think you can try with this pfile option.I do not know whether it will help u or not.bz u are getting the same message thats way i replied.Best of Luck.

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