论坛徽章:: 0

电梯直达

1楼 [收藏(0)] [报告]

发表于 2006-06-06 09:32 |只看该作者 |倒序浏览

aix 5.3+ha5.1+oracle10g做了个双机，为了实现oracle的接管要用到oracle10g的启动停止脚本，发现oracle的bin目录下有现成的dbstart和dbshut脚本，不知是不是可以用这二个脚本？我执行它们没反应，不知要做什么改动？
--------------------------------------------------------------------------------
要实现接管时的自动停止与启动oracle

谢谢，以下是脚本：
dbstart:
# cat dbstart
:
#
# $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
# rc.local only. Otherwise, the CSS service may not be available
# yet, and this script will block init from completing the boot
# cycle.
#
# Note:
# Use ORACLE_TRACE=T for tracing this script.
#
# The progress log for each instance bringup plus Error and Warning message
# are logged in file $ORACLE_HOME/startup.log. The error messages related to
# instance bringup are also logged to syslog (system log module).
# The Listener log is located at $ORACLE_HOME_LISTNER/listener.log
#
# To configure:
# 1) Set ORATAB:
# On Solaris
#    ORATAB=/var/opt/oracle/oratab
# All other UNIX platforms
#    ORATAB=/etc/oratab
#
# 2) Update $ORATAB/oratab with Database Instances that need to be started up.
# Entries are of the form:
# $ORACLE_SIDORACLE_HOME:<N|Y>:
# An example entry:
# main:/usr/lib/oracle/emagent_10g:Y
#
# 3) Set ORACLE_HOME_LISTNER
# Set this to enable auto startup for Oracle Net Listener.
# The script uses this find the binary to start Net Listener.
#
# Also, if the listener name is not the default name LISTENER, you must
# specify the listener name in the stop and start commands:
# $ORACLE_HOME/bin/lsnrctl {start|stop} listener_name
#
#####################################

LOGMSG="logger -puser.alert -s "

trap 'exit' 1 2 3

# for script tracing
case $ORACLE_TRACE in
T) set -x ;;
esac

# Set path if path not set (if called from /etc/rc)
case $PATH in
"") PATH=/bin:/usr/bin:/etc
      export PATH ;;
esac

# Save LD_LIBRARY_PATH
SAVE_LLP=$LD_LIBRARY_PATH

# Set this to bring up Oracle Net Listener
ORACLE_HOME_LISTNER=/ade/vikrkuma_new/oracle
if [ ! $ORACLE_HOME_LISTNER ] ; then
  echo "ORACLE_HOME_LISTNER is not SET, unable to auto-start Oracle Net Listener"
else
  LOG=$ORACLE_HOME_LISTNER/listener.log

  # Start Oracle Net Listener
  if [ -f $ORACLE_HOME_LISTNER/bin/tnslsnr ] ; then
echo "$0: Starting Oracle Net Listener" >> $LOG 2>&1
$ORACLE_HOME_LISTNER/bin/lsnrctl start >> $LOG 2>&1 &
export VER10LIST=`$ORACLE_HOME_LISTNER/bin/lsnrctl version | grep "LSNRCTL for " | cut -d' ' -f5 | cut -d'.' -f1`
  else
echo "Failed to auto-start Oracle Net Listene using $ORACLE_HOME_LISTNER/bin/tnslsnr"
  fi
fi

# Set this in accordance with the platform
ORATAB=/etc/oratab
if [ ! $ORATAB ] ; then
  echo "Set ORATAB to dir where oratab file is located"
  exit 1;
fi

# Checks Version Mismatch between Listener and Database Instance.
# A version 10 listener is required for an Oracle Database 10g database.
# Previous versions of the listener are not supported for use with an Oracle
# Database 10g database. However, it is possible to use a version 10 listener
# with previous versions of the Oracle database.
checkversionmismatch() {
  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 10g"
      $LOGMSG "Version $VER10LIST for Listener is NOT supported with Database version $VER10INST"
      $LOGMSG "Restart Oracle Net Listener using an alternate ORACLE_HOME_LISTNER: lsnrctl start"
   fi
   ;;
   *) ;;
