List Info

Thread: DOS BATCH SCRIPT TO SHUTDOWN AND START ORACLE FOR WINDOWS




DOS BATCH SCRIPT TO SHUTDOWN AND START ORACLE FOR WINDOWS
country flaguser name
United States
2007-02-22 14:24:47

I am in the process of moving my Oracle database from Tru64 Unix to Windows Server 2000. I will be backing up the database using Veritas software. The software will not backup the database unless it is shutdown. I have created scripts in UNIX to do this but I can not seem to get a script to work from DOS.

If anyone has created a batch script to run as a scheduled job in Windows I would appreciate any assistance on this.

 

Dennis Arrigan

arriganberkeley.edu

 

Re: DOS BATCH SCRIPT TO SHUTDOWN AND START ORACLE FOR WINDOWS
country flaguser name
United States
2007-02-22 14:41:29
Running a Windows command file as a scheduled job is easy
enough - 
Start -> Settings -> Control Panel -> Scheduled
jobs, and fill in the 
blanks. Apart from making sure the job runs as an account
with the 
right rights for the task, that is easy enough.

Provided you can write a command script to shutdown Oracle
(which is 
what I presume you want to do) that runs in a console window
it should 
run on a schedule. If you want the Veritas software to
shutdown 
Oracle, then it ought to be possible, though just setting a
common 
schedule should work.

Since I am not an Oracle user, I would need a lot more
specifics to 
advise on a suitable script.

Graham

--
Graham Patterson, System Administration
Dept. of Economics, UC Berkeley (510)643-5397


------------------------------------------------------------
------------
The following was automatically added to this message by the
list server:

For information about Micronet, including subscribing to
or unsubscribing from its mailing list and finding out
about upcoming meetings, please visit the Micronet Web
site:
<http://micronet.be
rkeley.edu/>.

[1-2]

about | contact  Other archives ( Real Estate discussion Medical topics )