I am actully working without a paid support package, so don't have
access to Metalink. Is there a fix given?
"Van Messner" <vmessner_at_bestweb.net> wrote in message news:<u5omoic184d641_at_corp.supernews.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_at_home.com> wrote in message
> news:3C5C3D47.8000609_at_home.com...
> > do not use TNS specifier in "sqlplus username/password_at_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_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 Mon Feb 04 2002 - 13:04:25 CST
