Re: Help! Oracle7 on NT 4.0...startup

Ken Geng wrote:
>
> Paul A. Swarthout wrote:
> ->
> -> Hi,
> ->
> -> I have 5 instances on an NT 4.0 box. When I reboot the box the
> databases
> -> won't automatically restart. I have to manually connect to each
> database
> -> and manually start each database with the
> -> startup pfile=initxxxx.ora
> -> command. What do I have to do to get the databases to auto start?
> All of
> -> the services are up and running, just the databases are not.
> ->
> -> TIA,
> ->
> -> Paul A. Swarthout
> -> SalesKit Software Inc.
> -> pswarthout_at_saleskit.com
>
> Did you check the Oracle Server Manager? Seems to me you need to set
> up automatic start option there.
>
> Ken.

Paul,
Sorry if this is late and you have resolved the problem - but... I assume that when you say the "services are up and running" that you are getting this indication by the Control Panel Services screen saying that the Oracle related services are started. If this is not the case, you would need to change the option for each of the services (in control panel) to automatically start. Assuming this is done, the config file for each SID (since it is not the default ORCL) must specify the details, i.e. config file for SID1 with an Oracle home of "c:\orant" would be:

"c:\orant\bin\oradim73.exe -startup -sid SID1 -usrpwd PASSWORD -starttype  srvc,inst -pfile c:\orant\database\initSID1.ora"

Wish you the best!

Chris Mayol
Fairfax Solutions Corp.
Fairfax, Va. 22030-5708
cmayol_at_erols.com Received on Fri Feb 21 1997 - 00:00:00 CST