Oracle配置开机自启

启动脚本start_oracle.sh

#!/bin/bash

set -e
[[ -f ~/.bash_profile ]] && source ~/.bash_profile
if ! lsnrctl status | grep "The command completed successfully" &> /dev/null;then
    lsnrctl start
    echo "startup" | sqlplus / as sysdba
else
    if ! echo "select status from v\$instance;" | sqlplus / as sysdba | grep -w '^OPEN$' &> /dev/null;then
        echo "startup" | sqlplus / as sysdba
    fi
fi

if echo "select status from v\$instance;" | sqlplus / as sysdba | grep -w '^OPEN$';then
    echo "INFO:Start Oracle Success"
else
    echo "ERROR:Start Oracle Fail"
fi

添加开机自启任务

echo 'bash start_oracle.sh' >> /etc/rc.d/rc.local
chmod +x /etc/rc.d/rc.local