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

From: Purity Control <puritycontr0L_at_netscape.net>
Date: 20 Jul 2004 10:09:32 -0700
Message-ID: <dc90049d.0407200909.6ed2f8b4@posting.google.com>

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

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. Received on Tue Jul 20 2004 - 12:09:32 CDT