Re: Server Manager question

"Ralph" <rlro99_at_hotmail.com> wrote in message news:e2c49cae.0303200941.5312986e_at_posting.google.com...
> Billy Verreynne <vslabs_at_onwe.co.za> wrote in message
news:<b5bkpj$am6$2_at_ctb-nnrp2.saix.net>...
> > Telemachus wrote:
> >
> > > Well what about redefining SVRMGRL in your scripts as SQLPLUS with
the
> > > appropriate syntax ?
> >
> > Or writing a shell script called svrmgrl as a wrapper to call SQL*Plus?
>
> Hi
>
> I can see one problem with the end of svrmgrl. Reacently a couple of
> our 8.1.7.3 instances have been killed by our ever imaginative
> developers. Havn't yet worked out why/how... Either way, I have been
> getting into the habit of not using svrmgrl, but when an instance gets
> into this state sqlplus will not let you connect to the instance to
> shutdown abort. The only way to abort the instance was to use old
> school svrmgrl. Anybody else come across this? Maybe Oracle 9i wont
> get itself into this sort of state...;)
>
>
> Laters
>
> Ralph

First, sqlplus *does* let you connect to a stuffed instance, provided you attempt the connection as a privileged user (ie, connect ... as sysdba). In 8.1.6 I recall occasions when that little bit of (rather core!) functionality didn't work reliably, but as far as I can tell the problem was fixed completely by 8.1.7.

Secondly, if you are truly desperate to use svrmgrl, then you can use the 8i version of said program to connect to 9i instances. It's totally unsupported to do so, and I haven't done it with 9iR2, but it worked in 9iR1.

Regards
HJR Received on Thu Mar 20 2003 - 12:47:49 CST