Welcome 微信登录

首页 / 数据库 / MySQL / 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重试成功--------------------------------------分割线 --------------------------------------在CentOS 6.4下安装Oracle 11gR2(x64) http://www.linuxidc.com/Linux/2014-02/97374.htmOracle 11gR2 在VMWare虚拟机中安装步骤 http://www.linuxidc.com/Linux/2013-09/89579p2.htmDebian 下 安装 Oracle 11g XE R2 http://www.linuxidc.com/Linux/2014-03/98881.htm--------------------------------------分割线 --------------------------------------更多Oracle相关信息见Oracle 专题页面 http://www.linuxidc.com/topicnews.aspx?tid=12本文永久更新链接地址