How can it be writen on NT if on Unix is
UX:
svrmgrl <connect internal
shutdown immediate
EOF
NT?
Printable View
How can it be writen on NT if on Unix is
UX:
svrmgrl <connect internal
shutdown immediate
EOF
NT?
Use ORADIM to set startmode=auto
Sanjay
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
Thanks "JOVE" it's working
Alexandre
If u have to use this method of startup/shutdown u have to start/stoptQuote:
Originally posted by jovery
set ORACLE_SID=DBNAME
svrmgrl @shut.sql
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.