Oracle instance startup problem
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: Oracle instance startup problem

  1. #1
    Join Date
    Mar 2001
    Posts
    45

    Unhappy

    Hi DBA Technocrats,

    I am working with WinNT 4.0, Oracle 8.1.6
    There are two instances named dwax, weblogic
    running in the same machine.
    to enable audit_trail, i modified the init.ora and shutdown both.
    I found database closed, and instances dis mounted.

    While restarting i got this error

    startup
    Ora-1081 cannot start already-running oracle - shut it down first.

    So i tried to run select * from v$instance;
    I saw oracle not available error.

    so again i issued startup force
    This time instance started,
    but ORA-1102 cannot mount database in EXCLUSIVE mode.

    Help me to sort it out.

    Thanks in advance.
    Ramesh.
    Thanx
    Ramesh.
    ______________________________
    There is nothing Impossible.
    Even Impossible says
    I M POSSIBLE

  2. #2
    Join Date
    Feb 2001
    Posts
    389
    Have not worked on NT much, but i think this happens if you stop the instance from the command mode and services are still up and NT does not know that.you should stop and start using NT services.

  3. #3
    Join Date
    Sep 2000
    Posts
    47
    I'm not sure if 8.1.6 still uses it, but up through 8.0.6 when an instance is up there is a file in ORACLE_HOME/dbs called 'sgadefSID.dbf'. If the instance is down (i.e., no instance processes are running) but that file is there, svrmgrl thinks the instance is up. Either try a "startup force" (which I haven't ever done) or delete the file and try the normal "startup open". The bigger question is, if the sgadef file exists, why? I've only seen this situation after an unclean shutdown (like the sys admin killing the processes instead of doing an Oracle shutdown).

    Tim

  4. #4
    Join Date
    Apr 2000
    Location
    Edison, NJ
    Posts
    759
    Try:
    shutdown normal and then startup

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