esac
  fi
}

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

  # Put $ORACLE_HOME/bin into PATH and export.
  PATH=$ORACLE_HOME/bin:/bin:/usr/bin:/etc ; export PATH
  # add for bug # 652997
  LD_LIBRARY_PATH=${SAVE_LLP}{ORACLE_HOME}/lib ; export LD_LIBRARY_PATH
  PFILE=${ORACLE_HOME}/dbs/init${ORACLE_SID}.ora
  SPFILE=${ORACLE_HOME}/dbs/spfile${ORACLE_SID}.ora
  SPFILE1=${ORACLE_HOME}/dbs/spfile.ora

  echo ""
  echo "$0: Starting up database \"$ORACLE_SID\""
  date
  echo ""

  checkversionmismatch

  # See if it is a V6 or V7 database
  VERSION=undef
  if [ -f $ORACLE_HOME/bin/sqldba ] ; then
SQLDBA=sqldba
VERSION=`$ORACLE_HOME/bin/sqldba command=exit | awk '
   /SQL\*DBA: (Release|Version)/ {split($3, V, ".") ;
   print V[1]}'`
case $VERSION in
   "6") ;;
   *) VERSION="internal" ;;
esac
  else
if [ -f $ORACLE_HOME/bin/svrmgrl ] ; then
   SQLDBA=svrmgrl
   VERSION="internal"
else
   SQLDBA="sqlplus /nolog"
fi
  fi

  STATUS=1
  if [ -f $ORACLE_HOME/dbs/sgadef${ORACLE_SID}.dbf ] ; then
STATUS="-1"
  fi
  if [ -f $ORACLE_HOME/dbs/sgadef${ORACLE_SID}.ora ] ; then
STATUS="-1"
  fi
  pmon=`ps -ef | egrep pmon_$ORACLE_SID  | grep -v grep`
  if [ "$pmon" != "" ];
  then
STATUS="-1"
$LOGMSG "Warning: ${INST} \"${ORACLE_SID}\" already started."
  fi

  if test $STATUS -eq -1 ; then
$LOGMSG "Warning: ${INST} \"${ORACLE_SID}\" possibly left running when system went down (system crash?)."
$LOGMSG "Action: Notify Database Administrator."
case $VERSION in
   "6")  sqldba "command=shutdown abort" ;;
   "internal")  $SQLDBA $args <<EOF
connect internal
shutdown abort
EOF
      ;;
   *)  $SQLDBA $args <<EOF
connect / as sysdba
shutdown abort
quit
EOF
      ;;
esac

if test $? -eq 0 ; then
   STATUS=1
else
   $LOGMSG "Error: ${INST} \"${ORACLE_SID}\" NOT started."
fi
  fi

  if test $STATUS -eq 1 ; then
if [ -f $SPFILE -o -f $SPFILE1 -o -f $PFILE ] ; then
   case $VERSION in
      "6")  sqldba command=startup ;;
      "internal")  $SQLDBA <<EOF
connect internal
startup
EOF
      ;;
      *)  $SQLDBA <<EOF
connect / as sysdba
startup
quit
EOF
      ;;
   esac

   if test $? -eq 0 ; then
      echo ""
      echo "$0: ${INST} \"${ORACLE_SID}\" warm started."
   else
      $LOGMSG ""
      $LOGMSG "Error: ${INST} \"${ORACLE_SID}\" NOT started."
   fi
else
   $LOGMSG ""
   $LOGMSG "Can't find init file for ${INST} \"${ORACLE_SID}\"."
   $LOGMSG "Error: ${INST} \"${ORACLE_SID}\" NOT started."
fi
  fi
}

# Starts an ASM Instance
startasminst() {
  # Called programs use same database ID
  export ORACLE_SID
  ORACLE_HOME=`echo $LINE | awk -F: '{print $2}' -`
  # Called scripts use same home directory
  export ORACLE_HOME

  # For ASM instances, we have a dependency on the CSS service.
  # Wait here for it to become available before instance startup.

  # Is the 10g install intact? Are all necessary binaries present?
  if [ ! -f $ORACLE_HOME/bin/crsctl ]; then
$LOGMSG "$ORACLE_HOME/bin/crsctl not found when attempting to start"
$LOGMSG "  ASM instance $ORACLE_SID."

  else
COUNT=0
$ORACLE_HOME/bin/crsctl check css
RC=$?
while [ "$RC" != "0" ];
do
COUNT=$((COUNT+1))
if [ $COUNT = 15 ] ; then
   # 15 tries with 20 sec interval => 5 minutes timeout
   $LOGMSG "Timed out waiting to start ASM instance $ORACLE_SID"
   $LOGMSG "  CSS service is NOT available."
   exit $COUNT
fi
$LOGMSG "Waiting for Oracle CSS service to be available before starting "
$LOGMSG " ASM instance $ORACLE_SID. Wait $COUNT."

sleep 20
$ORACLE_HOME/bin/crsctl check css
RC=$?
done
  fi
  startinst
}

