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 <[EMAIL PROTECTED]>
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
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@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: <[EMAIL PROTECTED]>
X-Comment: Oracle RDBMS Community Forum
X-Sender: john <[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: 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: [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).
_________________________________________________________________
Tired of spam? Get advanced junk mail protection with MSN 8. http://join.msn.com/?page=features/junkmail
--
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).