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: ml-errors_at_fatcity.com [mailto:ml-errors_at_fatcity.com] On
> Behalf Of Jared.Still_at_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" <niall.litchfield_at_dial.pipex.com>
> Sent by: ml-errors_at_fatcity.com
> 07/17/2003 04:14 PM
> Please respond to ORACLE-L
>
>
> To: Multiple recipients of list ORACLE-L
> <ORACLE-L_at_fatcity.com>
> 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: ml-errors_at_fatcity.com [mailto:ml-errors_at_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_at_fatcity.com
> > [mailto:ml-errors_at_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 <ncullen_at_catlogic.com> 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_at_cybcon.com]
> > :->> :->Sent: 16 July 2003 14:31
> > :->> :->To: ORACLE-L_at_fatcity.com; 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: ncullen_at_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_at_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_at_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_at_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_at_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_at_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_at_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_at_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_at_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
Received on Fri Jul 18 2003 - 14:19:04 CDT
