Re: Unable to bounce Oracle Instance

From: Mark Malakanov <markmal_no_spam_at_home.com>
Date: Sat, 02 Feb 2002 19:23:59 GMT
Message-ID: <3C5C3D47.8000609@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 Sat Feb 02 2002 - 13:23:59 CST