RE: Oracle Instances not starting up via services

Hi,
Reading your mail, your registry setting for ora_wms_pfile is set to c:\oracle\ora8\database\initwms.ora, but your oracle home is c:\oracle\ora81, not sure if this is just a typo, but it may help you.

Cheers
Lee

-----Original Message-----
From: Nuala Cullen [mailto:ncullen_at_catlogic.com] Sent: 16 July 2003 12:24
To: Multiple recipients of list ORACLE-L Subject: Oracle Instances not starting up via services

Hi All,

I have inherited a couple of databases on one of the servers here. The server was taken down for hardware repairs during the week and when it came back up the databases did not start. (They are set to start automatically via the services)

I have done some research via the internet and I deleted and recreated the service via the ORADIM utility.

But this has n't fixed it. I have to manually go into and start the databases (explicitly stating where the init.ora file is)

I am getting this error message when I go in via SQLPLUS /NOLOG (connected as internal)

Startup
error message LRM-00109 can not open parameter file '%oracle_home%/database/init%oracle_sid%.ora

If I do a startup pfile=c:\oracle\ora81\database\initwms.ora it starts as normal.

I've checked that the oracle home is defined as c:\oracle\ora81 so I am beginning to suspect it has something to do with the oracle sid. In registry the ora_wms_pfile location is set to c:\oracle\ora8\database\initwms.ora

We have 4 different instances on this box and none of them will start automatically.
Oracle version 8.1.7 running on a Windows Server 2000 box

Any help appreciated,

Thanks,

N.

This e-mail message (including any attachment) is intended only for the personal use of the recipient(s) named above. This message is confidential and may be legally privileged. If you are not an intended recipient, you may not review, copy or distribute this message. If you have received this communication in error, please notify us immediately by e-mail and delete the original message.

Any views or opinions expressed in this message are those of the author only. Furthermore, this message (including any attachment) does not create any legally binding rights or obligations whatsoever, which may only be created by the exchange of hard copy documents signed by a duly authorised representative of Hutchison 3G UK Limited.