Re: Shutting down Oracle from a Client

On a server :

From a shell as oracle's owner:

$ cd $ORACLE_HOME/dbs
$ orapwd file=orapw<SID> password=<password> entries=<n>

From svrmgrl as sys or internal (before that make shure that the database started with remote_login_passwordfile = exclusive in the init<SID>.ora):

SVRMGR> create user <user_name> ...;
SVRMGR> grant sysdba to <user_name>;

From a client's server manager:

SVRMGR> connect <user_name>/<password>@<remote_db_connect_string> as sysdba; SVRMGR> shutdown ... startup...whatever_you _want_as_sys.

Good luck,
Eugene.

Mark Wagner <mwagner_at_speedchoice.com> wrote in message news:s5eejncbqrs27_at_corp.supernews.com...
> I am running 8.0.5.1 under linux.
>
> 1. Can you shut down oracle from a client? (I can't imagine that you
> wouldn't be able to)
> 2. Can I run svrmgrl and specify a connection (connect
> username/password_at_server_in_tnsnames.ora) and issue a shutdown command?
> 3. What users have the privledges to startup and shutdown a database?
> 4. Where are those users defined? (OS level or DB level or
Passwordfile?)
>
> Thanks
>
> Mark
>
>
>
Received on Wed Dec 15 1999 - 08:24:54 CST