[SHELL] 쉘 스크립트_프로세스 상태 확인

☎ 스크립트 내용

오라클 Listener 프로세스 상태 확인하여 실행중이면 running 기록, stop되어 있으면 start 후 상태 확인 스크립트

 

1. 스크립트 내용

#!/bin/bash

#LISTENER=/ora_engine/product/11.2.0.4/db_1/bin/lsnrctl

LOG_FILE=/home/ora11g/test/listener_check.log

check=`ps -ef | grep 'tnslsnr' | sed -n '1p' | awk '{print $8}'`

DATE=`date +%Y-%m-%d_%H:%M:%S`

if [[ "$check" == *tns* ]];
  then
        echo "----------------------------------------" >> $LOG_FILE
        echo ${DATE} "LISTENER IS RUNNING"              >> $LOG_FILE
        echo "----------------------------------------" >> $LOG_FILE
   else
        echo "----------------------------------------" >> $LOG_FILE
        echo ${DATE} "LISTENER IS STOP"                 >> $LOG_FILE
        echo "----------------------------------------" >> $LOG_FILE
        echo ${DATE} "LISTENER IS RESTART"              >> $LOG_FILE
        echo "----------------------------------------" >> $LOG_FILE
        lsnrctl start DB11G                             >> $LOG_FILE
        sleep 3
        lsnrctl status DB11G                            >> $LOG_FILE
fi

 

2. 결과값

- 현재 리스너 실행 중일때

----------------------------------------
2023-03-09_11:11:03 LISTENER IS RUNNING
----------------------------------------

- 리스너가 stop 되었을때

----------------------------------------
2023-03-09_00:55:01 LISTENER IS STOP
----------------------------------------
2023-03-09_00:55:01 LISTENER IS RESTART
----------------------------------------

LSNRCTL for Linux: Version 11.2.0.4.0 - Production on 09-MAR-2023 00:55:01

Copyright (c) 1991, 2013, Oracle.  All rights reserved.

TNS-01106: Listener using listener name DB11G has already been started

LSNRCTL for Linux: Version 11.2.0.4.0 - Production on 09-MAR-2023 00:55:05

Copyright (c) 1991, 2013, Oracle.  All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.56.111)(PORT=2525)))
STATUS of the LISTENER
------------------------
Alias                     DB11G
Version                   TNSLSNR for Linux: Version 11.2.0.4.0 - Production
Start Date                07-MAR-2023 09:08:01
Uptime                    1 days 15 hr. 47 min. 3 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   /ora_engine/product/11.2.0.4/db_1/network/admin/listener.ora
Listener Log File         /ora_engine/diag/tnslsnr/oraclevm/db11g/alert/log.xml
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.56.111)(PORT=2525)))
Services Summary...
Service "ORA11G" has 1 instance(s).
  Instance "ORA11G", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully
----------------------------------------