[ORACLE] HA start/stop Script (Linux)

## START script

vi ora_start.sh

#!/bin/ksh su - oracle << EOF lsnrctl start listener exit EOF su - oracle << EOF export ORACLE_SID=PHARMS sqlplus "/as sysdba" << EOF startup exit EOF

 

## STOP  script

vi ora_stop.sh

#!/bin/ksh su - oracle << EOF lsnrctl stop listener EOF su - oracle << EOF export ORACLE_SID=PHARMS sqlplus "/as sysdba" << EOF shutdown immediate exit EOF

-- 확인

# ps -ef | grep pmon

oracle    5094     1  0 01:34 ?        00:00:00 ora_pmon_ABCD

root      5165  2722  0 01:34 pts/1    00:00:00 grep pmon

 

# ps -ef | grep tns

root        29     2  0 Nov11 ?        00:00:00 [netns]

oracle    5068     1  0 01:34 ?        00:00:00 /u01/base/product/11.2.0.4/bin/tnslsnr listener -inherit

root      5167  2722  0 01:34 pts/1    00:00:00 grep tns