Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: How to check whether DB is up

Re: How to check whether DB is up

From: Diane <Diane_at_coalole.demon.co.uk>
Date: Sun, 22 Nov 1998 21:37:37 +0000
Message-ID: <hVrzjCAhQIW2IwMq@coalole.demon.co.uk>


Unfortunately this file does not appear to exist when running Oracle on aN NT server. - Anyone got a solution for that situation please? Diane

In article <738a2g$53q_at_sjx-ixn5.ix.netcom.com>, Tom A <tashbrk_at_ix.netcom.com> writes
>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
>
>

--
Diane Received on Sun Nov 22 1998 - 15:37:37 CST

Original text of this message

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