#!/bin/bash
PLATFORM=`uname`
strhost=`hostname`
time=`date +%Y-%m-%d" "%H:%M:%S`
index=0
function checkDB()
{
echo ""
echo "***************************************************************"
echo "*****check server $1 begin...******************************"
echo "***************************************************************"
db1procnum=`
sqlplus -s /nolog <<EOF
conn sys/welcome!2012@$2/servdb as sysdba
set timing off;
set echo off;
set feedback off;
set heading off;
set underline off;
select count(*) from v\\$session;
exit;
EOF`
db
PLATFORM=`uname`
strhost=`hostname`
time=`date +%Y-%m-%d" "%H:%M:%S`
index=0
function checkDB()
{
echo ""
echo "***************************************************************"
echo "*****check server $1 begin...******************************"
echo "***************************************************************"
db1procnum=`
sqlplus -s /nolog <<EOF
conn sys/welcome!2012@$2/servdb as sysdba
set timing off;
set echo off;
set feedback off;
set heading off;
set underline off;
select count(*) from v\\$session;
exit;
EOF`
db