From: Jeremiah Wilton <[EMAIL PROTECTED]>
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
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@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: <[EMAIL PROTECTED]>
X-Comment: Oracle RDBMS Community Forum
X-Sender: Jeremiah Wilton <[EMAIL PROTECTED]>
Sender: [EMAIL PROTECTED]
Errors-To: [EMAIL PROTECTED]
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: [EMAIL PROTECTED]
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 <[EMAIL PROTECTED]>
> >
> >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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
