Hi Jared, Thanks for the advice,
I checked out the registry settings ORA_WMS_PFILE is set to c:\oracle\ora81\database\initwms.ora. ORA_WMS_AUTOSTART is set to TRUE. I'm a bit confused what you mean by using variables. I think you mean not to use %oracle_home% etc but the error message: "LRM-00109 can not open parameter file '%oracle_home%/database/init%oracle_sid%.ora" is as it appeared on the screen. N. :->-----Original Message----- :->From: Jared Still [mailto:[EMAIL PROTECTED] :->Sent: 16 July 2003 14:31 :->To: [EMAIL PROTECTED]; Nuala Cullen :->Subject: Re: Oracle Instances not starting up via services :-> :-> :-> :->Check the registry entry ORA_<SID>_PFILE. Try hardcoding :->the entire path rather than use variables. :-> :->ie. ORA_WMS_PFILE would be set to :->c:\oracle\ora81\database\initwms.ora. :-> :->Be sure ORA_WMS_AUTOSTART is set to TRUE. :-> :->Jared :-> :-> :->On Wednesday 16 July 2003 04:24, Nuala Cullen wrote: :->> 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. :-> :-> -- 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).