Path: news.easynews.com!easynews!hub1.nntpserver.com!headwall.stanford.edu!newsfeed.stanford.edu!sn-xit-01!sn-post-01!supernews.com!corp.supernews.com!not-for-mail
From: "Van Messner" <vmessner@bestweb.net>
Newsgroups: comp.databases.oracle.server
Subject: Re: Unable to bounce Oracle Instance
Date: Sat, 2 Feb 2002 16:27:50 -0500
Organization: Posted via Supernews, http://www.supernews.com
Message-ID: <u5omoic184d641@corp.supernews.com>
References: <cf3fb7fd.0202011634.20d71e4b@posting.google.com> <3C5C3D47.8000609@home.com>
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.50.4522.1200
X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4522.1200
X-Complaints-To: newsabuse@supernews.com
Lines: 81
Xref: easynews comp.databases.oracle.server:133698
X-Received-Date: Sat, 02 Feb 2002 14:35:58 MST (news.easynews.com)

And if that doesn't work check Metalink for ORA-24327.  There are bugs in
some versions of 8i that can produce this error.

Van


"Mark Malakanov" <markmal_no_spam@home.com> wrote in message
news:3C5C3D47.8000609@home.com...
> do not use TNS specifier in "sqlplus username/password@instance"
> ensure REMOTE_LOGIN_PASSWORDFILE=EXCLUSIVE in INIT.ORA file
> DOS>set ORACLE_SID=<SID>
> DOS>cd %ORACLE_HOME%\dbs
> DOS>orapwd file=orapw<SID> password=<ORAPWPASSWD>
> DOS>sqlplus /nolog
> SQL>connect sys/<ORAPWPASSWD> as sysdba
> or
> SQL>connect internal/<ORAPWPASSWD>
> SQL>shutdown immediate
> ...
>
>
>
>
>
>
>
>
> Rob Walling wrote:
>
> > 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@instance, then
> >>
> > SQL> connect username/password@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!
> >
>
>