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

Thread: Help!! How can I ensure shutdown is done properly?

  1. #1
    Join Date
    Mar 2001
    Posts
    24

    Smile

    Hi,

    How can I ensure oracle is shut down in the automatic scripts?

    I'm trying to create an automatic backup scripts performing in every midnight. But I have an experience that I tried to issue the command shutdown immediate manually but the system hangs up. I wonder how can I ensure the command shutdown immediate is done properly and the following backup script are performed ??

    I'm using Oracle 8.1.5 in Window NT4. The automatic scripts are written in dos command file to perform the physical operating system backup.

    Any suggestion please?

    Thanks,
    nngk

  2. #2
    Join Date
    Feb 2001
    Location
    Paris, France
    Posts
    809
    you can know if the service is running if the following command gives you something :
    net start | find "OracleService[SID]"

  3. #3
    Join Date
    Mar 2001
    Posts
    24
    Oh pipo,

    how can I make it work in the AUTOMATIC scripts?


  4. #4
    Join Date
    Feb 2001
    Location
    Paris, France
    Posts
    809
    net start | find "OracleServiceTEST" > nul
    if not errorlevel 1 goto OK
    echo DB TEST is stopped
    goto NEXT
    :OK
    echo DB TEST is started
    :NEXT

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