db shutdown ? - Page 3
DBAsupport.com Forums - Powered by vBulletin
Page 3 of 3 FirstFirst 123
Results 21 to 24 of 24

Thread: db shutdown ?

  1. #21
    Join Date
    Nov 2001
    Posts
    11
    Why not try out all this commands manually first, instead of in script ?
    My guess of your problems here:
    1. when you Shutdown abort, you may not able to startup in restrict mode. So the database startup, but in normal.
    2. because the startup restrice command get an error in getting restric privilege, the connection is dropped.
    3. so your third shutdown command failed because you are disconnected.
    4. your shutdown command failed, so... all the processes are alive there. The database actually is either startup normal or mounted, or even nomount. Anyway it's running!

    Hope you could check and let us know the result.

  2. #22
    Join Date
    Nov 2001
    Posts
    11
    Really should avoid using shutdown abort!
    Learning something new everyday
    Forgetting something useful every minute!

  3. #23
    Join Date
    Nov 2001
    Posts
    11

    Smile

    In addition to avoiding the shutdown abort, try issuing an alter system checkpoint prior to issuing the shutdown IMMEDIATE. Also might consider issuing a switch of the logfile prior to shutdown as well.
    Learning something new everyday
    Forgetting something useful every minute!

  4. #24
    Join Date
    Jun 2001
    Location
    Helsinki. Finland
    Posts
    3,938
    Originally posted by philmer
    Really should avoid using shutdown abort!
    Yes, but often you simply have to use it...


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