i've got Oracle 8.0.6 on a NT-Server.
Ok, i wanted to shutdown the DB-Server!
Unfortunately i only wrote "shutdown" and forgot to write also the parameter "abort" or "immediate".
Now, the Shutdown-Process is already running 2 Days.
Can somebody tell me how kill this process and how to startup the db?
try this : go under server manager and issue a shutdown immediate statement
else, go under the task manager, in the processes, find oracle.exe and kill it ...
hi i had faced a similar problem a few days ago and sure thsi beats me why it happened you can do the following..................
open one more svrmgr windoww go to svrmgr connect as internal
and then shutdown once gain it will shutdown
if you just try to do shutdown immediate oracle will say already shutting down it wont work....
Hi, 20th April 2001 17:38 hrs chennai
I also faced the same situation once.
But i was perfectly succesful with closing the session and started and used
1)First close your existing shutdown Session
2)Issue startup force (other wise "ORA-01034 oracle not available" error will be returned)
SQLPLUS or SVRMGRL >shutdown immediate;(for this the user has to have sysdba privs)
the reasons can also be like this
1)May be unknowingly your knowlege some sessions are still connected.
2)Check from v$session to kill those sessions or give shutdown immediate .
After succesfully given the startup force and issue shutdown immediate you want get the error oracle already available.
Attitude:Attack every problem with enthusiasam ...as if your survival depends upon it
When users are connected , the SHUTDOWN command waits for the users to quit the session. So First view the V$SESSION to see wheter the users are connected.
If you don't want to wait until users disconnect, then issue
SHUTDOWN IMMEDIATE command but see that uncommited transactions will be rolled back.
SHUTDOWN ABORT will enable crash recovery next time, when instance starts and it is automatically done by SMON.
I love dba job
Click Here to Expand Forum to Full Width