Database startup verification for Windows Services?

[Joop]

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...

[DA Morgan]

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
--
Daniel A. Morgan
http://www.psoug.org
damorgan@x.washington.edu
(replace x with u to respond)

[Turkbear]

DA Morgan <damorgan@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..

[Joop]

Thanks for the suggestion. Bu the start of the Oracle services is not
the problem, it is knowing when the database is really up and running
starting other application services..

[Joop]

We came up with a busy polling tool, but that is not foolproof either.
Apparently the poller was able to make a connection and the application
was started. But it could NOT make connections for a while, it got the
message

ORA-12519, TNS:no appropriate service handler found

It is puzzling why the database service is fluttering...

[DA Morgan]

Joop wrote: We came up with a busy polling tool, but that is not foolproof either. Apparently the poller was able to make a connection and the application was started. But it could NOT make connections for a while, it got the message ORA-12519, TNS:no appropriate service handler found It is puzzling why the database service is fluttering...

I suspect your problem is not what you think it is. Trace the
connection:

# Debugging Parameters
#trace_level_client= 16
#trace_file_client=client
#trace_directory_client=c:\temp
#trace_unique_client=true

And compare with when Oracle reports it is open from the alert log.
--
Daniel A. Morgan
http://www.psoug.org
damorgan@x.washington.edu
(replace x with u to respond)

[Access]

"Joop" <jkaashoek@yahoo.com> wrote in message
news:1129241820.566911.7480@g47g2000cwa.googlegroups.com... 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...

Maybe this KB article helps :
http://support.microsoft.com/default.aspx?scid=kb;en-us;193888


Matthias