Unable to bounce Oracle Instance

From: Rob Walling <rwalling_at_hotmail.com>
Date: 1 Feb 2002 16:34:36 -0800
Message-ID: <cf3fb7fd.0202011634.20d71e4b@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 Fri Feb 01 2002 - 18:34:36 CST