| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re: instance shutdown problem ? (please help)
John,
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.
HTH
Arup Nanda
www.proligence.com
>From: john <john_g123_9_at_yahoo.com>
>Reply-To: ORACLE-L_at_fatcity.com
>To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
>Subject: instance shutdown problem ? (please help)
>Date: Sat, 23 Nov 2002 15:23:37 -0800
>MIME-Version: 1.0
>Received: from newsfeed.cts.com ([209.68.248.164]) by
>mc7-f16.law1.hotmail.com with Microsoft SMTPSVC(5.0.2195.5600); Sat, 23 Nov
>2002 16:09:45 -0800
>Received: from fatcity.UUCP (uucp_at_localhost)by newsfeed.cts.com
>(8.9.3/8.9.3) with UUCP id QAA21336;Sat, 23 Nov 2002 16:08:01 -0800 (PST)
>Received: by fatcity.com (26-Feb-2001/v1.0g-b72/bab) via UUCP id 0050A280;
>Sat, 23 Nov 2002 15:23:37 -0800
>Message-ID: <F001.0050A280.20021123152337_at_fatcity.com>
>X-Comment: Oracle RDBMS Community Forum
>X-Sender: john <john_g123_9_at_yahoo.com>
>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: 24 Nov 2002 00:09:45.0779 (UTC)
>FILETIME=[CB9F8830:01C2934D]
>
>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.
>
>__________________________________________________
>Do you Yahoo!?
>Yahoo! Mail Plus – Powerful. Affordable. Sign up now.
>http://mailplus.yahoo.com
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: john
> INET: john_g123_9_at_yahoo.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).
-- 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 - 00:18:39 CST
 |
 |