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.

Not so much a bug, as Oracle not really being able to communicate with the operating system (see Oracle bugs 2553563, 2834117 and I'm sure many more). Windows starts up things asynchronously in order to let you start doing some other stuff while you wait.

>
> Does anyone know a work around for this?

Use sleep or timeout commands in a script to start the services, then check by trying to connect.

>
> I have tried setting dependencies on these services (in desperation):
> OracleOraHome81TNSListener,OracleServiceFFS42GA,OracleOraHome81Agent
>
> Where OracleServiceFFS42GA is my actual instance.
>
> Thanks,
> Dave

jg

--
@home.com is bogus.
http://bobby.watchfire.com/bobby/html/en/index.jsp