Oracle Start/Shutdown script

DB 인스턴스  : orcl
Oracle owner : oracle

다운로드:
dbora
startup.sh
shutdown.sh

1. /etc/oratab 파일을 아래와 같이 편집한다.

# Entries are of the form:
#   $ORACLE_SID:$ORACLE_HOME:<N|Y>:
orcl:/opt/oracle/12.1.0:Y
2. 아래의 스크립트를 root 권한으로 실행한다.
/etc/rc.d/init.d/dbora

---

/home/oracle/scripts/startup.sh

#!/bin/bash
export TMP=/tmp
export TMPDIR=$TMP
export ORACLE_BASE=/opt/oracle
export LANG=ko_KR.UTF-8
export NLS_LANG=AMERICAN_AMERICA.UTF8
export ORA_NLS33=${ORACLE_HOME}/ocommon/nls/admin/data
export ORACLE_HOME=${ORACLE_BASE}/11g
export ORACLE_HOME_LISTNER=${ORACLE_HOME}
export ORACLE_HOSTNAME=localhost
export ORACLE_TERM=xterm
export PATH=/usr/sbin:${ORACLE_HOME}/bin:${PATH}:/usr/local/bin
LD_LIBRARY_PATH=${ORACLE_HOME}/lib:/lib:/usr/lib
LD_LIBRARY_PATH=${LD_LIBRARY_PATH}:/usr/local/lib
export LD_LIBRARY_PATH
# Start Listener
echo "    Starting lsnrctl…"
lsnrctl start
# Start Database
export ORACLE_SID=orcl
echo "    Starting ${ORACLE_SID} Database…"
sqlplus / as sysdba << EOF
STARTUP;
EXIT;
EOF

---

/home/oracle/scripts/shutdown.sh

#!/bin/bash
export TMP=/tmp
export TMPDIR=$TMP
export ORACLE_BASE=/opt/oracle
export LANG=ko_KR.UTF-8
export NLS_LANG=AMERICAN_AMERICA.UTF8
export ORA_NLS33=${ORACLE_HOME}/ocommon/nls/admin/data
export ORACLE_HOME=${ORACLE_BASE}/11g
export ORACLE_HOME_LISTNER=${ORACLE_HOME}
export ORACLE_HOSTNAME=localhost
export ORACLE_TERM=xterm
export PATH=/usr/sbin:${ORACLE_HOME}/bin:${PATH}:/usr/local/bin
LD_LIBRARY_PATH=${ORACLE_HOME}/lib:/lib:/usr/lib
LD_LIBRARY_PATH=${LD_LIBRARY_PATH}:/usr/local/lib
export LD_LIBRARY_PATH
# Stop Database
export ORACLE_SID=orcl
echo "    Shutting down ${ORACLE_SID} Database..."
sqlplus / as sysdba << EOF
SHUTDOWN IMMEDIATE;
EXIT;
EOF
sleep 1
# Stop Listener
echo "    Shutting down lsnrctl…"
lsnrctl stop