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

Thread: NT starup script

  1. #1
    Join Date
    Jun 2000
    Location
    Maputo, Maputo-Mozambique
    Posts
    96
    How can it be writen on NT if on Unix is
    UX:

    svrmgrl < connect internal
    shutdown immediate
    EOF

    NT?
    In god i trust

  2. #2
    Join Date
    Feb 2000
    Location
    Singapore
    Posts
    1,758
    Use ORADIM to set startmode=auto

    Sanjay

  3. #3
    Join Date
    Jan 2002
    Location
    Up s**t creek
    Posts
    1,525
    I have a basic .sql script which has the following

    shut.sql
    connect internal
    shutdown immediate
    exit

    and this is called from a batch command similar:

    set ORACLE_SID=DBNAME
    svrmgrl @shut.sql

    Regards
    Jim
    Oracle Certified Professional
    "Build your reputation by helping other people build theirs."

    "Sarcasm may be the lowest form of wit but its still funny"

    Click HERE to vist my website!

  4. #4
    Join Date
    Jun 2000
    Location
    Maputo, Maputo-Mozambique
    Posts
    96
    Thanks "JOVE" it's working

    Alexandre
    In god i trust

  5. #5
    Join Date
    Sep 2001
    Location
    NJ, USA
    Posts
    1,287
    Originally posted by jovery

    set ORACLE_SID=DBNAME
    svrmgrl @shut.sql
    If u have to use this method of startup/shutdown u have to start/stopt
    listener manualy too.

    little bit better using oradim utility for it:

    oradim -STARTUP -SID_name SID -USERPWD password -STARTTYPE SRV,INST
    oradim -SHUTDOWN -SID SID_name -USERPWD password -SHUTTYPE srv,inst -SHUTMODE -i

    Using -USERPWD password only if it need.

    in this case u can startup/shutdown instance and listener in same time as
    nt services.

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