Path: news.easynews.com!easynews!hub1.nntpserver.com!news-out.spamkiller.net!propagator-la!news-in-la.newsfeeds.com!newshub2.rdc1.sfba.home.com!news.home.com!news3.rdc1.on.home.com.POSTED!not-for-mail
Message-ID: <3C5C3D47.8000609@home.com>
From: Mark Malakanov <markmal_no_spam@home.com>
User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:0.9.7) Gecko/20011221
X-Accept-Language: en-us, ru
MIME-Version: 1.0
Newsgroups: comp.databases.oracle.server
Subject: Re: Unable to bounce Oracle Instance
References: <cf3fb7fd.0202011634.20d71e4b@posting.google.com>
Content-Type: text/plain; charset=us-ascii; format=flowed
Content-Transfer-Encoding: 7bit
Lines: 71
Date: Sat, 02 Feb 2002 19:23:59 GMT
NNTP-Posting-Host: 24.114.170.181
X-Complaints-To: abuse@home.net
X-Trace: news3.rdc1.on.home.com 1012677839 24.114.170.181 (Sat, 02 Feb 2002 11:23:59 PST)
NNTP-Posting-Date: Sat, 02 Feb 2002 11:23:59 PST
Organization: Excite@Home - The Leader in Broadband http://home.com/faster
Xref: easynews comp.databases.oracle.server:133688
X-Received-Date: Sat, 02 Feb 2002 12:24:02 MST (news.easynews.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!
>