hpux oracle dbstart 问题

bxl1234

hpux 11.23  安装oracle 10.2.0 正常,
手动启动 oracle 正常
sqlplus '/ as sysdba'

SQL*Plus: Release 10.2.0.1.0 - Production on Wed Mar 4 10:54:07 2009

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

Connected to an idle instance.

SQL> startup
ORACLE instance started.

Total System Global Area 2550136832 bytes
Fixed Size                  2008528 bytes
Variable Size             536873520 bytes
Database Buffers         1996488704 bytes
Redo Buffers               14766080 bytes
Database mounted.
Database opened.

$  emctl start dbconsole
Oracle Enterprise Manager 10g Database Control Release 10.2.0.1.0  
Copyright (c) 1996, 2005 Oracle Corporation.  All rights reserved.
http://rp5430:1158/em/console/aboutApplication
Starting Oracle Enterprise Manager 10g Database Control ....

$ isqlplusctl start
iSQL*Plus 10.2.0.1.0
Copyright (c) 2003, 2005, Oracle.  All rights reserved.
Starting iSQL*Plus ...
.........................



但是运行dbstart 时不能启动

$ dbstart
Failed to auto-start Oracle Net Listene using /ade/vikrkuma_new/oracle/bin/tnslsnr

已修改 /etc/oratab


$ cat /etc/oratab

10g:/db/oracle/product/10.2.0:Y

cd $ORACLE_HOME/dbs
$ ls
hc_o10g.dat     initdw.ora      orapwo10g
init.ora        lkO10G          spfileo10g.ora

请教大家如何解决,谢谢

五“宅”一生

将/etc/oratab文件cp到/var/opt/oracle目录下试一下

brucewoo

具体分析一下dbstart脚本的内容

ziggler

呵呵,这是因为10g把listener的启动也加到dbstart脚本里了,只要修改 $ORACLE_HOME/bin/dbstart文件
设置环境变量
ORACLE_HOME_LISTNER
为你的$ORACLE_HOME的值

oracle10的dbstart不能启动！ - Oracle数据库管理 - ITPUB论坛 - 澳信传媒旗下专业技术社区 (6 May 2009)

http://www.itpub.net/548298.html

http://snipurl.com/hhged

bxl1234

请教4楼,

dbstart 如何设变量

# vi dbstart
"dbstart" 354 lines, 10415 characters
:
#
# $Id: dbstart.sh.pp 11-may-2005.18:18:07 vikrkuma Exp $
# Copyright (c) 1991, 2005, Oracle. All rights reserved.
#

###################################
#
# usage: dbstart
#
# This script is used to start ORACLE from /etc/rc(.local).
# It should ONLY be executed as part of the system boot procedure.
#
# This script will start all databases listed in the oratab file
# whose third field is a "Y".  If the third field is set to "Y" and
# there is no ORACLE_SID for an entry (the first field is a *),
# then this script will ignore that entry.
#
# This script requires that ASM ORACLE_SID's start with a +, and
# that non-ASM instance ORACLE_SID's do not start with a +.
#
# If ASM instances are to be started with this script, it cannot
# be used inside an rc*.d directory, and should be invoked from
? ORACLE_HOME_LISTNER
  if [ $VER10LIST ] ; then
    VER10INST=`sqlplus -V | grep "Release " | cut -d' ' -f3 | cut -d'.' -f1`
    case $VER10INST in
      "10")
      if [ $VER10LIST != "10" ] ; then
        $LOGMSG "Warning: Version 10 listener is required for Oracle Database 10
g"
        $LOGMSG "Version $VER10LIST for Listener is NOT supported with Database
version $VER10INST"
        $LOGMSG "Restart Oracle Net Listener using an alternate ORACLE_HOME_LIST
NER: lsnrctl start"
      fi
      ;;
      *) ;;
    esac
  fi
}

# Starts a Database Instance
startinst() {
  # Called programs use same database ID
  export ORACLE_SID

怎么改变量,谢谢

leelangco

怎么感觉你的dbstart有点乱呢.....