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: AK <oramagic_at_hotmail.com>
Date: Wed, 16 Jul 2003 07:52:05 -0700
Message-Id: <25937.338042@fatcity.com>


what about ora_wms_autostart ?

-ak

>
> 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,
Received on Wed Jul 16 2003 - 09:52:05 CDT

Original text of this message

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