| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.server -> Re: Database won't start Automatic, balks at datafile mount
Frank van Bortel <fvanbortel_at_netscape.net> wrote in message news:<cdldb8$fdd$1_at_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.
[snip]
> >>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.
[snip]
> 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.
Just as a point of reference, this is a very old server with NT 4.0 SP6 installed. Back in Oracle7 days, two services were created by ORADIM73 when requesting an Automatic Start mode: OracleStartSID and OracleServiceSID. The OracleStartSID would kick off the OracleServiceSID then it would go dormant.
The behavior I am seeing is that both services go to a status of "Started" and OracleStartSID never completes. This is why the background services are in memory. It cannot complete, because the service is unable to mount the database files. This is the real mystery -- what can't it mount the database files?
This is the only database that is showing such strange behavior. The other database on the server is behaving correctly.
As an experiment, I copied the balky database to another NT 4.0 SP6 Oracle 7.3.4. server and recreated the services, rebooted. Exact same behavior with the services. I've never encountered such a balky database. I've moved Oracle7 databases around servers regularly, recreating their services and never had an issue (until now.)
The commands I use for ORADIM73 are:
oradim73 -delete -sid vapp
[Check that services are gone, and that the pwdvapp.ora and strtvapp.cmd have been removed.]
oradim73 -new -sid vapp -startmode auto -intpwd xxx -pfile e:\orant\database\ initvapp.ora
At this point the two NT services are created, and look like this:
Status Startup
------------------------------------
OracleServiceVAPP Started Automatic
OracleStartVAPP Automatic
I can use SVRMGR23 to open the database without incident.
But when I reboot the server, they look like this:
Status Startup
------------------------------------
and OracleStartVAPP never finishes. The Alert Log trails off at RECO starting and the Oradim73.log has the following (unhelpful) message.
Oradim73: Command Line Mode.
Service(s) and instance being started. Please wait... Service(s) and instance being started. Please wait... Startup Database ErrorFailed to startup the database.Failed to start the instance.
> Is there a oradim.log file, and are there any errors in it?
No errors, but a message that it was unable to start one of the databases.
Thanks. Received on Wed Jul 21 2004 - 13:13:59 CDT
 |
 |