How to Autometically Shutdown the Database on NT 4 - Page 2
DBAsupport.com Forums - Powered by vBulletin
Page 2 of 2 FirstFirst 12
Results 11 to 15 of 15

Thread: How to Autometically Shutdown the Database on NT 4

  1. #11
    Join Date
    Nov 2002
    Location
    New Delhi, INDIA
    Posts
    1,796
    PUT
    -----------------------------------------------------
    o ORA_SID_SHUTDOWN=true (this means it will go down when the system is going down normally.)

    o ORA_SID_SHUTDOWN_TIMEOUT=30 (in secs. This is the time for which the system will wait for the OracleService to go down. After that its Shutdown abort.)

    o ORA_SID_SHUTDOWNTYPE=i (for immediate) a(for abort)
    ---------------------------------------------------------
    in regedit HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\HOME0

    These are the default values. You can change them according to your needs...

    where SID=SID of your database.
    Amar
    "There is a difference between knowing the path and walking the path."

    Amar's Blog  Get Firefox!

  2. #12
    Join Date
    Jun 2003
    Location
    India
    Posts
    118
    Having same settings as told i.e.

    ORA_SID_SHUTDOWN=true

    ORA_SID_SHUTDOWN_TIMEOUT=30

    ORA_SID_SHUTDOWNTYPE=i

    Even then the database is not shuttingdown when I shut down the server.

    Kindly note when shutdown the server I don't want to go to Control Panel-Service to stop the Oracle Service. I am looking for the method when I Shutdown the server the database will autometically shuts down.
    vishal sood
    OCP 8

  3. #13
    Join Date
    Nov 2002
    Location
    New Delhi, INDIA
    Posts
    1,796
    Originally posted by vishal sood
    Even then the database is not shuttingdown when I shut down the server.
    Look in the alert log file for the following lines.

    Shutting down instance: further logons disabled
    Shutting down instance (immediate)

    Or may be you can show the alert logfile output of last 30 lines or so...
    Amar
    "There is a difference between knowing the path and walking the path."

    Amar's Blog  Get Firefox!

  4. #14
    Join Date
    Nov 2002
    Location
    Geneva Switzerland
    Posts
    3,142
    I would allow much more than 30 seconds for the shutdown. It's a question of how often you might have a big transaction to rollback . . . 5 minutes may not be excessive . . . it depends . . .

  5. #15
    Join Date
    Sep 2001
    Location
    Ohio
    Posts
    334
    Look in your oradim.log.

    If you are getting ORA-12638: Credential retrieval failed errors, it could be a problem with NTS. Oracle recommends setting sqlnet.authentication_services = (NONE) or (BEQ,NONE) if you want to keep using "/as sysdba".

    It appears that if NTS isn't working properly, you can have this problem.

    Good Luck!
    Jodie

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