database shutdown
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 7 of 7

Thread: database shutdown

  1. #1
    Join Date
    Sep 2000
    Posts
    305
    Hi folks

    I am facing one problem. when I try to shutdown oracle server it takes a very long time to shutdown and sometimes it stuck in the mid part. What could be the problem?

    please give me your suggestions.

    Shailendra

  2. #2
    Join Date
    Oct 2000
    Posts
    250
    What option u choose to shutdown the database?
    Check what is the error message in the Alert.log file

  3. #3
    Join Date
    Mar 2001
    Posts
    635
    Hi

    Check ur Alert log file for any error messages

    or

    Check for active connections from V$session becuase if you are performing Normal shutdown oracle waits for all users to logoff.

    What is ur OS and Oracle version?

    Regards,
    Santosh

  4. #4
    Join Date
    Sep 2000
    Posts
    305
    I had given shutdown immediate

    and the content of alert.log file is

    SHUTDOWN: waiting for detached processes to terminate.

    It was hanged so I restart the service and then again open the serive manager shutdown the database abort


    Shailendra


  5. #5
    Join Date
    Mar 2001
    Posts
    635
    Hi,

    What OS and Oracle version are you using?

    Is this happening recently or has been happening since you installed the Oracle software and database?

    Did you make any changes recently to the oracle software like patches or any change in initialization parameters?

    There are many issues related especially with Windows OS

    Regards,
    Santosh


  6. #6
    Join Date
    Sep 2000
    Posts
    305
    I am using oracle 8.1.7 and the OS is WIN2K.

    it is happening since I installed Oracle.

    Thanks
    Shailendra

  7. #7
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447

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