Oracle dbstart 无法正常启动处理办法
Oracle dbstart 无法正常启动处理办法
[oracle@CentOS-1 ~]$ dbstart
ORACLE_HOME_LISTNER is not SET, unable to auto-start Oracle Net Listener
Usage: /u01/app/oracle/product/12.1.0/dbhome_1/bin/dbstart ORACLE_HOME
修改dbstart以及dbshut两个文件
"/u01/app/oracle/product/12.1.0/dbhome_1/bin/dbstart"
# First argument is used to bring up Oracle Net Listenerexport ORACLE_HOME_LISTNER=$ORACLE_HOME#ORACLE_HOME_LISTNER=$1if [ ! $ORACLE_HOME_LISTNER ] ; then
echo "ORACLE_HOME_LISTNER is not SET, unable to auto-start Oracle Net Listener"
echo "Usage: $0 ORACLE_HOME"
else
LOG=$ORACLE_HOME_LISTNER/listener.log
# Set the ORACLE_HOME for the Oracle Net Listener, it gets reset to
# a different ORACLE_HOME for each entry in the oratab.
export ORACLE_HOME=$ORACLE_HOME_LISTNER
注释掉红色部分,添加蓝色部分代码
[oracle@centos-1 ~]$ vi /u01/app/oracle/product/12.1.0/dbhome_1/bin/dbshut
# The this to bring down Oracle Net Listenerexport ORACLE_HOME_LISTNER=$ORACLE_HOME#ORACLE_HOME_LISTNER=$1if [ ! $ORACLE_HOME_LISTNER ] ; then
echo "ORACLE_HOME_LISTNER is not SET, unable to auto-stop Oracle Net Listener"
echo "Usage: $0 ORACLE_HOME"
else
LOG=$ORACLE_HOME_LISTNER/listener.log
# Set the ORACLE_HOME for the Oracle Net Listener, it gets reset to
# a different ORACLE_HOME for each entry in the oratab.
export ORACLE_HOME=$ORACLE_HOME_LISTNER
# Stop Oracle Net Listener
if [ -f $ORACLE_HOME_LISTNER/bin/tnslsnr ] ; then
echo "$0: Stoping Oracle Net Listener" >> $LOG 2>&1
$ORACLE_HOME_LISTNER/bin/lsnrctl stop >> $LOG 2>&1 &
else
echo "Failed to auto-stop Oracle Net Listener using $ORACLE_HOME_LISTNER/bin/tnslsnr"
fi
fi
重试后命令不出错,但是无反应
$su root
修改 /etc/oratab
orcl:/u01/app/oracle/product/12.1.0/dbhome_1:N
修改成
orcl:/u01/app/oracle/product/12.1.0/dbhome_1:Y
重试成功
--------------------------------------分割线 --------------------------------------
--------------------------------------分割线 --------------------------------------