Re: oraclestart missing in services on WIN NT

Start up a dos box and the delete the instance (this won't delete the datafiles) with the oradim command. Then recreate the instance with the oradim command. This should resolve the issue. oradim<xx> -delete -sid PD4
oradim<xx> -new -sid PD4 -intpwd <....> -pfile <exact name of pfile> -startmode a

For exact syntax refer to oradim -? | more

Hth,

Sybrand Bakker, Oracle DBA

"jeffro" <jrowland_at_sprynet.com> wrote in message news:93ic6p$a55$1_at_nnrp1.deja.com...
> A contrator previously installed four Oracle databases on our Windows
> NT server. I have noticed whenever the server is rebooted or restarted,
> 3 of the Oracle databases are started. I check the status of the
> databases through the Instance Mananger every mornin.I am then able to
> start the other Oracle Database by using Instance Manager.
>
> After doing some research noticed that if I go to Control
> Panel and click on services, there are four services listed (1 each for
> the four different sid's PD1,PD2,PD3,PD4):
>
> OracleServicePD1
> OracleServicePD2
> OracleServicePD3
> oracleServicePD4
>
> There are only 3 services listed for:
> OracleStartPD1
> OracleStartPD2
> OracleStartPD3
>
> There is no service listed for OracleStartPD4, and this is the database
> that is not started automatically on rebooted.
>
> I have been pouring over all my Oracle Books but somehow can't
> determined how to get the OracleStartPD4 service created. I want to try
> to solve this on my own, without having to go to the contractor.
>
> Any help would be very much appreciated.
>
> Thanks
>
>
> Sent via Deja.com
> http://www.deja.com/
Received on Wed Jan 10 2001 - 14:38:59 CST