Re: Database startup verification for Windows Services?

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_at_x.washington.edu
(replace x with u to respond)