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

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 startupand  shutdown tasks.

Bye,
Ralf Received on Thu Jun 08 2000 - 00:00:00 CDT