Re: Shutting down Oracle from a Client

That is only in case you need to start the database up remotely (form a client).
Also you can store the init parameters locally in NT/95/98 registry using OEM's Instance Manager.

Eugene.

NeilC <neilc-olops_at_btinternet.com> wrote in message news:3857B910.BA81DD9D_at_btinternet.com...
> 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 Thu Dec 16 1999 - 12:02:02 CST