Connect through the listener/tnsnames will work, then startup pfile=..... Its just the bequeath protocol that doesn't work. Or net start oracleservice<blah> if the instance is set to autostart with the service.
> -----Original Message----- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On > Behalf Of [EMAIL PROTECTED] > 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" <[EMAIL PROTECTED]> > Sent by: [EMAIL PROTECTED] > 07/17/2003 04:14 PM > Please respond to ORACLE-L > > > To: Multiple recipients of list ORACLE-L > <[EMAIL PROTECTED]> > 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 <runs away and hides> > > Niall > > > -----Original Message----- > > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] 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: [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). > > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Niall Litchfield > 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: > 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: Niall Litchfield 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).
