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