cechon "1.1 server hostname is:" red
echo ${hostname}

cechon "1.2 server ipaddree is: " red
echo ${ipaddress}

if [ "${gtway01}" = "" ];then
cechon "1.3 server gateway is:" red
echo ${gtway02}
else
cechon "1.3 server gateway is:" red
echo ${gtway01}
fi

cechon "1.4 server cpuinfo is: " red
echo ${cpuinfo}

cechon "1.5 server Physical memory number is: " red
echo ${phmem}

cechon "1.6 server version is: " red
echo ${sysver}

cechon "1.7 server system kernel version is: " red
echo ${kerver}

cechon "1.8 server memory Summary is: " red
echo ${mem_sum}

cechon "1.9 server memory usage rate is: " red
echo ${mem_rate:0:5}%

cechon "1.10 server disk usage is: " red
echo
cechon "detail: " green
echo
#disk usage
df -H |awk -F '\t' '{ print $1,$2,$3,$4,$5,$6}'
echo
cechon "Summary: " green
echo
echo ${dk_usage}

echo
cechon "1.11 server CPU load average is: " red
echo
uptime | awk 'BEGIN{print "1min, 5min, 15min"} {print $10,$11,$12}'

echo
cechon "1.12 server started services is: " red
echo
chkconfig --list | grep on
echo

echo
cechon "1.13 server CPU free is: " red
top -b -n 1 | grep Cpu | awk '{print $5}' | cut -f 1 -d "."
echo

cechon "1.14 server ESTABLISHED TCP connect number is: " red
echo
netstat -n | awk '/^tcp/ {++S[$NF]} END {for(a in S) print a, S[a]}'
echo

cechon "1.15 server ESTABLISHED TCP connect number is: " red
echo
netstat -n | awk '/^tcp/ {++S[$NF]} END {for(a in S) print a, S[a]}'
echo

cechon "1.16 oracle ESTABLISHED connect is: " red
echo
netstat -an -t | grep ":1521" | grep ESTABLISHED | awk '{printf "%s %s\n",$5,$6}' | sort |sed 's/^::ffff://'
echo

cechon "1.17 oracle runing processes is: " red
echo
ps -ef|grep ora_|grep -v grep&&ps -ef|grep ora_|grep -v grep|wc -l
echo

cechon "1.18 oracle LISTENER status is: " red
echo
ps -ef|grep lsn|grep -v grep
echo
lsnrctl status
echo

echo
echo "***********************************************************************"
echo

cechon "***********************************************************************" yellow
echo
cechon "2.Check the database basic situation:" green
echo
cechon "***********************************************************************" yellow
echo

#configure oracle user and password

ora_user="sys"
ora_pass="jinriDBAocpyang_jinri_ocp.com"

#2.1 oracle database version
echo
sqlplus -S "${ora_user}/${ora_pass} as sysdba" </dev/null #禁止sqlplus执行结果回显
set heading off;
set feedback off;
set termout off;
set pagesize 0;
set verify off;
set echo off;
spool 1.txt
select * from v\$version;
spool off
exit;
!01

cechon "2.1 oracle database version is : " red
echo
cat 1.txt
echo
rm -rf 1.txt

#2.2 oracle database information

sqlplus -S "${ora_user}/${ora_pass} as sysdba" </dev/null #禁止sqlplus执行结果回显
set heading off;
set feedback off;
set termout off;
set pagesize 0;
set verify off;
set echo off;
spool 2.txt
select dbid,name,created,log_mode,open_mode,db_unique_name from v\$database;
spool off
exit;
!01

cechon "2.2 oracle database information is : " red
echo
cat 2.txt |xargs |awk '{print "dbid:"$1,"\nname:"$2, \
"\ncreated:"$3" "$4,"\nlog_mode:"$5,"\nopen_mode:"$6" "$7,"\ndb_unique_name:"$8}'
echo
rm -rf 2.txt

#2.3 oracle instance information