Unable to bounce Oracle Instance

Rob Walling

unread,

Feb 1, 2002, 7:34:36 PM2/1/02

to

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!

Mark Malakanov

unread,

Feb 2, 2002, 2:23:59 PM2/2/02

to

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
...

Van Messner

unread,

Feb 2, 2002, 4:27:50 PM2/2/02

to

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...@home.com> wrote in message
news:3C5C3D47...@home.com...

Niall Litchfield

unread,

Feb 4, 2002, 3:51:47 AM2/4/02

to

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" <rwal...@hotmail.com> wrote in message
news:cf3fb7fd.02020...@posting.google.com...

Rob Walling

unread,

Feb 4, 2002, 2:02:28 PM2/4/02

to

Thanks for the reply. I did exactly as stated (I had to shut down the
instance service in Windows to gain access to the PWD file), and got
these errors when trying to connect:

SQL> connect sys/grapes2wine as sysdba
ERROR: ORA-12560: TNS:protocol adapter error

SQL> connect internal/grapes2wine
ERROR: ORA-01017: invalid username/password; logon denied

Mark Malakanov <markmal...@home.com> wrote in message news:<3C5C3D47...@home.com>...

Rob Walling

unread,

Feb 4, 2002, 2:04:25 PM2/4/02

to

I am actully working without a paid support package, so don't have
access to Metalink. Is there a fix given?

"Van Messner" <vmes...@bestweb.net> wrote in message news:<u5omoic...@corp.supernews.com>...

Rob Walling

unread,

Feb 5, 2002, 2:16:36 PM2/5/02

to

Uh oh, do I want to hear this?

I am using terminal services.

"Niall Litchfield" <n-litc...@audit-commission.gov.uk> wrote in message news:<3c5e4ba7$0$8511$ed9e...@reading.news.pipex.net>...