Hi Nuala...!
I'm almost sure that your problem is with environment
variables... they usually are taken from the registry
or defined on my_pc's properties...
That's why I would like to know that values...
can you send them to the list?
HTH
JL
- Nuala Cullen <ncullen_at_catlogic.com> wrote:
> 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
Received on Thu Jul 17 2003 - 08:57:56 CDT