How to check whether DB is up

From: <pradeepj_at_delhi.tcs.co.in>
Date: Sat, 21 Nov 1998 09:58:59 GMT
Message-ID: <7362t0$ejd$1@nnrp1.dejanews.com>

Hi! In my application which I am writing in 'C' and pro*C, I want to continuously check whether an instance of oracle database is up or not. This I can do by connecting to the database(using EXEC SQL CONNECT)after certain fixed interval of time but this seems to me very time consuming method.

is there any other way like what tns ping would be doing internally.

I do not want to use tnsping in my program as it is shell command.

thanks in advance

-pradeep

-----------== Posted via Deja News, The Discussion Network ==----------
http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Sat Nov 21 1998 - 03:58:59 CST