Sorry Lee - it's a typo!! Thanks though for pointing it out to me.
N. :->-----Original Message----- :->From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] :->Behalf Of :->Lee Cullip :->Sent: 16 July 2003 14:10 :->To: Multiple recipients of list ORACLE-L :->Subject: 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----- :->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). :-> -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Nuala Cullen 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).