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).