-
How can it be writen on NT if on Unix is
UX:
svrmgrl <
connect internal
shutdown immediate
EOF
NT?
In god i trust
-
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
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!
-
Thanks "JOVE" it's working
Alexandre
In god i trust
-
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|