Re: Creating a service dependency on an Oracle Instance

David Fishburn <fishburn_spam_at_off.ianywhere.com> wrote in message news:<Xns946B9853BE145fishburnsybasecom_at_10.22.106.180>...
> Oracle 8.1.7 on W2K
>
> I want to setup an service that depends on my Oracle instance starting
> successfully.
>
> I have setup the windows registry to indicate to wait until Oracle
> successfully starts. But it appears Oracle tells windows that it has
> successfully started too SOON.
>
> My application cannot connect, when windows starts it.
> I can start it a bit later successfully.
>
> This is obviously a bug in Oracle, since other services work correctly.
>
> Does anyone know a work around for this?
>
> I have tried setting dependencies on these services (in desperation):
> OracleOraHome81TNSListener,OracleServiceFFS42GA,OracleOraHome81Agent
>
> Where OracleServiceFFS42GA is my actual instance.
>
> Thanks,
> Dave

Dave,

one could set the service to not start the instance, then in a batch script connect as sysdba and startup the instance in a sqlplus script, which is configured to not return control to the calling app until the database is successfully opened.

sounds like you'll want to use verbose handling of error messages in this.

Pd Received on Sat Jan 10 2004 - 16:24:34 CST