Re: Remote shutdowns & startups via command line for 7.3.3 under NT

From: Michael Serbanescu <mserban_at_postoffice.worldnet.att.net>
Date: 1997/12/12
Message-ID: <66qmke$m3i@bgtnsc02.worldnet.att.net>#1/1

You would need to install at least Server Manager (line mode) and SQL*Net on the client machine(s). I am not sure if you can do the Server Manager installation using the Oracle Installer without installing the whole RDBMS kernel (since Server Manager is an Oracle7 Server utility). If you can figure out what (support) files you need in addition to svrmgrxx.exe, you could copy them directly from the CD onto the client machine(s).

If you have several database servers, you could use one of them as a "central command post" to shutdown the SIDs on the other servers.

Note that you can shutdown a remote instance, but you cannot start it unless you are able to access (from that central machine) the drive where the initsid.ora for the remote instance is located. And you have to specify the pfile parameter in your startup command as follows:

svrmgr> set instance 'service_name_for_remote_instance'
svrmgr> connect internal
svrmgr> startup ....pfile='full_path_name_for_remote_initsid.ora'

Hope this helps.

Michael Serbanescu

On Thu, 11 Dec 1997 10:06:50 -0700, "Adam Pearse" <apearse_at_computronix.com> wrote:

>Hi, is there a way to shutdown and startup oracle instances remotely without
>Enterprise Manager or Instance Manager? I would prefer a command line
>equilavent. Our developers need to bring up and down several SIDs and I
>would prefer not having to install 70 MB of Oracle product just to be able
>to start and stop SIDs. Any comments or suggestions would be great.
>
>
Received on Fri Dec 12 1997 - 00:00:00 CST