RE: Oracle Instances not starting up via services

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
Received on Wed Jul 16 2003 - 09:32:28 CDT