Re: Unable to bounce Oracle Instance

Uh oh, do I want to hear this?

I am using terminal services.

"Niall Litchfield" <n-litchfield_at_audit-commission.gov.uk> wrote in message news:<3c5e4ba7$0$8511$ed9e5944_at_reading.news.pipex.net>...
> Are you using Terminal services by any chance?
>
>
> --
> Niall Litchfield
> Oracle DBA
> Audit Commission UK
> *****************************************
> Please include version and platform
> and SQL where applicable
> It makes life easier and increases the
> likelihood of a good answer
>
> ******************************************
> "Rob Walling" <rwalling_at_hotmail.com> wrote in message
> news:cf3fb7fd.0202011634.20d71e4b_at_posting.google.com...
> > I'm using Oracle 8i on Windows 2000, and am unable to bounce an
> > instance of it using DBA Studio, svrmgrl (I know it's deprecated, but
> > tried anyways), or SQL*PLUS.
> >
> > *************
> > In DBA Studio I connect as SYSDBA and select "shutdown immediate"
> > under Instance->database and it spins for a second and then stops with
> > an exclamation point. Then it says it's in an unknown state and I have
> > to start it up again and it works fine. But it never actually shuts
> > down. I've also tried "shutdown abort," but that doesn't work either.
> >
> > *************
> > In svrmgrl I get an error: "ORA-12560: TNS:protocol adapter error"
> > when trying to connect. I do have ORACLE_SID = <correct SID> in the
> > system environment variables on the box.
> >
> > *************
> > Using SQL*PLUS I can connect using:
> >
> > >sqlplus username/password_at_instance, then
> > SQL> connect username/password_at_instance AS SYSDBA
> >
> > but then when I try to execute shutdown immediate it says:
> >
> > "ORA-00106: cannot startup/shutdown database when connected to a
> > dispatcher"
> >
> > But when I try to create an entry in tnsnames with (SERVER=DEDICATED),
> > I can't connect through SQL*PLUS at all (I get "ORA-12537:
> > TNS:connection closed").
> >
> > If instead I try:
> >
> > SQL>connect internal
> >
> > I get:
> >
> > "ORA-24327: need explicit attach before authenticating a user"
> >
> > **************
> > I have combed through the newsgroups and the Oracle docs and have
> > found nothing to help me. All I want to do is bounce the server so I
> > can put it into ARCHIVELOG mode.
> >
> > Any help is very much appreciated!
Received on Tue Feb 05 2002 - 13:16:36 CST