# Start of dbstartup script
#
# Loop for every entry in oratab file and and try to start
# that ORACLE.
#
# ASM instances need to be started before 'Database instances'
# ASM instance is identified with '+' prefix in ORACLE_SID
# Following loop brings up ASM instance

cat $ORATAB | while read LINE
do
case $LINE in
  \#*)             ;;       #comment-line in oratab
  *)
  # Proceed only if last field is 'Y'.
  # Entries whose last field is not Y or N are not DB entry, ignore them.
  if [ "`echo $LINE | awk -F: '{print $NF}' -`" = "Y" ] ; then
ORACLE_SID=`echo $LINE | awk -F: '{print $1}' -`
if [ "$ORACLE_SID" = '*' ] ; then
   # same as NULL SID - ignore this entry
   ORACLE_SID=""
   continue
fi
# For ASM instances, we have a dependency on the CSS service.
# Wait here for it to become available before instance startup.
if [ `echo $ORACLE_SID | cut -b 1` = '+' ]; then
   INST="ASM instance"
   ORACLE_HOME=`echo $LINE | awk -F: '{print $2}' -`
   # Called scripts use same home directory
   export ORACLE_HOME
   # file for logging script's output
   LOG=$ORACLE_HOME/startup.log
   touch $LOG
   chmod a+r $LOG
   echo "rocessing $INST \"$ORACLE_SID\": log file $ORACLE_HOME/startup.log"
   startasminst >> $LOG 2>&1
fi
  fi
  ;;
esac
done

# exit if there was any trouble bringing up ASM instance
if [ "$?" != "0" ] ; then
  exit 2
fi

#
# Following loop brings up 'Database instances'
#
cat $ORATAB | while read LINE
do
case $LINE in
  \#*)             ;;       #comment-line in oratab
  *)
  # Proceed only if last field is 'Y'.
  # Entries whose last field is not Y or N are not DB entry, ignore them.
  if [ "`echo $LINE | awk -F: '{print $NF}' -`" = "Y" ] ; then
ORACLE_SID=`echo $LINE | awk -F: '{print $1}' -`
if [ "$ORACLE_SID" = '*' ] ; then
   # same as NULL SID - ignore this entry
   ORACLE_SID=""
   continue
fi
# For ASM instances, we have a dependency on the CSS service.
# Wait here for it to become available before instance startup.
if [ `echo $ORACLE_SID | cut -b 1` != '+' ]; then
   INST="Database instance"
   ORACLE_HOME=`echo $LINE | awk -F: '{print $2}' -`
   # Called scripts use same home directory
   export ORACLE_HOME
   # file for logging script's output
   LOG=$ORACLE_HOME/startup.log
   touch $LOG
   chmod a+r $LOG
   echo "rocessing $INST \"$ORACLE_SID\": log file $ORACLE_HOME/startup.log"
   startinst >> $LOG 2>&1
fi
  fi
  ;;
esac
done

dbshut:# cat dbshut
:
#
# $Id: dbshut.sh.pp 11-may-2005.19:37:00 vikrkuma Exp $
# Copyright (c) 1991, 2005, Oracle. All rights reserved.
#

###################################
#
# usage: dbshut
#
# This script is used to shutdown ORACLE from /etc/rc(.local).
# It should ONLY be executed as part of the system boot procedure.
#
# This script will shutdown 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 +.
#
# Note:
# Use ORACLE_TRACE=T for tracing this script.
# Oracle Net Listener is NOT shutdown using this script.
#
# The progress log for each instance shutdown is logged in file
# $ORACLE_HOME/shutdown.log.
#
# To configure:
# 1) Set ORATAB:
# On Solaris
#    ORATAB=/var/opt/oracle/oratab
# All other UNIX platforms
#    ORATAB=/etc/oratab
#
# 2) Update $ORATAB/oratab with Database Instances that need to be shutdown.
# Entries are of the form:
# $ORACLE_SIDORACLE_HOME:<N|Y>:
# An example entry:
# main:/usr/lib/oracle/emagent_10g:Y
#
#####################################

trap 'exit' 1 2 3
case $ORACLE_TRACE in
T) set -x ;;
esac

