Message-Id: <25956.338512@fatcity.com> From: Don Yu Date: Fri, 18 Jul 2003 15:53:15 -0400 Subject: Re: Oracle Instances not starting up via services Niall, Could you please be more detail in step by step for this is my first time to meet my Oracle power off! Thanks! Don Niall Litchfield wrote: > Connect through the listener/tnsnames will work, then startup > pfile=..... Its just the bequeath protocol that doesn't work. > Or net start oracleservice if the instance is set to autostart > with the service. > > > -----Original Message----- > > From: ml-errors@fatcity.com [mailto:ml-errors@fatcity.com] On > > Behalf Of Jared.Still@radisys.com > > Sent: 18 July 2003 01:59 > > To: Multiple recipients of list ORACLE-L > > Subject: RE: Oracle Instances not starting up via services > > > > > > So, how are you starting up instances via Terminal Services? > > > > I haven't tried to make that work yet. > > > > Though I do get highly annoyed with myself when I forget I'm > > in termserver and not pcanywhere, and can't start a database. > > > > Jared > > > > > > > > > > > > "Niall Litchfield" > > Sent by: ml-errors@fatcity.com > > 07/17/2003 04:14 PM > > Please respond to ORACLE-L > > > > > > To: Multiple recipients of list ORACLE-L > > > > cc: > > Subject: RE: Oracle Instances not starting up > > via services > > > > > > I didn't see the original message, but I'll get cannot open > > '%oracle_home%/database/init%oracle_sid%.ora" everytime if > > using terminal services to start the instance. Is this via a > > ts session or actually at the console? > > > > Er, Obviously I never forget to type pfile=..... Though. Me, > > I'm professional > > > > Niall > > > > > -----Original Message----- > > > From: ml-errors@fatcity.com [mailto:ml-errors@fatcity.com] On > > > Behalf Of Nuala Cullen > > > Sent: 17 July 2003 12:24 > > > To: Multiple recipients of list ORACLE-L > > > Subject: RE: Oracle Instances not starting up via services > > > > > > > > > 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: ml-errors@fatcity.com > > > [mailto:ml-errors@fatcity.com]On :->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 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:jkstill@cybcon.com] > > > :->> :->Sent: 16 July 2003 14:31 > > > :->> :->To: ORACLE-L@fatcity.com; Nuala Cullen > > > :->> :->Subject: Re: Oracle Instances not starting up via > > > :->> services > > > :->> :-> > > > :->> :-> > > > :->> :-> > > > :->> :->Check the registry entry ORA__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: ncullen@catlogic.com > > > :->> > > > :->> 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: ListGuru@fatcity.com (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: joseluis_delgado@yahoo.com > > > :-> > > > :->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: ListGuru@fatcity.com (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: ncullen@catlogic.com > > > > > > 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: ListGuru@fatcity.com (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: Niall Litchfield > > INET: niall.litchfield@dial.pipex.com > > > > 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: ListGuru@fatcity.com (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: > > INET: Jared.Still@radisys.com > > > > 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: ListGuru@fatcity.com (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: Niall Litchfield > INET: niall.litchfield@dial.pipex.com > > 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