Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Oracle Instances not starting up via services

Re: Oracle Instances not starting up via services

From: Don Yu <donyu_at_jhu.edu>
Date: Fri, 18 Jul 2003 15:53:15 -0400
Message-Id: <25956.338512@fatcity.com>


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<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
> > 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
Received on Fri Jul 18 2003 - 14:53:15 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US