oracle10.2.0.1升级到10.2.0.5.docx

Redhat 5.5 Oracle RAC 数据库 从10.2.0.1升级到 10.2.0.5到metalink上下载p8202632_10205_LINUX.zip补丁，上传到服务器。下面进行升级：1.停止RACOracleb87 $ srvctl stop database -d racdboracleb87 $ srvctl stop asm -n b87oracleb87 $ srvctl stop asm -n b88oracleb87 $ srvctl stop listener -n b87oracleb87 $ srvctl stop listener -n b88oracleb87 $ crs_stat -tName Type Target State Host-ora.SM1.asm application OFFLINE OFFLINEora.87.lsnr application OFFLINE OFFLINEora.b87.gsd application ONLINE ONLINE b87ora.b87.ons application ONLINE ONLINE b87ora.b87.vip application ONLINE ONLINE b87ora.SM2.asm application OFFLINE OFFLINEora.88.lsnr application OFFLINE OFFLINEora.b88.gsd application ONLINE ONLINE b88ora.b88.ons application ONLINE ONLINE b88ora.b88.vip application ONLINE ONLINE b88ora.racdb.db application OFFLINE OFFLINEora.b1.inst application OFFLINE OFFLINEora.b2.inst application OFFLINE OFFLINE2.解压包unzip p8202632_10205_LINUX.ziprootb87 opt# cd Disk1/rootb87 Disk1# lsinstall patch_note.htm response runInstaller stage3.开始升级clusterwareoracleb87 Disk1$ ./runInstallerStarting Oracle Universal Installer.Checking installer requirements.Checking operating system version: must beRedHat-3,SUSE-9, SuSE-10, redhat-4, redhat-5, redhat-6, UnitedLinux-1.0, asianux-1,asianux-2, asianux-3, enterprise-4, enterprise-5 or SuSE-11PassedAll installer requirements met.Preparing to launch Oracle Universal Installer from/tmp/OraInstall2012-12-25_02-26-20PM. Please wait .oracleb87 Disk1$ OracleUniversal Installer, Version 10.2.0.5.0 ProductionCopyright (C) 1999, 2010, Oracle. All rights reserved.欢迎界面，选择NEXT这里注意，现在我们是升级CLUSTERWARE集群软件，选择相应的目录（CRS_HOME）看清楚，不要选择（ORACLE_HOME），选好后NEXT.保持默认，next检测环境，通过后，next，我在这一步报内核参数不对，按照提示修改相关参数即可，最后别忘记sysctlp.安装之前的概要，选择安装。安装进行中，持续30分钟左右。安装结束，提示在所有节点运行脚本：先在第一个节点上运行：rootb87 # /opt/u01/Oracle/product/crs/bin/crsctlstop crsStopping resources.Successfully stopped CRS resourcesStopping CSSD.Shutting down CSS daemon.Shutdown request successfully issued.rootb87 #/opt/u01/oracle/product/crs/install/root102.shCreating pre-patch directory for saving pre-patchclusterware filesCompleted patching clusterware files to/opt/u01/oracle/product/crsRelinking some shared libraries.Relinking of patched files is complete.WARNING: directory /opt/u01/oracle/product is notowned by rootWARNING: directory /opt/u01/oracle is not owned byrootWARNING: directory /opt/u01 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 andEVMR=49897.node : node 1: b87 b87-priv b87Creating OCR keys for user root, privgrp root.Operation successful.clscfg -upgrade completed successfullyCreating/opt/u01/oracle/product/crs/install/paramfile.crs with data used for CRSconfigurationSetting CRS configuration values in/opt/u01/oracle/product/crs/install/paramfile.crs在第二个节点上运行：rootb88 # /opt/u01/oracle/product/crs/bin/crsctlstop crsStopping resources.Successfully stopped CRS resourcesStopping CSSD.Shutting down CSS daemon.Shutdown request successfully issued.rootb88 #/opt/u01/oracle/product/crs/install/root102.shCreating pre-patch directory for saving pre-patchclusterware filesCompleted patching clusterware files to/opt/u01/oracle/product/crsRelinking some shared libraries.Relinking of patched files is complete.WARNING: directory /opt/u01/oracle/product is notowned by rootWARNING: directory /opt/u01/oracle is not owned byrootWARNING: directory /opt/u01 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 takea 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 andEVMR=49897.node : node 2: b88 b88-priv b88Creating OCR keys for user root, privgrp root.Operation successful.clscfg -upgrade completed successfullyCreating/opt/u01/oracle/product/crs/install/paramfile.crs with data used for CRSconfigurationSetting CRS configuration values in /opt/u01/oracle/product/crs/install/paramfile.crs到此clusterware升级完成，crs已经重启，下面我们开始升级数据库软件。4.升级database software在升级clusterware的时候，升级结束的时候会启动CRS服务。但是在升级数据库的时候要关闭这些服务，命令如下（以下关闭命令也是正常关闭RAC的方法）：oracleb88 $ srvctl stop database -d racdboracleb88 $ srvctl stop service -d racdboracleb88 $ srvctl stop asm -n b87oracleb88 $ srvctl stop asm -n b88oracleb88 $ srvctl stop listener -n b87oracleb88 $ srvctl stop listener -n b88开始升级数据库软件，还是运行补丁包下的runInstalleroracleb87 Disk1$ ./runInstallerStarting Oracle Universal Installer.Checking installer requirements.Checking operating system version: must beRedHat-3,SUSE-9, SuSE-10, redhat-4, redhat-5, redhat-6, UnitedLinux-1.0, asianux-1,asianux-2, asianux-3, enterprise-4, enterprise-5 or SuSE-11PassedAll installer requirements met.Preparing to launch Oracle Universal Installer from/tmp/OraInstall2012-12-25_03-19-06PM. Please wait .oracleb87 Disk1$ OracleUniversal Installer, Version 10.2.0.5.0 ProductionCopyright (C) 1999, 2010, Oracle. All rights reserved.首先出来欢迎界面，next。像升级CLUSTERWARE一样，这一步注意选择Oracle_home，next。默认是让你加入metalink,我这里不选，next。保持默认即可，next。检测环境，next。安装前的概要文件，选择install.升级过程中，持续30分钟左右。安装完成，提示在所有节点用root执行脚本。在节点1上执行：rootb87 # /opt/u01/Oracle/product/10.2.0.1/root.shRunning Oracle 10g root.sh script.The following environment variables are set as:ORACLE_OWNER= oracleORACLE_HOME= /opt/u01/oracle/product/10.2.0.1Enter 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: yCopyingdbhome to /usr/local/bin .The file oraenv already exists in/usr/local/bin. Overwrite it? (y/n)n: yCopyingoraenv to /usr/local/bin .The file coraenv already exists in/usr/local/bin. Overwrite it? (y/n)n: yCopyingcoraenv to /usr/local/bin .Entries will be added to the /etc/oratab file asneeded byDatabase Configuration Assistant when a database iscreatedFinished running generic part of root.sh script.Now product-specific root actions will be performed.在节点2上执行rootb88 # /opt/u01/oracle/product/10.2.0.1/root.shRunning Oracle 10g root.sh script.The following environment variables are set as:ORACLE_OWNER= oracleORACLE_HOME= /opt/u01/oracle/product/10.2.0.1Enter 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: yCopyingdbhome to /usr/local/bin .The file oraenv already exists in/usr/local/bin. Overwrite it? (y/n)n: yCopyingoraenv to /usr/local/bin .The file coraenv already exists in/usr/local/bin. Overwrite it? (y/n)n: yCopyingcoraenv to /usr/local/bin .Entries will be added to the /etc/oratab file asneeded byDatabase Configuration Assistant when a database iscreatedFinished running generic part of root.sh script.Now product-specific root actions will be performed.到此，数据库软件的升级完成。下面开始升级数据库（这里数据库是指库文件）。5.升级database先启动相关应用（启动ASM,监听即可，实例可以不启动。如果使用脚本升级，实例需要启动到nomount,我们这里介绍使用DBUA进行升级，DBUA会帮助我们启动实例，我们不需要干预）。启动ASM和监听Oracleb88 $ srvctl start asm -n b87oracleb88 $ srvctl start asm -n b88oracleb88 $ srvctl start listener -n b87oracleb88 $ srvctl start listener -n b88oracleb88 $ crs_stat -t -vName Type R/RA F/FT Target State Host-ora.SM1.asm application 0/5 0/0 ONLINE ONLINE b87ora.87.lsnr application 0/5 0/0 ONLINE ONLINE b87ora.b87.gsd application 0/5 0/0 ONLINE ONLINE b87ora.b87.ons application 0/3 0/0 ONLINE ONLINE b87ora.b87.vip application 0/0 0/0 ONLINE ONLINE b87ora.SM2.asm application 0/5 0/0 ONLINE ONLINE b88ora.88.lsnr application 0/5 0/0 ONLINE ONLINE b88ora.b88.gsd application 0/5 0/0 ONLINE ONLINE b88ora.b88.ons application 0/3 0/0 ONLINE ONLINE b88ora.b88.vip application 0/0 0/0 ONLINE ONLINE b88ora.racdb.db application 0/1 0/1 OFFLINE OFFLINEora.b1.inst application 0/5 0/0 OFFLINE OFFLINEora.b2.inst application 0/5 0/0 OFFLINE OFFLINE在一个节点上运行dbua即可：oracleb87 Disk1$ dbua欢迎界面，next。选择Upgrade a database,next.输入sys和密码，next。这里是选择是否编译无效对象，以及选择用多少个CPU来进行并行编译无效对象。从而加快编译速度，我们服务器是虚拟化只配了2个CPU，这里我们选2，下面是询问是否在编译时关闭归档，因为在编译的时候数据库会产生很多日志，这时候如果是归档，会影响速度，我们选择关闭归档（等数据库升级完成后，归档会自动开启）。指定闪回区，next。安装前的概要，finish.升级过程中，持续1个小时左右。到此数据库的升级完成，下面我们进行验证。验证：Oracleb87 $ sqlplus /nologSQL*Plus: Release 10.2.0.5.0 - Production on Tue Dec25 18:23:07 2012Copyright (c) 1982, 2010, Oracle. All Rights Reserved.SQL conn / as sysdbaConnected.SQL set line 150 pages 1000SQL select * from gv$instance;INST_IDINSTANCE_NUMBER INSTANCE_NAME HOST_NAME VERSION STARTUP_TIME- - - -STATUS PAR THREAD# ARCHIVE LOG_SWITCH_WAIT LOGINS SHU DATABASE_STATUS INSTANCE_ROLE ACTIVE_ST BLO- - - - - - - - - -1 1 racdb1 b87 10.2.0.5.0 25-DEC-12OPEN YES 1 STARTED ALLOWED NO ACTIVE PRIMARY_INSTANCE NORMAL NO2 2 racdb2 b88 10.2.0.5.0 25-DEC-12OPEN YES 2 STARTED ALLOWED NO ACTIVE PRIMARY_INSTANCE NORMAL NOSQL colstatus for a10SQL col version