safe mode workaround

From: Norman Dunbar <Norman.Dunbar_at_lfs.co.uk>
Date: Thu, 3 Apr 2003 17:54:27 +0100
Message-ID: <E2F6A70FE45242488C865C3BC1245DA703826172@lnewton.leeds.lfs.co.uk>

Hi Tim,

was there anything in the alertlog for the instance to show what may have gone wrong ? This can usually be found in a location as specified by the init.ora parameter BACKGROUND_DUMP_DEST. On my 9i PC this is located in '%ORACLE_HOME\admin\ORCL92\bdump' where %ORACLE_HOME% is where oracle is installed and ORCL92 is the name of the instance. The file is called 'alert_orcl92.log'

If it hasn't been overwritten then there might be some useful information in there from sometime BEFORE the first 'safe start' you had to do.

I'm also not too sure what you mean when you say 'safe mode' because STARTUP NOMOUNT will start the instance only - none of the databse files are opened and in fact the controlfile isn't even open at this stage - so how can your C++ application be connecting to the database at this point ?

Hope this might give you a clue where to start looking :o)

Cheers,
Norman.

Norman Dunbar
Database/Unix administrator
Lynx Financial Systems Ltd.
mailto:Norman.Dunbar_at_LFS.co.uk

Tel: 0113 289 6265
Fax: 0113 289 3146
URL: http://www.Lynx-FS.com
-------------------------------------

-----Original Message-----
From: timbedford_at_hotmail.com (Tim Bedford) [mailto:timbedford_at_hotmail.com]
Posted At: Thursday, April 03, 2003 5:36 PM Posted To: server
Conversation: safe mode workaround
Subject: safe mode workaround

Hi,
We're using Oracle 8.1.7.0.0 Personal Edition in a PC controlled piece of equipment.

<SNIP>

The facts appear to be; the PC was rebooted but the database somehow failed to start up properly (the symptom being that the C++ application couldn't connect to it). Someone then did a safe mode start (START NOMOUNT etc) which seemed to do the trick. But this safe mode start, apparently, has to be done everytime the system is restarted.

<SNIP>
Received on Thu Apr 03 2003 - 10:54:27 CST