Re: how can I check if Oracle Database is online?

From: rob <rob_at_dsdelft.nl>
Date: Wed, 16 Jan 2002 10:25:50 +0100
Message-ID: <a23guu$edr$1@news.tudelft.nl>

> I'm using ADO for accessing database.
> ADO's time out periot is not working , when The client program try new
> connection to oracle ,It lock my program during 40 secconds if Oracle
> Database is not ready or network is off. But Tnsping is very
> successfull about that. It decide if oracle is ok or not in 1 or 2
> secconds.

Note that tnsping only checks if the listener on the server is accepting requests, not if the database is up. A tnsping gives OK even if database is down.

Rob. Received on Wed Jan 16 2002 - 03:25:50 CST

This message: [ Message body ]
Next message: Niall Litchfield: "Re: Oracle 9i optimization.. something wrong?"
Previous message: Marcin Kasperski: "Re: how can I check if Oracle Database is online?"
In reply to: Galip Topcu: "how can I check if Oracle Database is online?"
Next in thread: Andre van Winssen $andrew$: "Re: how can I check if Oracle Database is online?"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US