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----- Sent: 16 July 2003 12:24 To: Multiple recipients of list ORACLE-L 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. ________________________________________________________________________ -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Lee Cullip INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).