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

Hi,
tnsping will only try to contact the TNS listener and check whether the instance is known to the listener. It doesn't actually connect to the database. Meaning that you might still run into errors (like database not open, invalid username/password, session limit reached etcetera) when you run your insert/update/deletes.

There's no way to guarantee that a subsequent connect will succeed. All one can say is that if a previous connect attempt made a short time ago was succesfull chances are good that your current connect attempt will also be succesfull.

Regards,
Andre van Winssen

"Galip Topcu" <galip.topcu_at_porcan.com.tr> wrote in message news:39999a8e.0201160046.5de5a89b_at_posting.google.com...
> hello;
>
> I' writing a Client-Server Project; All my client need to connect
> database (in my project databse is Oracle 8.05 ) and do some updates,
> inserts or deletes operations.
>
> Before doing so type of operation I want to check if the Oracle Server
> is Online and ready for new connection ( as "Tnsping80.exe" do ).
> How may I do this?
> Thanks for helps..
>
>
> 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.
Received on Wed Jan 16 2002 - 03:18:02 CST