Re: How to check whether DB is up

From: Tom A <tashbrk_at_ix.netcom.com>
Date: Sat, 21 Nov 1998 22:06:32 -0500
Message-ID: <738a2g$53q@sjx-ixn5.ix.netcom.com>

When the database is started up there is a file called sgadefSID.dbf in ?/dbs. The existence of this file indicates that the database is up in most situations (unless there was an abnormal shutdown in which some cases the file may still exist - though its rare).

hth,
Tom.

pradeepj_at_delhi.tcs.co.in wrote in message <7362t0$ejd$1_at_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 - 21:06:32 CST