omscripts_db_96_mountcheck.sh

#!/bin/bash
# 如果是10g比較好是把前面的SQL提出去變另一個檔案
# ScriptName : mountcheck.sh
# 自動重啟  $1 =  GO
# mountcheck.sh  GO
PATH=$PATH:$HOME/bin

. ~/.bash_profile
S=`sqlplus -s / as sysdba <<EOF
SET HEADING OFF FEEDBACK OFF ECHO OFF PAGESIZE 0
select OPEN_MODE
from v\$database
where 1=1 ;

exit;
EOF`
echo $S
#MOUNT=`echo $S | awk '{print $1}'`

#echo $MOUNT

if [ "$S" = "MOUNTED" ]
then

echo "Mount OK good"

else

if [ "$S" = "READ ONLY" ]
then
echo "Must shutdown NG !!"
if [ "$1" = "GO" ]
then
echo "DO Shutdown"
sqlplus -s / as sysdba <<EOF
SET HEADING OFF FEEDBACK OFF ECHO OFF PAGESIZE 0
shutdown immediate;
startup mount ;
exit;
EOF

TimeStr=`date +%Y-%m-%dT%H-%M-%S`
STR="TEST STB DB is restart mount as ${TimeStr}"
/omscripts/sendsms.sh "$STR" "177" "300"

fi

fi
fi





omscripts oracle$  cat S_96.sql
select OPEN_MODE
from v$database
where 1=1 ;

omscripts_db_14_autosendrep.sh

 vi /oracle/u02/omscripts/14_autosendrep.sh

#!/bin/bash

if [ -f ~/.bashrc ]; then
. ~/.bashrc
fi

# User specific environment and startup programs

MAILLIST='cc.vbhsieh@gmail.com'

. ~/.bash_profile



/oracle/u02/omscripts/10_autorep.sh
DAY_1=`date -d "1 day ago" +%Y_%m_%d`

#TMPFILE2="/tmp/sp_${ORACLE_SID}_${DAY_1}.lst"
TMPFILE="/tmp/sp_${ORACLE_SID}_${DAY_1}.txt"
mv ${TMPFILE2} ${TMPFILE}


#echo "${ORACLE_SID} DB StackPack Report ${DAY_1} " | mail -s "${ORACLE_SID} DB StackPack Report ${DAY_1} " -a ${TMPFILE} -c $MAILLIST $TPMMAIL

/omscripts/sendEmail/sendEmail.pl -f "ORCL_DB@MikeLab.test" -s 192.168.44.20:25 -u "[TOP SQL]_[ORCL] DB StackPack Report ${DAY_1} " -m "ORCL DB StackPack Report ${DAY_1} " -t "$MAILLIST"  -a "$TMPFILE"

omscripts_db_10_autorep.sh

vi /oracle/u02/omscripts/10_autorep.sh



#!/bin/bash
. ~/.bash_profile
sqlplus -S <<EOF
conn / as sysdba
column minsnapid noprint new_value begsnapid
column maxsnapid noprint new_value endsnapid
column spreportname noprint new_value reportname

select min(snap_id) minsnapid
from perfstat.stats\$snapshot
where SNAP_TIME > trunc(sysdate) -1 ;


select max(snap_id) maxsnapid
from perfstat.stats\$snapshot
where SNAP_TIME > trunc(sysdate) -1
and SNAP_TIME <= trunc(sysdate) + 1/24;


select '/tmp/sp_' || instance || '_' || to_char(sysdate -1 , 'yyyy_mm_dd') || '.txt' spreportname
from v\$thread;

define begin_snap=&begsnapid
define end_snap=&endsnapid
define report_name=&reportname

@$ORACLE_HOME/rdbms/admin/spreport.sql
EOF