Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Ping another Instance?
Tnsping may succeed even if the Remote DB is down as long as the Listener is
up.
You may need to try setting the TWO_TASK variable to the Remote SID and do
oiconnect system/<password>
echo $<STATUS>
If it returns 0 , then the DB is up or else down. I have created a script
'dbping' which does this .
Pls Note that $ORACLE_HOME/bin/oiconnect of only ver 7.3.2 works fine as of
now.
-Thiru
Manu wrote:
> Yes, TNSPING (An Oracle executable). It's work like IP ping.
>
> P Jeromel a écrit dans le message <376DF824.70FBE969_at_hotmail.com>...
> Re all,
> I have the following situation:
> 2 Oracle databases on seperate machines linked via network.
>
> Question:
> I need to ping one database from within the other.
>
> Simple Solution:
> Create a DB link, and do a simple query on the other database via the
> DB_LINK.
>
> Problem with this:
> If the connection is down because of the network or because the other DB
> is down, then it takes too long to time out and bring back an error.
>
> Does anyone have a solution for pinging which has a quick timeout for
> invalid connections? Or are there settings which I can manipulate??
>
> Thanks.
> Paul
Received on Mon Jun 21 1999 - 11:19:10 CDT