NT starup script

[alexandre]

How can it be writen on NT if on Unix is
UX:

svrmgrl < connect internal
shutdown immediate
EOF

NT?

[SANJAY_G]

Use ORADIM to set startmode=auto

Sanjay

[jovery]

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

[alexandre]

Thanks "JOVE" it's working

Alexandre

[Shestakov]

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.