Oracle RAC 10.2.0.1升级到10.2.0.5-实战记录.doc

/view/284b2f0c844769eae009ed9d.html#升级 crs*停止RACemctl stop dbconsole/oracle/product/crs/bin/srvctl stop instance -d racdb -i racdb1/oracle/product/crs/bin/srvctl stop instance -d racdb -i racdb2/oracle/product/crs/bin/srvctl stop asm -n rac1/oracle/product/crs/bin/srvctl stop asm -n rac2/oracle/product/crs/bin/srvctl stop nodeapps -n rac1/oracle/product/crs/bin/srvctl stop nodeapps -n rac2su -cd /oracle/product/crs/bin./crsctl stop crscd Disk1./runInstaller点击Next修改Name为已安装CRS_HOME，如OraCrs10g_Home点Next选择两个node，点Next安装配置检查，通过后 点Next点 Install每个节点停 crs ,然后执 root102.shrootrac1 crs# cd /oracle/product/crs/installrootrac1 install# lscluster.ini install.excl paramfile.crs readme.txt rootconfig rootdelete.sh rootupgradecmdllroot.sh install.incl patch102 root102.sh rootdeinstall.sh rootinstall templocalenvVperties make.log preupdate.sh rootaddnode.sbs rootdeletenode.sh rootlocaladdrootrac1 install# sh root102.shCreating pre-patch directory for saving pre-patch clusterware filesCompleted patching clusterware files to /oracle/product/crsRelinking some shared libraries.Relinking of patched files is complete.WARNING: directory /oracle/product is not owned by rootWARNING: directory /oracle is not owned by rootPreparing to recopy patched init and RC scripts.Recopying init and RC scripts.Startup will be queued to init within 30 seconds.Starting up the CRS daemons.Waiting for the patched CRS daemons to start. This may take a while on some systems.10205 patch successfully applied.clscfg: EXISTING configuration version 3 detected.clscfg: version 3 is 10G Release 2.Successfully deleted 1 values from OCR.Successfully deleted 1 keys from OCR.Successfully accumulated necessary OCR keys.Using ports: CSS=49895 CRS=49896 EVMC=49898 and EVMR=49897.node : node 1: rac1 rac1-priv rac1Creating OCR keys for user root, privgrp root.Operation successful.clscfg -upgrade completed successfullyCreating /oracle/product/crs/install/paramfile.crs with data used for CRS configurationSetting CRS configuration values in /oracle/product/crs/install/paramfile.crsrootrac1 install#rootrac2 bin# ./crsctl stop crsStopping resources.Successfully stopped CRS resources Stopping CSSD.Shutting down CSS daemon.Shutdown request successfully issued.rootrac2 install# sh root102.sh Creating pre-patch directory for saving pre-patch clusterware filesCompleted patching clusterware files to /oracle/product/crsRelinking some shared libraries.Relinking of patched files is complete.WARNING: directory /oracle/product is not owned by rootWARNING: directory /oracle is not owned by rootPreparing to recopy patched init and RC scripts.Recopying init and RC scripts.Startup will be queued to init within 30 seconds.Starting up the CRS daemons.Waiting for the patched CRS daemons to start. This may take a while on some systems.10205 patch successfully applied.clscfg: EXISTING configuration version 3 detected.clscfg: version 3 is 10G Release 2.Successfully deleted 1 values from OCR.Successfully deleted 1 keys from OCR.Successfully accumulated necessary OCR keys.Using ports: CSS=49895 CRS=49896 EVMC=49898 and EVMR=49897.node : node 2: rac2 rac2-priv rac2Creating OCR keys for user root, privgrp root.Operation successful.clscfg -upgrade completed successfullyCreating /oracle/product/crs/install/paramfile.crs with data used for CRS configurationSetting CRS configuration values in /oracle/product/crs/install/paramfile.crs执行完脚本后，点Exit退出。#升级 database操作（一）登陆节点1，在节点1上（rac1）用oracle用户停止进程。emctl stop dbconsole/oracle/product/crs/bin/srvctl stop instance -d racdb -i racdb1/oracle/product/crs/bin/srvctl stop instance -d racdb -i racdb2/oracle/product/crs/bin/srvctl stop asm -n rac1/oracle/product/crs/bin/srvctl stop asm -n rac2/oracle/product/crs/bin/srvctl stop nodeapps -n rac1/oracle/product/crs/bin/srvctl stop nodeapps -n rac2或者直接执行oraclerac1 $ crs_stop -all确认服务已经停止oraclerac1 $ crs_stat -t查看两个节点的所有服务stat都是offline操作（二）在rac1的升级包目录下：oraclerac1 $cd /home/oracle/Disk1oraclerac1 $ ./runInstaller点Next点Next点Next点Continue点Next点Next点Install在两个node执行root.sh脚本操作（十）分别在两个节点上执行如下命令。提示如图所示。rootrac1 # cd /usr/local/rootrac1 # cp rf bin bin.old-备份rootrac2 #/opt/app/oracle/product/10.2.0/db_1/./root.sh-执行执行完成后在节点2上执行如下命令rootrac2 # cd /usr/local/rootrac2 # cp rf bin bin.old -备份rootrac2 #/opt/app/oracle/product/10.2.0/db_1/./root.sh-执行在执行过程需要输入必要信息：1、输入本地bin目录，选择默认，直接回车即可。2、提示要覆盖三个文件：先将两个节点上的三个文件都进行备份，然后输入Y直接覆盖。两个节点都执行完毕后，点击“确定”。rootrac1 database# ./root.shRunning Oracle 10g root.sh script.The following environment variables are set as: ORACLE_OWNER= oracle ORACLE_HOME= /oracle/product/databaseEnter the full pathname of the local bin directory: /usr/local/bin: The file dbhome already exists in /usr/local/bin. Overwrite it? (y/n) n: y Copying dbhome to /usr/local/bin .The file oraenv already exists in /usr/local/bin. Overwrite it? (y/n) n: y Copying oraenv to /usr/local/bin .The file coraenv already exists in /usr/local/bin. Overwrite it? (y/n) n: y Copying coraenv to /usr/local/bin .Entries will be added to the /etc/oratab file as needed byDatabase Configuration Assistant when a database is createdFinished running generic part of root.sh script.Now product-specific root actions will be performed.rootrac2 database# ./root.shRunning Oracle 10g root.sh script.The following environment variables are set as: ORACLE_OWNER= oracle ORACLE_HOME= /oracle/product/databaseEnter the full pathname of the local bin directory: /usr/local/bin: The file dbhome already exists in /usr/local/bin. Overwrite it? (y/n) n: y Copying dbhome to /usr/local/bin .The file oraenv already exists in /usr/local/bin. Overwrite it? (y/n) n: y Copying oraenv to /usr/local/bin .The file coraenv already exists in /usr/local/bin. Overwrite it? (y/n) n: y Copying coraenv to /usr/local/bin .Entries will be added to the /etc/oratab file as needed byDatabase Configuration Assistant when a database is createdFinished running generic part of root.sh script.Now product-specific root actions will be performed.执行完点Ok点Exit1.2.3升级数据库在升级之前需要确保CRS服务至少一个节点上已经启动，状态是ONLINE。如果没有启动，可以在任意节点执行以下命令启动CRS服务。操作（一）在节点1（rac1）上用oracle用户执行如下命令：rootrac1 # su oracleoraclerac1 $ crs_start alloraclerac1 $ crs_stat t注意：在启动的过程中会提示数据库实例无法启动，不必担心，在未执行下面脚本之前，数据实例不能启动，系统只启动集群服务。继续下面的操作oraclerac1 $ sqlplus /nologSQLCONN SYS AS SYSDBASQL STARTUP NOMOUNTSQL ALTER SYSTEM SET CLUSTER_DATABASE=FALSE SCOPE=spfile;SQL SHUTDOWN操作（二）运行升级脚本SQL STARTUP UPGRADESQL$ORACLE_HOME/rdbms/admin/catupgrd.sql #此处执行时间较长，耐心等待，测试环境上执行了约30分钟执行结果：Total Upgrade Time: 00:21:19DOC#DOC#DOCDOC The above PL/SQL lists the SERVER components in the upgradedDOC database, along with their current version and status.DOCDOC Please review the status and version columns and look forDOC any errors in the spool log file. If there are errors in the spoolDOC file, or any components are not VALID or not the current version,DOC consult the Oracle Database Upgrade Guide for troubleshootingDOC recommendations.DOCDOC Next shutdown immediate, restart for normal operation, a