# Set path if path not set (if called from /etc/rc)
case $PATH in
  "") PATH=/bin:/usr/bin:/etc
   export PATH ;;
esac

# Save LD_LIBRARY_PATH
SAVE_LLP=$LD_LIBRARY_PATH

# Set this in accordance with the platform
ORATAB=/etc/oratab
if [ ! $ORATAB ] ; then
  echo "Set ORATAB to dir where oratab file is located"
  exit 1;
fi

# Stops an instance
stopinst() {
  ORACLE_SID=`echo $LINE | awk -F: '{print $1}' -`
  if [ "$ORACLE_SID" = '*' ] ; then
ORACLE_SID=""
  fi
# Called programs use same database ID
  export ORACLE_SID
  ORACLE_HOME=`echo $LINE | awk -F: '{print $2}' -`
# Called scripts use same home directory
  export ORACLE_HOME
# Put $ORACLE_HOME/bin into PATH and export.
  PATH=$ORACLE_HOME/bin:/bin:/usr/bin:/etc ; export PATH
# add for bug 652997
  LD_LIBRARY_PATH=${SAVE_LLP}{ORACLE_HOME}/lib ; export LD_LIBRARY_PATH
  PFILE=${ORACLE_HOME}/dbs/init${ORACLE_SID}.ora

# See if it is a V6 or V7 database
  VERSION=undef
  if [ -f $ORACLE_HOME/bin/sqldba ] ; then
SQLDBA=sqldba
VERSION=`$ORACLE_HOME/bin/sqldba command=exit | awk '
   /SQL\*DBA: (Release|Version)/ {split($3, V, ".") ;
   print V[1]}'`
case $VERSION in
   "6") ;;
   *) VERSION="internal" ;;
esac
  else
if [ -f $ORACLE_HOME/bin/svrmgrl ] ; then
   SQLDBA=svrmgrl
   VERSION="internal"
else
   SQLDBA="sqlplus /nolog"
fi
  fi

  case $VERSION in
"6")  sqldba command=shutdown ;;
"internal")  $SQLDBA <<EOF
connect internal
shutdown immediate
EOF
   ;;
   *)  $SQLDBA <<EOF
connect / as sysdba
shutdown immediate
quit
EOF
   ;;
  esac

  if test $? -eq 0 ; then
echo "${INST} \"${ORACLE_SID}\" shut down."
  else
echo "${INST} \"${ORACLE_SID}\" not shut down."
  fi
}

#
# Loop for every entry in oratab file and and try to shut down
# that ORACLE
#
# Following loop shuts down 'Database Instance'

cat $ORATAB | while read LINE
do
  case $LINE in
\#*)             ;;       #comment-line in oratab
*)
# Proceed only if last field is 'Y'.
# Entries whose last field is not Y or N are not DB entry, ignore them.
if [ "`echo $LINE | awk -F: '{print $NF}' -`" = "Y" ] ; then
   ORACLE_SID=`echo $LINE | awk -F: '{print $1}' -`
   if [ "$ORACLE_SID" = '*' ] ; then
      # NULL SID - ignore
      ORACLE_SID=""
      continue
   fi
if [ `echo $ORACLE_SID | cut -b 1` != '+' ]; then
   INST="Database instance"
   ORACLE_HOME=`echo $LINE | awk -F: '{print $2}' -`
   LOG=$ORACLE_HOME/shutdown.log
   stopinst >> $LOG 2>&1
fi
  fi
  ;;
  esac
done

#
# Following loop shuts down 'ASM Instance'
#

cat $ORATAB | while read LINE
do
  case $LINE in
\#*)             ;;       #comment-line in oratab
*)
# Proceed only if last field is 'Y'.
# Entries whose last field is not Y or N are not DB entry, ignore them.
if [ "`echo $LINE | awk -F: '{print $NF}' -`" = "Y" ] ; then
   ORACLE_SID=`echo $LINE | awk -F: '{print $1}' -`
   if [ "$ORACLE_SID" = '*' ] ; then
      # NULL SID - ignore
      ORACLE_SID=""
      continue
   fi
if [ `echo $ORACLE_SID | cut -b 1` = '+' ]; then
   INST="ASM instance"
   ORACLE_HOME=`echo $LINE | awk -F: '{print $2}' -`
   LOG=$ORACLE_HOME/shutdown.log
   stopinst >> $LOG 2>&1
fi
  fi
  ;;
  esac
done