Re: How to shutdown and re-start a database remotely?

No way???

Yes, way!

I easily stop AND start my databases while sitting at my desk. My PC is running NT Workstation and the databases are on NT Servers down the hall. At my desk I can start SVRMGR30. From there I log on as INTERNAL. Issue a SHUTDOWN IMMEDIATE or SHUTDOWN ABORT. Map a drive to the location on the server where the appropriate INIT<sid>.ORA file. Issue a STARTUP PFILE=<filespec of init file>. Works every time. Of course, I do have to have read/execute priviledge to the init file. Also beware that in specifying the pfile, use the file spec as it is known on the machine where you are doing the startup. In other words, if the file INITORCL.ORA is on the server \\ORASRV01 at d:\orant\database\initorcl.ora, and at my desktop I map x: to \\orasrv01\d:\orant, then I specify pfile=x:\database\initorcl.ora.

As for a remote startup not being as "clean", sounds like hogwash to me me.

In article <393f9d08.112953117_at_news.fth.sbs.de>,   goldensurfer_at_gmx.de (Ralf Zwanziger) wrote:
> On Tue, 6 Jun 2000 18:18:00 +0800, "Dino Hsu" <dino1_at_ms1.hinet.net>
> wrote:
>
> >My questions are:
> >1.How to shutdown and re-start a database remotely? (without logging
 in the
> >server) Server Manager, Instance Manager?
> No way. You can log on via SQLPLUS and shut down the database, but you
> won't be able to bring it up again afterwards.
>
> >2.What are the required privleges or roles? INTERNAL, SYS, SYSTEM,
 which of
> >them can do these shutdown/startup jobs? Do you think
 shutdown/startup need
> >very high privileges?
> AFAIK, internal is neither a role, nor a privilege, except the
> privilege of sitting at a system console :-)
> If you start SVRMGRL on the machine where the database is located, you
> can "connect internal" without a password.
>
> Other users that may shutdown the database are system and sys.
>
> >3.One Oracle DBA believes that any remote shutdown/startup are not
 'clean'
> >enough, the best way is to do them is on the server. Do you think so?
> Yes, but maybe it's a problem on NT. On Unix/Linux you can log into
> the machine by using telnet or rlogin and then, if you have the oracle
> password, you can start svrmgrl or sqlplus and perform the startup-
> and shutdown tasks.
>
> Bye,
> Ralf
>

--
Ed Stevens
(Opinions are not necessarily those of my employer)


Sent via Deja.com http://www.deja.com/
Before you buy.