Re: Database won't start Automatic, balks at datafile mount

From: Frank van Bortel <fvanbortel_at_netscape.net>
Date: Wed, 21 Jul 2004 11:40:13 +0200
Message-ID: <cdldb8$fdd$1@news1.tilbu1.nb.home.nl>

Purity Control wrote:

> Sybrand Bakker <sybrandb_at_hccnet.nl> wrote in message news:<kkeof0tpapo1596j6jur6m1p4jfa6jbp3r_at_4ax.com>...
>

>>On 19 Jul 2004 11:53:31 -0700, puritycontr0L_at_netscape.net (Purity
>>Control) wrote:
>>
>>
>>>I have a Windows NT server with two v7.3.4 databases.  Both are set to
>>>start automatic.  On reboot, only one database starts.  The other
>>>starts the background processes and hangs.  It never mounts the
>>>database files.
>>>
>>>Registry entries for both databases look much the same.
>>>
>>>I have tried deleting the Windows services and recreating with Oradim
>>>several times, without success.  It's always the same database that
>>>balks.  I can delete and recreate the services for the other (well
>>>behaved) database and it consistently autostarts.
>>>
>>>After a reboot, I use svrmgr23 to start the one database that refuses
>>>to autostart and it opens normally.
>>>
>>>Is there anything left to try or this a lost cause?
>>>
>>>Thank you.
>>
>>
>>Post the snippet from the alert with the error message, or a screen
>>dump of your svrmgr23 session.

>
>
> There are no error messages.
>
> It's not of much use, but here you go.
>
> ---- Alert Log tail after server reboot----
> Tue Jul 20 13:03:56 2004
>
> PMON started
> Tue Jul 20 13:03:56 2004
>
> DBWR started
> Tue Jul 20 13:03:56 2004
>
> LGWR started
> Tue Jul 20 13:03:56 2004
>
> RECO started
>
> ---- End ----
>
> At this point, it just hangs. The SGA is in memory but the
> database never mounts, until I go to the console and enter:
>
> E:\ORANT\BIN>svrmgr23
>
> Oracle Server Manager Release 2.3.4.0.0 - Production
>
> Copyright (c) Oracle Corporation 1994, 1995. All rights reserved.
>
> Oracle7 Workgroup Server Release 7.3.4.0.0 - Production
> With the distributed option
> PL/SQL Release 2.3.4.0.0 - Production
>
> SVRMGR> connect internal
> Password:
> Connected to an idle instance.
> SVRMGR> startup
> ORACLE instance started.
> Total System Global Area 20357244 bytes
> Fixed Size 35760 bytes
> Variable Size 17011916 bytes
> Database Buffers 3276800 bytes
> Redo Buffers 32768 bytes
> Database mounted.
> Database opened.
> SVRMGR>
>
> As long as I don't reboot, I can close and open the database
> with svrmgr23.
>
> I think it's a goner.
>
> Thanks.

oradim73 -edit -sid BLAH -autostart TRUE or something similar (oradim73, might be oradim23; check syntax with oradim73 -help first)

Autostarting services and the database are two diffrent things.

Is there a oradim.log file, and are there any errors in it?

-- 

Regards,
Frank van Bortel

Received on Wed Jul 21 2004 - 04:40:13 CDT