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

Thread: Schedule Startup and Shutdown Oracle816 on Winodws NT Using AT Command Doesn't Work

  1. #1
    Join Date
    Mar 2002
    Posts
    13
    Hi Guys,
    I am trying to use Windows NT's AT command to schedule the database shutdown and startup process. But it doesn't work. The following are part of my scripts:

    (1) shutdown.sql
    connect internal
    shutdown immediate
    exit

    (2) shutdown.cmd
    e:\oracle\ora81\bin\svrmgrl.exe @shutdown.sql

    (3) AT command
    at 23:00 / every:M,T,W,Th,F,S,Su shutdown.cmd

    When I execute shutdown.cmd on DOS prompt, it works. But when the command is scheduled using AT command, it never works.

    I will appreciate if any one can help me.

  2. #2
    Join Date
    Sep 2001
    Location
    NJ, USA
    Posts
    1,287
    Why need so long procedure for startup/shutdownd db on nt.

    Much easy use oradim utility for start/stop oracle services
    (listener and instance).

    http://download-east.oracle.com/otnd...h2.htm#1181056

  3. #3
    Join Date
    Mar 2002
    Posts
    13
    Shestakov,

    Thanks for your answer. I will try the oradim utility.
    But I still want to know the reason why AT command can not work.



  4. #4
    Join Date
    Apr 2001
    Location
    Czechia
    Posts
    712
    * Write absolute paths to commands, e.g.:

    (2) shutdown.cmd
    e:\oracle\ora81\bin\svrmgrl.exe @e:\scripts\shutdown.sql

    (3) AT command
    at 23:00 / every:M,T,W,Th,F,S,Su e:\scripts\shutdown.cmd


    * If it still doesn't work send output to a log file and check it:

    (3) AT command
    at 23:00 / every:M,T,W,Th,F,S,Su e:\scripts\shutdown.cmd > e:\scripts\log.txt


    * Try to set ORACLE_SID:

    (2) shutdown.cmd
    set ORACLE_SID=orcl
    e:\oracle\ora81\bin\svrmgrl.exe @e:\scripts\shutdown.sql
    Ales
    The whole difference between a little boy and an adult man is the price of toys

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