#!/bin/bash
echo -e "
dba 작업을 자동화하는 쉘 스크립트
"
echo -e " ================================= "
echo " "
echo "[1] DB에서 발생한 TX 락을 확인하려면 1번을 누르세요.
[2] DB에서 발생한 악성 SQL을 확인하려면 2번을 누르세요
[3] TOP명령어로 확인한 프로세서 번호로 해당 세션의 정보를 확인하고 싶으면 3번을 누르세요
[4] sys 유져로 접속해서 db를 startup 하려면 4번을 누르세요
[5] 리스너를 시작 시키려면 5번을 누르세요
[6] alert log file을 실시간 모니터링하려면 6번을 누르세요
[7] dw 쪽의 alert log file을 실시간 모니터링 하려면 7번을 누르세요"
echo " "
echo -n "원하는 작업번호를 누르세요 "
read aa
echo " "
case $aa in
1) sqlplus -s system/oracle_4U @/home/oracle/lock.sql ;;
2) sqlplus -s system/oracle_4U @/home/oracle/bad.sql ;;
3) sqlplus -s system/oracle_4U @/home/oracle/spid.sql ;;
4) sqlplus -s sys/oracle_4U as sysdba @/home/oracle/startup.sql ;;
5) lsnrctl start ;;
6) tail -f /u01/app/oracle/diag/rdbms/oracle19/oracle19/trace/alert_oracle19.log | awk '
/[Oo][Rr][Aa]-|[Ee][Rr][Rr][Oo][Rr]|[Ff][Aa][Ii][Ll]|[Ff][Aa][Tt][Aa][Ll]|[Cc][Rr][Ii][Tt][Ii][Cc][Aa][Ll]|[Cc][Oo][Rr][Rr][Uu][Pp][Tt]|[Ii][Nn][Vv][Aa][Ll][Ii][Dd]|[Uu][Nn][Aa][Bb][Ll][Ee]|[Aa][Bb][Nn][Oo][Rr][Mm][Aa][Ll]|[Tt][Ee][Rr][Mm][Ii][Nn][Aa][Tt][Ee][Dd]|[Ss][Hh][Uu][Tt][Dd][Oo][Ww][Nn] [Aa][Bb][Oo][Rr][Tt]|[Dd][Ii][Ee][Dd]|[Kk][Ii][Ll][Ll][Ee][Dd]|[Cc][Rr][Aa][Ss][Hh][Ee][Dd]|[Dd][Ee][Aa][Dd][Ll][Oo][Cc][Kk]|[Ee][Xx][Cc][Ee][Pp][Tt][Ii][Oo][Nn]|[Pp][Aa][Nn][Ii][Cc]|[Dd][Ee][Nn][Ii][Ee][Dd]|[Tt][Ii][Mm][Ee][Oo][Uu][Tt]|[Hh][Aa][Nn][Gg]|[Ss][Tt][Uu][Cc][Kk]|[Dd][Ii][Ss][Aa][Bb][Ll][Ee][Dd]|[Rr][Ee][Ff][Uu][Ss][Ee][Dd]|[Bb][Ll][Oo][Cc][Kk][Ee][Dd]|[Ll][Oo][Ss][Tt]|[Mm][Ii][Ss][Ss][Ii][Nn][Gg]|[Ff][Uu][Ll][Ll]|[Ee][Xx][Hh][Aa][Uu][Ss][Tt][Ee][Dd]|[Oo][Uu][Tt] [Oo][Ff] [Ss][Pp][Aa][Cc][Ee]|[Nn][Oo][Tt] [Ee][Nn][Oo][Uu][Gg][Hh]|[Ii][Nn][Ss][Uu][Ff][Ff][Ii][Cc][Ii][Ee][Nn][Tt]|[Ll][Ee][Aa][Kk]|[Bb][Rr][Ee][Aa][Cc][Hh]|[Vv][Ii][Oo][Ll][Aa][Tt][Ii][Oo][Nn]/ {print "\033[1;31m" $0 "\033[0m"; next}
/[Ww][Aa][Rr][Nn][Ii][Nn][Gg]|[Tt][Hh][Rr][Ee][Ss][Hh][Oo][Ll][Dd]|[Ll][Ii][Mm][Ii][Tt]/ {print "\033[1;33m" $0 "\033[0m"; next}
/[Cc][Oo][Mm][Pp][Ll][Ee][Tt][Ee][Dd]|[Ss][Tt][Aa][Rr][Tt][Ii][Nn][Gg]|[Oo][Pp][Ee][Nn][Ee][Dd]|[Mm][Oo][Uu][Nn][Tt][Ee][Dd]|[Ee][Nn][Aa][Bb][Ll][Ee][Dd]|[Ss][Uu][Cc][Cc][Ee][Ss][Ss]|[Rr][Ee][Cc][Oo][Vv][Ee][Rr][Ee][Dd]/ {print "\033[1;32m" $0 "\033[0m"; next}
{print}
' ;;
7) tail -f /u01/app/oracle/diag/rdbms/ora19dw/ora19dw/trace/alert_ora19dw.log | awk '
/[Oo][Rr][Aa]-|[Ee][Rr][Rr][Oo][Rr]|[Ff][Aa][Ii][Ll]|[Ff][Aa][Tt][Aa][Ll]|[Cc][Rr][Ii][Tt][Ii][Cc][Aa][Ll]|[Cc][Oo][Rr][Rr][Uu][Pp][Tt]|[Ii][Nn][Vv][Aa][Ll][Ii][Dd]|[Uu][Nn][Aa][Bb][Ll][Ee]|[Aa][Bb][Nn][Oo][Rr][Mm][Aa][Ll]|[Tt][Ee][Rr][Mm][Ii][Nn][Aa][Tt][Ee][Dd]|[Ss][Hh][Uu][Tt][Dd][Oo][Ww][Nn] [Aa][Bb][Oo][Rr][Tt]|[Dd][Ii][Ee][Dd]|[Kk][Ii][Ll][Ll][Ee][Dd]|[Cc][Rr][Aa][Ss][Hh][Ee][Dd]|[Dd][Ee][Aa][Dd][Ll][Oo][Cc][Kk]|[Ee][Xx][Cc][Ee][Pp][Tt][Ii][Oo][Nn]|[Pp][Aa][Nn][Ii][Cc]|[Dd][Ee][Nn][Ii][Ee][Dd]|[Tt][Ii][Mm][Ee][Oo][Uu][Tt]|[Hh][Aa][Nn][Gg]|[Ss][Tt][Uu][Cc][Kk]|[Dd][Ii][Ss][Aa][Bb][Ll][Ee][Dd]|[Rr][Ee][Ff][Uu][Ss][Ee][Dd]|[Bb][Ll][Oo][Cc][Kk][Ee][Dd]|[Ll][Oo][Ss][Tt]|[Mm][Ii][Ss][Ss][Ii][Nn][Gg]|[Ff][Uu][Ll][Ll]|[Ee][Xx][Hh][Aa][Uu][Ss][Tt][Ee][Dd]|[Oo][Uu][Tt] [Oo][Ff] [Ss][Pp][Aa][Cc][Ee]|[Nn][Oo][Tt] [Ee][Nn][Oo][Uu][Gg][Hh]|[Ii][Nn][Ss][Uu][Ff][Ff][Ii][Cc][Ii][Ee][Nn][Tt]|[Ll][Ee][Aa][Kk]|[Bb][Rr][Ee][Aa][Cc][Hh]|[Vv][Ii][Oo][Ll][Aa][Tt][Ii][Oo][Nn]/ {print "\033[1;31m" $0 "\033[0m"; next}
/[Ww][Aa][Rr][Nn][Ii][Nn][Gg]|[Tt][Hh][Rr][Ee][Ss][Hh][Oo][Ll][Dd]|[Ll][Ii][Mm][Ii][Tt]/ {print "\033[1;33m" $0 "\033[0m"; next}
/[Cc][Oo][Mm][Pp][Ll][Ee][Tt][Ee][Dd]|[Ss][Tt][Aa][Rr][Tt][Ii][Nn][Gg]|[Oo][Pp][Ee][Nn][Ee][Dd]|[Mm][Oo][Uu][Nn][Tt][Ee][Dd]|[Ee][Nn][Aa][Bb][Ll][Ee][Dd]|[Ss][Uu][Cc][Cc][Ee][Ss][Ss]|[Rr][Ee][Cc][Oo][Vv][Ee][Rr][Ee][Dd]/ {print "\033[1;32m" $0 "\033[0m"; next}
{print}
' ;;
esac
echo "