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

YES .... you definitely can and risk absolutely nothing my production server does not even reside in the same state that I work from

I am able to start /stop/export/import etc from my nt and unix servers remotely from
my own home

Ed Stevens wrote:

> 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.
Received on Thu Jun 08 2000 - 00:00:00 CDT