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

puritycontr0L_at_netscape.net (Purity Control) wrote in message news:<dc90049d.0407270457.1919d49c_at_posting.google.com>...
> Frank van Bortel <fvanbortel_at_netscape.net> wrote in message news:<cdtnoq$s18$1_at_news2.tilbu1.nb.home.nl>...
> > Purity Control wrote:
> > > Frank van Bortel <fvanbortel_at_netscape.net> wrote in message news:<cdnurf$m2j$1_at_news2.tilbu1.nb.home.nl>...
> > >
> > >>Purity Control wrote:
> > >>
> > >>>Frank van Bortel <fvanbortel_at_netscape.net> wrote in message news:<cdldb8$fdd$1_at_news1.tilbu1.nb.home.nl>...
> > >
> > >
> > > [liberal snippage]
> > >
> > >
> > >>>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?
> > >>
> > >>Where do you have that information from?!?
> > >
> > >
> > > Logical conclusion from the Alert Log and Task Manager. The Alert Log
> > > clearly shows that all the background processes have started, and the
> > > Task Manager shows the SGA in memory. The next process in a startup
> > > is to mount the datafiles and open the database. The datafiles never
> > > mount.
> > >
> > >
> > >>I've seen similar behaviour
> > >>on the same platform with clusters, where the service simply was faster
> > >>than the cluster s/w. The drive(s) on which the data files resided,
> > >>simply weren't available at the time the service was started.
> > >>- move the data files to direct attached storage devices (and
> > >> prove the point)
> > >>- make the service dependant on the cluster services.
> > >
> > >
> > > This is a Windows NT PC, not a unix box. The disks are available at
> > > boot. The fact that the server has 2 databases on it, and the
> > > datafiles for both are on the same drive (F:) is more proof
> > > that the device F: is available. One database opens just fine,
> > > the other balks at the datafile mount on reboots.
> > >
> >
> > Windows can cluster, too ;-)
> > >
> > >>Hm - symptoms, that would subscribe to the above.
> > >>What about a Command Line Interface (CLI - or "DOS Box"), and:
> > >>net start OracleStartVAPP
> > >>or
> > >>net stop OracleStartVAPP
> > >
> > >
> > > Yeah, done that many a time. It starts and stops
> > > cleanly from a Command Prompt window, just not
> > > at a server reboot.
> > >
> > > I really need this database to open at reboot. I'm shipping
> > > this server to a site with no DBA. All they are going to know
> > > how to do is reboot the server. If the database doesn't open
> > > at reboot, they'll be lost.
> > >
> > >
> > >>What about the NT logs (specifically: Application and Security
> > >>Logs) - any failure codes there?
> > >
> > >
> > > Event logs are clean.
> > >
> > > Thanks.
> >
> > Puzzled....
>
> So am I. I am convinced though, that it's operating system related.
>
> Here's why - Our sys admin recently brought up a freshly installed NT
> 4.0 SP6 server. I installed Oracle 7.3.4 on it and copied over the
> errant database VAPP. Created new services for it and guess what
> happened? Yep, VAPP starts automatic on the newly created NT server.
> Which means something is screwed on our three old NT 4.0 servers, as
> VAPP won't start automatic on any of the them (at least it means the
> messed up part is consistent across the servers.)
>
> Just for kicks, I am going to create a new VAPP and export the old
> VAPP into it, just to see what happens on the old NT server.
>
> Thanks.

Tabs in the init? http://metalink.oracle.com/metalink/plsql/ml2_documents.showFrameDocument?p_database_id=NOT&p_id=62006.1

jg

--
@home.com is bogus.
http://www.churchofspongebob.org/