Hi Jose, I've tried twice to send you the information but the mailing list has decided that it contains a 'virus signature' and rejects the email.
So can you let me know specially what you are looking for and I will send you those values. Thanks, N. :->-----Original Message----- :->From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] :->Behalf Of :->Jose Luis Delgado :->Sent: 16 July 2003 16:49 :->To: Multiple recipients of list ORACLE-L :->Subject: RE: Oracle Instances not starting up via services :-> :-> :->Nuala... :-> :->1.- can you send your environment variables? (my_pc -> :->properties -> advanced -> environment variables) :-> :->2.- can you send your Oracle registry values? :-> :->JL :-> :->--- Nuala Cullen <[EMAIL PROTECTED]> wrote: :->> :->> 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). :-> :-> :->__________________________________ :->Do you Yahoo!? :->SBC Yahoo! DSL - Now only $29.95 per month! :->http://sbc.yahoo.com :->-- :->Please see the official ORACLE-L FAQ: http://www.orafaq.net :->-- :->Author: Jose Luis Delgado :-> 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).