페이지 이력

#!/bin/bash

umask 022

##### 환경 변수 입력 또는 기존 환경 프로파일 로드
# export ORACLE_BASE=/u01/app/oracle
# export ORACLE_HOME=$ORACLE_BASE/product/19c/db_1
# export TNS_ADMIN=$ORACLE_HOME/network/admin
# export GRID_HOME=$ORACLE_BASE/19c/grid
# export NLS_LANG=AMERICAN_KOREA.AL32UTF8
# export ORACLE_SID=ora19chas
# export ORACLE_UNQNAME=ora19chas
# export PATH=$ORACLE_HOME/bin:$PATH
# export LIBPATH=$LIBPATH:/app/xecuredb/server/lib
# export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib:$ORACLE_HOME/rdbms/lib

. ~oracle/.bash_profile
SID=$ORACLE_SID

##### 리스너명 입력 및 추가 환경 설정
export DB_LSNR=LISTENER_CORDBP[DB리스너명]
export ASM_LSNR=ASMNET1LSNR_ASM

##### 쉘 시작 알림
SHELL_START_TIME=`date "+%H:%M:%S"`
nDATE=`date "+%Y%m%d"`
echo "[${SHELL_START_TIME}] Shell has been started~!"

##### 로그 저장 경로 이동 및 환경 설정 : 사전에 로그 적재 경로 생성 필요
cd ~oracle/dba/daily_chk
nPATH=`pwd`
cd $ORACLE_SID

##### 백그라운드 프로세스 체크
echo " " > ./daily_chk_$SID_$nDATE.txt
echo "<<<<<<<<<<<<<< DBMS BACKGROUND PROCESSOR STATE CHECK STARTED >>>>>>>>>>>>>>" >> ./daily_chk_$SID_$nDATE.txt
echo " " >> ./daily_chk_$SID_$nDATE.txt
ps -ef | grep ora_ | grep $ORACLE_SID >> ./daily_chk_$SID_$nDATE.txt

##### 그리드 서비스 체크
echo " " >> ./daily_chk_$SID_$nDATE.txt
echo "<<<<<<<<<<<<<< ORACLE GRID SERVICES STATE CHECK >>>>>>>>>>>>>>" >> ./daily_chk_$SID_$nDATE.txt
$GRID_HOME/bin/crsctl stat res -t >> ./daily_chk_$SID_$nDATE.txt

##### 리스너 서비스 체크
echo " " >> ./daily_chk_$SID_$nDATE.txt
echo "<<<<<<<<<<<<<< DBMS LISTENER STATE CHECK STARTED >>>>>>>>>>>>>>" >> ./daily_chk_$SID_$nDATE.txt
# $ORACLE_HOME/bin/lsnrctl status $DB_LSNR >> ./daily_chk_$SID_$nDATE.txt
$GRID_HOME/bin/lsnrctl status $DB_LSNR >> ./daily_chk_$SID_$nDATE.txt
echo " " >> ./daily_chk_$SID_$nDATE.txt
echo "<<<<<<<<<<<<<< Grid LISTENER STATE CHECK STARTED >>>>>>>>>>>>>>" >> ./daily_chk_$SID_$nDATE.txt
$GRID_HOME/bin/lsnrctl status $ASM_LSNR >> ./daily_chk_$SID_$nDATE.txt

##### 디스크 사용률 체크
echo " " >> ./daily_chk_$SID_$nDATE.txt
echo "<<<<<<<<<<<<<< OS DISK Usage CHECK STARTED >>>>>>>>>>>>>>" >> ./daily_chk_$SID_$nDATE.txt
echo " " >> ./daily_chk_$SID_$nDATE.txt
df -k >> ./daily_chk_$SID_$nDATE.txt

###### DB 성능 체크
sqlplus / as sysdba << EOF >> ./daily_chk_$SID_$nDATE.txt
start $nPATH/check.sql
EOF

###### 쉘 종료 알림
SHELL_END_TIME=`date "+%H:%M:%S"`
echo "[${SHELL_END_TIME}] Shell has been stoped~!"