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).
