Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: instance shutdown problem ? (please help)

Re: instance shutdown problem ? (please help)

From: Arup Nanda <arupnanda_at_hotmail.com>
Date: Sun, 24 Nov 2002 18:38:36 -0800
Message-ID: <F001.0050A615.20021124183836@fatcity.com>


Yes, the poster clarified that it was a missing controlfile. I have a reply that catered to the missing controlfile issue.

>From: Jeremiah Wilton <jwilton_at_speakeasy.net>
>Reply-To: ORACLE-L_at_fatcity.com
>To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
>Subject: Re: instance shutdown problem ? (please help)
>Date: Sun, 24 Nov 2002 15:23:35 -0800
>MIME-Version: 1.0
>Received: from newsfeed.cts.com ([209.68.248.164]) by
>mc6-f42.law1.hotmail.com with Microsoft SMTPSVC(5.0.2195.5600); Sun, 24 Nov
>2002 16:13:22 -0800
>Received: from fatcity.UUCP (uucp_at_localhost)by newsfeed.cts.com
>(8.9.3/8.9.3) with UUCP id QAA10715;Sun, 24 Nov 2002 16:06:45 -0800 (PST)
>Received: by fatcity.com (26-Feb-2001/v1.0g-b72/bab) via UUCP id 0050A562;
>Sun, 24 Nov 2002 15:23:35 -0800
>Message-ID: <F001.0050A562.20021124152335_at_fatcity.com>
>X-Comment: Oracle RDBMS Community Forum
>X-Sender: Jeremiah Wilton <jwilton_at_speakeasy.net>
>Sender: root_at_fatcity.com
>Errors-To: ML-ERRORS_at_fatcity.com
>Organization: Fat City Network Services, San Diego, California
>X-ListServer: v1.0g, build 72; ListGuru (c) 1996-2001 Bruce A. Bergman
>Precedence: bulk
>Return-Path: root_at_fatcity.cts.com
>X-OriginalArrivalTime: 25 Nov 2002 00:13:22.0422 (UTC)
>FILETIME=[772A6160:01C29417]
>
>Hmm, I think the error is right there in a snippet fo the alert log in
>the poster's original message. ORA-205 "Error in identifying
>controlfile."
>
>The database will not start because Oracle cannot find or access one
>or more of the controlfiles.
>
>Are all the postings today about controlfiles?
>
>--
>Jeremiah Wilton
>http://www.speakeasy.net/~jwilton
>
>On Sat, 23 Nov 2002, Arup Nanda wrote:
>
> > Well, system does not do a shutdown abort. Oracle finds a problem and
>then
> > instance aborts.
> >
> > A few things you can do here.
> >
> > (1) See if a trace file is generated around that time in user_dump_dest
>or
> > background_dump_dest that might provide clues. If you see a core fiel in
>any
> > directory named core_* in the core_dump_dest, it has cored dumped.
> >
> > (2) Start the database from command line. From NT services panel, make
>the
> > services OracleServiceXXX manual, from automatic. Then reboot the box.
>Start
> > the service manually and then see what happens in the process.
> >
> > (3) Start the instance and service in a command prompt window using
>oradim
> > comamnd. I am not sure of the options; but the oradim command gives a
>help.
> >
> > At some point you would hit a problem that is decipherable. Please let
>us
> > know what came out of it.
> >
> > >From: john <john_g123_9_at_yahoo.com>
> > >
> > >ver 8i NT4.o
> > >all services have been set to automatic and start fine
> > >
> > >however the NT Event Viwer and the oracle "alert.log"
> > >show that the instance being shutdown just after the
> > >box boots up.
> > >
> > >how do we rectify this problem ?
> > >
> > >below is from the alert.log
> > >
> > >ORA-205 signalled during: alter database mount exclusive..
> > >Shutting down instance (abort)
> > >License high water mark = 5
> > >Instance terminated by USER, pid = 144
> > >---------------------------------------------------
> > >please note: the shutdwon was not initiated by any admin
> > >or user but done by the system itself after the box boots
> > >up.
>
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: Jeremiah Wilton
> INET: jwilton_at_speakeasy.net
>
>Fat City Network Services -- 858-538-5051 http://www.fatcity.com
>San Diego, California -- Mailing list and web hosting services
>---------------------------------------------------------------------
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(or the name of mailing list you want to be removed from). You may
>also send the HELP command for other information (like subscribing).



MSN 8 with e-mail virus protection service: 2 months FREE* http://join.msn.com/?page=features/virus
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Arup Nanda
  INET: arupnanda_at_hotmail.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
Received on Sun Nov 24 2002 - 20:38:36 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US