From: "Dino Hsu" <dino1@ms1.hinet.net>
Subject: How to shutdown and re-start a database remotely?
Date: 2000/06/06
Message-ID: <8ho20c$3d0@netnews.hinet.net>#1/1
Organization: Avon Cosmetics Taiwan
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2615.200
Newsgroups: comp.databases.oracle.server


To All,

Under some abnormal situations, we may want to shutdown a database
(instance) and re-start it again. But because I am  not the network
administrator, I cannot log in the Windows NT servers where Oracle 8.0.5
databases reside. In other words, if I do them by stopping and re-starting
database-related (SID) services, I have to work with the network
administrator.

My questions are:
1.How to shutdown and re-start a database remotely? (without logging in the
server) Server Manager, Instance Manager?
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?
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?

Thanks in advance. If convenient, please also reply to my mail box:
dino1@ms1.hinet.net.

Dino
ITS, Avon Cosmetics Taiwan