Re: Database startup verification for Windows Services?

DA Morgan <damorgan_at_psoug.org> wrote:

>Joop wrote:
>> Is there a possibility to have a Windows service startup depend on the
>> successful startup of and Oracle database? Using the dependency
>> mechanism of Windows services appears like the way to go, but making a
>> service depend on the listener service and the database instance
>> service does not do the trick, since apparently the listener service
>> signals that is 'started' long before it is actually up and running.
>>
>> We can of course create our own service that does a busy poll on the
>> database, but are hoping that this wheel is already invented...
>
>Change the services to MANUAL and start them with a batch file.
>
>For example:
>c:\dos> net start oracleserviceorcl

But bear in mind that the oracle service starting does not mean the database is ready for use..It still needs to startup, mount and open..That can take a few minutes, depending on your configuration.. Received on Fri Oct 14 2005 - 15:32:55 CEST