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

Thread: NT shutdown question

Hybrid View

  1. #1
    Join Date
    Aug 2000
    Location
    Chicago IL
    Posts
    586
    I have a script which shutdowns the NT Oracle database then the service on my server. I heard there is a way that if I shutdown the box it will execute the .cmd scripts and I wanted to have append my batch script to a shutdown procedure. I dont want the services to shutdown the database because this isnt succefull half the time. Any ideas?
    "High Salaries = Happiness = Project Success."

  2. #2
    Join Date
    Sep 2001
    Location
    NJ, USA
    Posts
    1,287
    Try:
    c:\> oradim -shutdown -sid ORA_SID -shuttype SRVC, INST -shutmode I

    (where ORA_SID --> ur SID name)
    SRVC --> shutdown services
    INST --> shutdown instance
    I --> "shutdown immediate"

  3. #3
    Join Date
    Aug 2000
    Location
    Chicago IL
    Posts
    586
    Shestakov
    thanks for the response. I was not looking for that response. I have a script that shutsdown the the instance and the service but I am looking for a way to execute that script thru NT shutdown procedures.

    any ideas?
    "High Salaries = Happiness = Project Success."

  4. #4
    Join Date
    Sep 2001
    Location
    NJ, USA
    Posts
    1,287
    1) start utility in run ... gpedit.msc

    2) choose : Computer configuration --> Windows setting --> Scripts

    3) In Scripts open: Shutdown

    4) type oracle shutdown command:
    oradim -shutdown -sid ORA_SID -shuttype SRVC, INST -shutmode I

    ----------------------------------------------
    NOTE: it possible ONLY for W2K (win 2000)

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