how can I check if Oracle Database is online?

From: Galip Topcu <galip.topcu_at_porcan.com.tr>
Date: 16 Jan 2002 00:46:29 -0800
Message-ID: <39999a8e.0201160046.5de5a89b@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 - 02:46:29 CST