Oracle RAC 10.2.0.1升级至10.2.0.4操作笔记

============================================================
Oracle® Database 10g Release 2 （10.2.0） RAC for RedHat4
Oracle Rac 10.2.0.1升级至10.2.0.4
============================================================
升级集群件-滚动升级升级数据库软件-停用后升级升级数据库共计耗时5小时Orz... 第一部分：集群件滚动升级【OUI crs_home】 1、系统环境操作系统版本[10:42:13oracle@node1 ~]uname -aLinux node1 2.6.9-78.ELsmp #1 SMP Wed Jul 9 15:46:26 EDT 2008 x86_64 x86_64 x86_64 GNU/Linux[10:42:17oracle@node1 ~] 集群件版本[10:42:18oracle@node1 ~]crsctl query crs softwareversionCRS software version on node [node1] is [10.2.0.1.0][10:42:27oracle@node1 ~] 数据库版本[10:43:08oracle@node1 ~]sqlplus / as sysdba SQL*Plus: Release 10.2.0.1.0 - Production on Fri May 28 10:43:11 2010Copyright （c） 1982, 2005, Oracle. All rights reserved. Connected to:Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bit ProductionWith the Partitioning, Real Application Clusters, OLAP and Data Mining options SYS@NODE1:null1>select * from v$version; BANNER----------------------------------------------------------------Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64biPL/SQL Release 10.2.0.1.0 - ProductionCORE 10.2.0.1.0 ProductionTNS for Linux: Version 10.2.0.1.0 - ProductionNLSRTL Version 10.2.0.1.0 - Production 集群状态[10:44:55oracle@node1 ~]crs_stat -tName Type Target State Host------------------------------------------------------------ora.dba.db application ONLINE ONLINE node1ora....name.cs application ONLINE ONLINE node1ora....ll1.srv application ONLINE ONLINE node2ora....l1.inst application ONLINE ONLINE node1ora....l2.inst application ONLINE ONLINE node2ora.dba.rac.cs application ONLINE ONLINE node1ora....ll1.srv application ONLINE ONLINE node1ora....ll2.srv application ONLINE ONLINE node2ora....SM1.asm application ONLINE ONLINE node1ora....E1.lsnr application ONLINE ONLINE node1ora.node1.gsd application ONLINE ONLINE node1ora.node1.ons application ONLINE ONLINE node1ora.node1.vip application ONLINE ONLINE node1ora....SM2.asm application ONLINE ONLINE node2ora....E2.lsnr application ONLINE ONLINE node2ora.node2.gsd application ONLINE ONLINE node2ora.node2.ons application ONLINE ONLINE node2ora.node2.vip application ONLINE ONLINE node2 2、关闭节点1 关闭节点1 dbconsole[11:14:47oracle@node1 db_1]emctl stop dbconsoleTZ set to PRCOracle Enterprise Manager 10g Database Control Release 10.2.0.1.0Copyright （c） 1996, 2005 Oracle Corporation. All rights reserved.http://node1.wang.com:1158/em/console/aboutApplicationStopping Oracle Enterprise Manager 10g Database Control ...... Stopped. 关闭节点1 isqlplus[11:15:03oracle@node1 db_1]isqlplusctl stopiSQL*Plus 10.2.0.1.0Copyright （c） 2003, 2005, Oracle. All rights reserved.getnameinfo failedgetnameinfo failedgetnameinfo failedgetnameinfo failediSQL*Plus instance on port 5560 is not running ... 关闭节点1 instance[11:15:26oracle@node1 db_1]srvctl stop instance -d dba -i null1 ============================================================Name Type Target State Host------------------------------------------------------------ora.dba.db application ONLINE ONLINE node1ora....name.cs application ONLINE ONLINE node1ora....ll1.srv application ONLINE ONLINE node2ora....l1.inst application OFFLINE OFFLINEora....l2.inst application ONLINE ONLINE node2ora.dba.rac.cs application ONLINE ONLINE node1ora....ll1.srv application ONLINE OFFLINEora....ll2.srv application ONLINE ONLINE node2ora....SM1.asm application ONLINE ONLINE node1ora....E1.lsnr application ONLINE ONLINE node1ora.node1.gsd application ONLINE ONLINE node1ora.node1.ons application ONLINE ONLINE node1ora.node1.vip application ONLINE ONLINE node1ora....SM2.asm application ONLINE ONLINE node2ora....E2.lsnr application ONLINE ONLINE node2ora.node2.gsd application ONLINE ONLINE node2ora.node2.ons application ONLINE ONLINE node2ora.node2.vip application ONLINE ONLINE node2============================================================ 关闭节点1 ASM[11:17:22oracle@node1 db_1]srvctl stop asm -n node1 ============================================================Name Type Target State Host------------------------------------------------------------ora.dba.db application ONLINE ONLINE node1ora....name.cs application ONLINE ONLINE node1ora....ll1.srv application ONLINE ONLINE node2ora....l1.inst application OFFLINE OFFLINEora....l2.inst application ONLINE ONLINE node2ora.dba.rac.cs application ONLINE ONLINE node1ora....ll1.srv application ONLINE OFFLINEora....ll2.srv application ONLINE ONLINE node2ora....SM1.asm application OFFLINE OFFLINEora....E1.lsnr application ONLINE ONLINE node1ora.node1.gsd application ONLINE ONLINE node1ora.node1.ons application ONLINE ONLINE node1ora.node1.vip application ONLINE ONLINE node1ora....SM2.asm application ONLINE ONLINE node2ora....E2.lsnr application ONLINE ONLINE node2ora.node2.gsd application ONLINE ONLINE node2ora.node2.ons application ONLINE ONLINE node2ora.node2.vip application ONLINE ONLINE node2============================================================ 关闭节点1 NODEAPPS[11:18:27oracle@node1 db_1]srvctl stop nodeapps -n node1 ============================================================Name Type Target State Host------------------------------------------------------------ora.dba.db application ONLINE ONLINE node2ora....name.cs application ONLINE ONLINE node2ora....ll1.srv application ONLINE ONLINE node2ora....l1.inst application OFFLINE OFFLINEora....l2.inst application ONLINE ONLINE node2ora.dba.rac.cs application ONLINE ONLINE node2ora....ll1.srv application ONLINE OFFLINEora....ll2.srv application ONLINE ONLINE node2ora....SM1.asm application OFFLINE OFFLINEora....E1.lsnr application OFFLINE OFFLINEora.node1.gsd application OFFLINE OFFLINEora.node1.ons application OFFLINE OFFLINEora.node1.vip application OFFLINE OFFLINEora....SM2.asm application ONLINE ONLINE node2ora....E2.lsnr application ONLINE ONLINE node2ora.node2.gsd application ONLINE ONLINE node2ora.node2.ons application ONLINE ONLINE node2ora.node2.vip application ONLINE ONLINE node2============================================================ 3、升级节点1 集群件 [11:23:39oracle@node1 oracle_linux_64]unzip p6810189_10204_Linux-x86-64.zip [11:23:58oracle@node1 Disk1]./runInstaller To complete the installation of this patchset, you must perform the following tasks on each node: 1.Log in as the root user.2.As the root user, perform the following tasks: a.Shutdown the CRS daemons by issuing the following command:/u01/app/oracle/product/10.2.0/crs/bin/crsctl stop crsb.Run the shell script located at:/u01/app/oracle/product/10.2.0/crs/install/root102.shThis script will automatically start the CRS daemons on thepatched node upon completion. 3.After completing this procedure, proceed to the next node and repeat. [11:31:04root@node1 ~]crsctl stop crsStopping resources.Successfully stopped CRS resourcesStopping CSSD.Shutting down CSS daemon.Shutdown request successfully issued. [11:31:27root@node1 ~]/u01/app/oracle/product/10.2.0/crs/install/root102.shCreating pre-patch directory for saving pre-patch clusterware filesCompleted patching clusterware files to /u01/app/oracle/product/10.2.0/crsRelinking some shared libraries. Relinking of patched files is complete.WARNING: directory "/u01/app/oracle/product/10.2.0" is not owned by rootWARNING: directory "/u01/app/oracle/product" is not owned by rootWARNING: directory "/u01/app/oracle" is not owned by rootWARNING: directory "/u01/app" is not owned by rootWARNING: directory "/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./etc/profile: line 55: ulimit: max user processes: cannot modify limit: Operation not permittedStarting up the CRS daemons.Waiting for the patched CRS daemons to start.This may take a while on some systems..10204 patch successfully applied.clscfg: EXISTING configuration version 3 detected.clscfg: version 3 is 10G Release 2.Successfully accumulated necessary OCR keys.Using ports: CSS=49895 CRS=49896 EVMC=49898 and EVMR=49897.node <nodenumber>: <nodename> <private interconnect name> <hostname>node 1: node1 node1-priv node1Creating OCR keys for user "root", privgrp "root"..Operation successful.clscfg -upgrade completed successfully[11:35:41root@node1 ~]============================================================Name Type Target State Host------------------------------------------------------------ora.dba.db application ONLINE ONLINE node2ora....name.cs application ONLINE ONLINE node2ora....ll1.srv application ONLINE ONLINE node2ora....l1.inst application ONLINE ONLINE node1ora....l2.inst application ONLINE ONLINE node2ora.dba.rac.cs application ONLINE ONLINE node2ora....ll1.srv application ONLINE ONLINE node1ora....ll2.srv application ONLINE ONLINE node2ora....SM1.asm application ONLINE ONLINE node1ora....E1.lsnr application ONLINE ONLINE node1ora.node1.gsd application ONLINE ONLINE node1ora.node1.ons application ONLINE ONLINE node1ora.node1.vip application ONLINE ONLINE node1ora....SM2.asm application ONLINE ONLINE node2ora....E2.lsnr application ONLINE ONLINE node2ora.node2.gsd application ONLINE ONLINE node2ora.node2.ons application ONLINE ONLINE node2ora.node2.vip application ONLINE ONLINE node2============================================================ 4、关闭节点2[11:42:41root@node1 ~]su - oracle[11:42:43oracle@node1 db_1]ssh node2Last login: Thu May 27 11:14:50 2010 from node2.wang.com 关闭节点2 dbconsole[11:42:45oracle@node2 ~]emctl stop dbconsoleTZ set to PRCOracle Enterprise Manager 10g Database Control Release 10.2.0.1.0Copyright （c） 1996, 2005 Oracle Corporation. All rights reserved.http://node1.wang.com:1158/em/console/aboutApplicationStopping Oracle Enterprise Manager 10g Database Control ...... Stopped.[11:43:05oracle@node2 ~] 关闭节点2 isqlplus[11:43:07oracle@node2 ~]isqlplusctl stopiSQL*Plus 10.2.0.1.0Copyright （c） 2003, 2005, Oracle. All rights reserved.getnameinfo failedgetnameinfo failedgetnameinfo failedgetnameinfo failediSQL*Plus instance on port 5560 is not running ... 关闭节点2 instance[11:43:37oracle@node2 ~]srvctl stop instance -d dba -i null2============================================================Name Type Target State Host------------------------------------------------------------ora.dba.db application ONLINE ONLINE node2ora....name.cs application ONLINE ONLINE node2ora....ll1.srv application ONLINE ONLINE node1ora....l1.inst application ONLINE ONLINE node1ora....l2.inst application OFFLINE OFFLINEora.dba.rac.cs application ONLINE ONLINE node2ora....ll1.srv application ONLINE ONLINE node1ora....ll2.srv application ONLINE OFFLINEora....SM1.asm application ONLINE ONLINE node1ora....E1.lsnr application ONLINE ONLINE node1ora.node1.gsd application ONLINE ONLINE node1ora.node1.ons application ONLINE ONLINE node1ora.node1.vip application ONLINE ONLINE node1ora....SM2.asm application ONLINE ONLINE node2ora....E2.lsnr application ONLINE ONLINE node2ora.node2.gsd application ONLINE ONLINE node2ora.node2.ons application ONLINE ONLINE node2ora.node2.vip application ONLINE ONLINE node2============================================================ 关闭节点2 ASM[11:45:25oracle@node2 ~]srvctl stop asm -n node2============================================================Name Type Target State Host------------------------------------------------------------ora.dba.db application ONLINE ONLINE node2ora....name.cs application ONLINE ONLINE node2ora....ll1.srv application ONLINE ONLINE node1ora....l1.inst application ONLINE ONLINE node1ora....l2.inst application OFFLINE OFFLINEora.dba.rac.cs application ONLINE ONLINE node2ora....ll1.srv application ONLINE ONLINE node1ora....ll2.srv application ONLINE OFFLINEora....SM1.asm application ONLINE ONLINE node1ora....E1.lsnr application ONLINE ONLINE node1ora.node1.gsd application ONLINE ONLINE node1ora.node1.ons application ONLINE ONLINE node1ora.node1.vip application ONLINE ONLINE node1ora....SM2.asm application OFFLINE OFFLINEora....E2.lsnr application ONLINE ONLINE node2ora.node2.gsd application ONLINE ONLINE node2ora.node2.ons application ONLINE ONLINE node2ora.node2.vip application ONLINE ONLINE node2============================================================ 关闭节点2 NODEAPPS[11:46:45oracle@node2 ~]srvctl stop nodeapps-n node2============================================================Name Type Target State Host------------------------------------------------------------ora.dba.db application ONLINE ONLINE node2ora....name.cs application ONLINE ONLINE node2ora....ll1.srv application ONLINE ONLINE node1ora....l1.inst application ONLINE ONLINE node1ora....l2.inst application OFFLINE OFFLINEora.dba.rac.cs application ONLINE ONLINE node2ora....ll1.srv application ONLINE ONLINE node1ora....ll2.srv application ONLINE OFFLINEora....SM1.asm application ONLINE ONLINE node1ora....E1.lsnr application ONLINE ONLINE node1ora.node1.gsd application ONLINE ONLINE node1ora.node1.ons application ONLINE ONLINE node1ora.node1.vip application ONLINE ONLINE node1ora....SM2.asm application OFFLINE OFFLINEora....E2.lsnr application OFFLINE OFFLINEora.node2.gsd application OFFLINE OFFLINEora.node2.ons application OFFLINE OFFLINEora.node2.vip application OFFLINE OFFLINE

Oracle 11.2.0.2新特性—用户重命名（Rename User）Linux上安装配置InstantClient及64位系统PL/SQL配置相关资讯 Oracle RAC Oracle升级

Oracle RAC 更换存储实验（今 06:38）
Oracle 10g（10.2.0.4）升级到10.2.0 （04月10日）
11.2.04 Oracle RAC 目录中（12/21/2015 15:10:42）

Oracle升级中的参数补充（05月31日）
升级Oracle 11.2.0.1.0到11.2.0.3. （01月12日）
Oracle 11.2.0.1升级到11.2.0.3 （11/27/2015 09:21:45）

本文评论查看全部评论（0）

评论声明

尊重网上道德，遵守中华人民共和国的各项有关法律法规