Report_oracle_inspection.sh

#!/bin/bash 
# 
#    NAME 
#     Report_oracle_inspection.sh   2016-12-30
# 
#    DESCRIPTION 
#     Collecting the DB info 
# 
#    NOTES 
#     sh Report_oracle_inspection.sh 
# 
#    MODIFIED       (yyyy-mm-dd) 
#     liyanming       2016-12-30 
#    Scripts_PATH =/home/oracle/scripts/check/bin  Log_Path=/home/oracle/scripts/check/log
export AIXTHREAD_SCOPE=S #(S for system-wide thread scope)
export TMPDIR=/tmp
umask 022
export ORACLE_HOSTNAME=testrac1
export ORACLE_UNQNAME=dw
export ORACLE_BASE=/u02
export ORACLE_HOME=/u02/app/oracle
export ORACLE_SID=dw1
export ORACLE_TERM=xterm
export PATH=$ORACLE_HOME/bin:/usr/sbin:/usr/kerberos/bin:/usr/local/bin:/bin:/usr/bin:/home/grid/bin:$PATH
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib
export CLASSPATH=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib
export DISPLAY=10.1.110.130:0.0
JAVA_HOME=/usr/local/java1.8
export CLASSPATH=.:$JAVA_HOME/lib:$JAVA_HOME/jre/lib
export PATH=$JAVA_HOME/bin:$JAVA_HOME/jre/bin:$PATH
sqlplus / as sysdba <<eof
spool /home/oracle/scripts/check/log/Report_oracle_inspection.out
@/home/oracle/scripts/check/bin/Report_oracle_inspection.sql
spool off
eof


CHECK_DATE=`date +%F` 
mv /home/oracle/scripts/check/log/Report_oracle_inspection.out /home/oracle/scripts/check/log/Report_oracle_inspection_$CHECK_DATE.out