Re: safe mode workaround

Hi Norman,

I have received this information about it:

"There is no Oracle error on startup, and no alert that something is wrong. From the command line the database starts fine. It's when the computer reboots and the service starts that the database fails to start."

By the way its running on NT 4.0.
thanks,

Tim

Norman Dunbar <Norman.Dunbar_at_lfs.co.uk> wrote in message news:<E2F6A70FE45242488C865C3BC1245DA703826172_at_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 Fri Apr 04 2003 - 02:29:10 CST