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

Thread: Oracel Startup

  1. 02-24-2001, 09:52 AM #1
    log_ora
    log_ora is offline Junior Member
    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...
    Reply With Quote Reply With Quote
  2. 02-24-2001, 10:49 AM #2
    steviep9
    steviep9 is offline Junior Member
    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.
    Reply With Quote Reply With Quote
  3. 02-26-2001, 11:24 AM #3
    log_ora
    log_ora is offline Junior Member
    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..
    Reply With Quote Reply With Quote
  4. 02-26-2001, 11:32 AM #4
    pipo
    pipo is offline Senior Advisor
    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 ...
    Reply With Quote Reply With Quote
  5. 02-26-2001, 11:42 AM #5
    sambavan
    sambavan is offline Senior Advisor
    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!

    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules

Click Here to Expand Forum to Full Width