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
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.
There is nothing Impossible.
Even Impossible says
I M POSSIBLE
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).