From: mserban@postoffice.worldnet.att.net (Michael Serbanescu)
Subject: Re: Remote shutdowns & startups via command line for 7.3.3 under NT
Date: 1997/12/12
Message-ID: <66qmke$m3i@bgtnsc02.worldnet.att.net>#1/1
References: <66p6jc$s35$1@client2.news.psi.net>
Organization: worldnet.att.net
Reply-To: mserban@worldnet.att.net
Newsgroups: comp.databases.oracle.server



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@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.
>
>