I am working with Database Oracle. I wish to do a shutdown to database oracle with a script.
On Unix the script run, but when I try to run it on DOS, the script not run.
svrmgrl << EOF --> << was unexpected at this time
connect internal;
shutdown immediate;
EOF
So, I want to know, how can I run this script (or something like that) on NT???
If I need change something, please tell me, I need any help
I guess yours would look like
connect internal
shutdown immediate
Then from the DOS command line or from within a batch file, use the following line:
sqlplus /nolog @shutdown.sql
--
That's it. Keep in mind you need to make sure sqlplus is in your path (it's located in ORACLEHOME\bin). Also, if your shutdown.sql file is located in a specific location, put in the entire path (using quotes for good measure) as in the example below:
sqlplus /nolog @"c:\sql directory\shutdown.sql"
--
mrdtn