Re: Shutting down Oracle from a Client

You will also need a local copy (i.e. on the client) of the init.ora (and config.ora if using one)

regards

NeilC

Eugene Firyago wrote:
>
> 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 - 09:51:44 CST