oracle没有正常启动,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

重试成功

--------------------------------------分割线 --------------------------------------

--------------------------------------分割线 --------------------------------------