Oracle TNSping test shell script for Redhat Linux AS 3

tongyan · Post by **tongyan** » Mon Apr 04, 2005 11:34 pm

#!/bin/sh
su - oracle -c "/u01/app/oracle/product/9.2.0/bin/tnsping $1" |tail -1 \
|awk '{if ($1=="OK") {ms=(substr($(NF-2),1)); \
printf ("ScriptRes:Ok:%d ms\n",ms)} else {printf ("ScriptRes:Bad:%d ms\n",ms)};exit}'

Nadir · Post by **Nadir** » Mon Jan 14, 2008 3:18 am

Hi all,
How this script works?
Is this script required just TNS alias?
Thanks for help

KS-Soft Europe · Post by **KS-Soft Europe** » Mon Jan 14, 2008 3:46 am

Nadir wrote:How this script works?

Script is designed for "Shell Script" test method ( http://www.ks-soft.net/hostmon.eng/mfra ... m#chkShell )and should be performed by "RMA for *nix".
http://www.ks-soft.net/hostmon.eng/rma-unix/index.htm

Script executes tnsping utility with TNS alias, passed as parameter, checks the last line of the output (tail -1) and takes the response time.

Nadir wrote:Is this script required just TNS alias?

Corect.

Regards,
Max