Oracel Startup
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: Oracel Startup

  1. #1
    Join Date
    Feb 2001
    Posts
    10

    Red face

    Hi..

    We are Starting and Stopping Oracle Database through the Win NT Services.

    I want to know what type of Paramater is defined in the Service while Stopping the Oracle whether it is Shutdown Immediate or Shutdown Normal or Abort.


    Thanks in Advance

    Sandeep...

  2. #2
    Join Date
    Aug 2000
    Location
    Toronto, Ontario Canada
    Posts
    52
    Depends on what is set in the registry.
    Check the value of this registry key.
    ORA_<SID>_SHUTDOWNTYPE
    If it equals i, then its immediately. I believe 8.1.5 defaulted to abort.

  3. #3
    Join Date
    Feb 2001
    Posts
    10

    Lightbulb

    Hi..

    I have checked the registry, there was parameter set as "i" but there is one more thing with shutdown as "30"

    What does this mean..

    Thanks for your information...

    Sandeep..

  4. #4
    Join Date
    Feb 2001
    Location
    Paris, France
    Posts
    809
    it means that NT will wait 30 seconds for the service to stop normally, and if it is still alive after 30 seconds, il will be killed ...

  5. #5
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    When you use any of the automatic script, either in unix or in windows, oracle would perform a shutdown abort. If you do not want this to be an abort operation, then you have to alter them to suit your requirement.

    Sam
    Thanx
    Sam



    Life is a journey, not a destination!


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