Re: Autostart service / instance on NT

From: Howard J. Rogers <dba_at_hjrdba.com>
Date: Fri, 14 Dec 2001 16:05:18 +1100
Message-ID: <3c198807$0$7498$afc38c87@news.optusnet.com.au>

Well, if you've set the thing to autostart with oradim (and confirmed it by looking at the Control Panel services applet), and it then simply refuses to restart, you have to wonder whether something is happening to prevent it from restarting automatically.

Things like: is the pfile where you state it is (d:\thepath\initorcl.ora). Is the internal password really 'oracle' (and if so, why on Earth is that so!!?).

Then maybe there are memory or permissions issues to be addressed. The good old alert log is the place to start. Check out the last few entries there immediately after reboot, and tell us what is says (if anything). Found in whereever the pfile's background_dump_dest paramater is pointing, this file is pretty important, so get used to looking at it often.

Regards
HJR

--
----------------------------------------------
Resources for Oracle: http://www.hjrdba.com
===============================

"Elton Saulsberry" <see_message_body_at_devnull.net> wrote in message
news:qo5S7.3004$Z24.2241982_at_typhoon.jacksonville.mediaone.net...


> Hello,

> I'm trying to help someone with 8.0.5 on NT and NT Terminal Server.  We

have


> the database working except for one thing:  When the machine is booted,

the


> instance doesn't start.  In the Services dialog, the service is shown as

> started (automatic) but the instance doesn't come up.  It requires using

> svrmgr30 to STARTUP.

>

> I created the service with

> ORADIM80 -NEW -SID ORCL -SRVC ORCL -INTPWD ORACLE -STARTMODE AUTO -PFILE

> D:\THEPATH\INITORCL.ORA

>

> Any idea how to get this thing to autostart on boot?

>

> Thanks for your help

> --

> Elton Saulsberry

> esaulsberry AT jumpon DOT net

>

>

Received on Thu Dec 13 2001 - 23:05:18 CST