Shutdown - Process takes too much time!!! Please help
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: Shutdown - Process takes too much time!!! Please help

  1. #1
    Join Date
    Apr 2001
    Posts
    2

    Question

    Hello,

    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?

    Thanks

  2. #2
    Join Date
    Feb 2001
    Location
    Paris, France
    Posts
    809
    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 ...

  3. #3
    Join Date
    Jan 2001
    Posts
    2,828
    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

    svrmgr>startup force

    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....

    regards
    hrishy

  4. #4
    Join Date
    Mar 2000
    Location
    Chennai.Tamilnadu.India.
    Posts
    658

    Shutdown -Solution

    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.

    cheers

    Padmam
    Attitude:Attack every problem with enthusiasam ...as if your survival depends upon it

  5. #5
    Join Date
    Feb 2001
    Posts
    49
    hi,

    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.

    HTH
    I love dba job

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