RE: Oracle Instances not starting up via services

Sorry Lee - it's a typo!!

Thanks though for pointing it out to me.

N.

:->-----Original Message-----
:->From: ml-errors_at_fatcity.com [mailto:ml-errors_at_fatcity.com]On
:->Behalf Of
:->Lee Cullip
:->Sent: 16 July 2003 14:10
:->To: Multiple recipients of list ORACLE-L
:->Subject: RE: Oracle Instances not starting up via services
:->
:->
:->Hi,
:->Reading your mail, your registry setting for ora_wms_pfile is set to
:->c:\oracle\ora8\database\initwms.ora, but your oracle home is
:->c:\oracle\ora81, not sure if this is just a typo, but it may
:->help you.
:->
:->Cheers
:->Lee
:->
:->-----Original Message-----
:->Sent: 16 July 2003 12:24
:->To: Multiple recipients of list ORACLE-L
:->
:->
:->
:->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.
:->
:->
:->
:->
:->_____________________________________________________________
:->___________
:->
:->This e-mail message (including any attachment) is intended
:->only for the personal
:->use of the recipient(s) named above. This message is
:->confidential and may be
:->legally privileged. If you are not an intended recipient,
:->you may not review, copy or
:->distribute this message. If you have received this
:->communication in error, please notify
:->us immediately by e-mail and delete the original message.
:->
:->Any views or opinions expressed in this message are those of
:->the author only.
:->Furthermore, this message (including any attachment) does
:->not create any legally
:->binding rights or obligations whatsoever, which may only be
:->created by the exchange
:->of hard copy documents signed by a duly authorised
:->representative of Hutchison
:->3G UK Limited.
:->_____________________________________________________________
:->___________
:->
:->--
:->Please see the official ORACLE-L FAQ: http://www.orafaq.net
:->--
:->Author: Lee Cullip
:-> INET: Lee.Cullip_at_three.co.uk
:->
:->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
Received on Wed Jul 16 2003 - 07:50:03 CDT