determining if a remote db is up or down
From: Raj A <rarora_at_metasolv.com>
Date: 13 Jan 2003 07:58:48 -0800
Message-ID: <417959c3.0301130758.4cc273e8_at_posting.google.com>
Date: 13 Jan 2003 07:58:48 -0800
Message-ID: <417959c3.0301130758.4cc273e8_at_posting.google.com>
Does anyone know a simple method of determing if a remote db is up or
down which can be instrumented from a shell script.
I've looked at using tnsping but it only tells me if the listener is
up.
I've been looking at making a sqlplus cmd but can't figure out how to
make the call in a single line and have it complete with a successful
or fail message for the connection.
Can anyone advise.
rarora_at_metasolv.com