Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> starting and stopping db instances
Hi,
I have a problem that I can't figure out how to do or even know if it is possible.
The problem is that I want to shutdown and startup an oracle instance everyone hour or so. Before, how we did it was to run a shell script on the server side to schedule a bunch of batch jobs. The shell script calls svrmgrl and connects internal to do shutdown and startup. Now I would like to do this from my NT client and do the same thing from a program I am writing.
Initially I tried to just use REXEC to connect to the server and execute the shell script, but since rexec does not start a shell connection, I can't get svrmgr to work correctly (many of its required initialization are not there?)
So I am wondering if there are other ways I can do this from my client VC++ program, I looked through OCI but didn't find anything there regarding to starting up and ending oracle instances either. Are there some tools or parts of OCI that I overlooked?
any help will be greatly appreciated
thanks
Chienli
Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't.
Received on Thu Jul 29 1999 - 13:08:04 CDT