Oracle补丁6810189升级过程(RAC+ASM)

1数据库环境:RAC+ASMOracleDatabase10gEnterpriseEditionRelease10.2.0.1.0-ProdPL/SQLRelease10.2.0.1.0-ProductionCORE10.2.0.1.0ProductionTNSforLinux:Version10.2.0.1.0-ProductionNLSRTLVersion10.2.0.1.0–ProductionOS:RedHatEnterpriseLinuxASrelease4(Nahant)NameTypeTargetStateHost------------------------------------------------------------ora....B1.instapplicationONLINEONLINEnode1ora....B2.instapplicationONLINEONLINEnode2ora.RACDB.dbapplicationONLINEONLINEnode2ora....SM1.asmapplicationONLINEONLINEnode1ora....E1.lsnrapplicationONLINEONLINEnode1ora.node1.gsdapplicationONLINEONLINEnode1ora.node1.onsapplicationONLINEONLINEnode1ora.node1.vipapplicationONLINEONLINEnode1ora....SM2.asmapplicationONLINEONLINEnode2ora....E2.lsnrapplicationONLINEONLINEnode2ora.node2.gsdapplicationONLINEONLINEnode2ora.node2.onsapplicationONLINEONLINEnode2ora.node2.vipapplicationONLINEONLINEnode2升级前任务1.p6810189_10204_Linux-x86包下载6810189安装包，上传p6810189_10204_Linux-x86.zip到node1,并unzipp6810189_10204_Linux-x86.zip2.UpdateOracleTimeZoneDefinitions如果数据库中使用了TIMESTAMPWITHLOCALTIMEZONE(TSLTZ)andTIMESTAMPWITHTIME2ZONE(TSTZ)需要阅读该步骤来进行数据处理。ForfulloverviewpleaseseeOracleMetaLinkdocument553812.1ActionsfortheDSTv4updateinthe10.2.0.4patchset.1.Whenpatchingfromalower10.2releaseorupgradingfrom10.1.0.Xdirectlyto10.2.0.4,checkthecurrentversionoftheOracletimezonedefinitionswiththefollowingcommand:2.SELECTversionFROMv$timezone_file;oIfthisqueryreportsversion4,noactionisrequired;inthiscase,continuewithstepsdescribedinsection7.6.oIfthisreportsaversionlowerorhigherthen4,seeOracleMetalinkdocument553812.1ActionsfortheDSTv4updateintheRelease10.2.0.4patchset.3.OnupgradingfromRelease9idirectlytoRelease10.2.0.4,seeOracleMetaLinkdocument553812.1ActionsfortheDSTv4updateinthe10.2.0.4patchset.4.OnupgradingfromRelease8.1.7directlytoRelease10.2.0.4,noactionisrequiredbecauseRelease8.1.7hasnotimezonedatastored;inthiscasecontinuewithstepsdescribedinsection7.6document553812.1ActionsfortheDSTv4updateintheRelease10.2.0.4patchset中内容如下：1A)whenpatchingfromalower10.2.0.Xreleaseto10.2.0.4orupgradingfrom10.1.0.Xdirectlyto10.2.0.4CheckthecurrentversionoftheOracletimezonedefinitionsSQLconn/assysdbaConnected.SQLSELECTversionFROMv$timezone_file;VERSION----------4Ifthisreportsaversion4thenthereisnoactiontotakefortheOracletimezonedefinitions,apply10.2.0.4orupgradefrom10.1to10.2.0.4withoutanyactiononTSLTZorTSTZdata.Followtheupgradeorpatchsetapplyinstructions,youcanskipanyDSTrelatedsections.Ifthisreportsatimezoneversionhigherthen4pleaseseepoint2)inthisnote.Ifthisreportsatimezoneversionlowerthen4pleaseseepoint3)inthisnote.33)Ifyourcurrenttimezoneversionislowerthan4.3B)whenupgradingfrom10.1.0.xorupdatingalower10.2.0.Xversionto10.2.0.4.Checkifyouarestoring*user*TZ(TSTZandTSLTZ)datausethissqlquery:selectc.owner||'.'||c.table_name||'('||c.column_name||')-'||c.data_type||''colfromdba_tab_colsc,dba_objectsowherec.data_typelike'%TIMEZONE'andc.owner=o.ownerandc.table_name=o.object_nameando.object_type='TABLE'orderbycol/CheckifthereissomethingoutsidetheDataDictionary(=otherthenSYSorWMSYSobjects).Forthesysobjects,checkifyouareusingDBMS_SCHEDULERforscheduler$_jobandsoonThestandardoracleprovided10gusageofTZdatainDBMS_SCHEDULERisnotcritical,theOracleprovidedjobsdon'tdependonbeingexecutedonaexacthour.具体见：文档－[ID553812.1].htm3.SettheORACLE_HOMEandORACLE_SIDEnvironmentVariables$ORACLE_HOME=Oracle_home$ORACLE_SID=sid$exportORACLE_HOMEORACLE_SID4.StopAllProcessesStoppingAllProcessesforaSingleInstanceInstallationStoppingAllProcessesforanOracleClusterwareInstallation(RollingUpgrade、NonRollingUpgrade)StoppingAllProcessesforanOracleRACInstallation本例采用NonRollingUpgrade的升级方式4NonRollingUpgradeFornonrollingupgrade,OracleClusterwareneedstobeshutdowncompletely.Completethefollowingsteps:1.ShutdownallprocessesintheOraclehomeoneachnodethatmightbeaccessingadatabase,forexampleOracleEnterpriseManagerDatabaseControloriSQL*Plus:$emctlstopdbconsole$isqlplusctlstop2.ShutdownallservicesintheOraclehomeoneachnodethatmightbeaccessingadatabase:$srvctlstopservice-ddb_name[-sservice_name_list[-iinst_name]]srvctlstopservice-dRACDB3.ShutdownallOracleRACinstancesonallclusternodesbyenteringthefollowingcommandwheredb_nameisthenameofthedatabase:$srvctlstopdatabase-dRACDB4.IfAutomaticStorageManagementinstanceispresent,thenshutdownAutomaticStorageManagementinstancesonallclusternodesbyenteringthefollowingcommandwherenodeisthenameofthenodewheretheAutomaticStorageManagementinstanceisrunning:$srvctlstopasm-nnode5.Stopallnodeapplicationsonallclusternodesbyenteringthefollowingcommandastherootuser,wherenodeisthenameofthenodewheretheapplicationsarerunning:#srvctlstopnodeapps-nnode[oracle@node1admin]$crs_stat-tNameTypeTargetStateHost------------------------------------------------------------ora....B1.instapplicationOFFLINEOFFLINEora....B2.instapplicationOFFLINEOFFLINEora.RACDB.dbapplicationOFFLINEOFFLINE5ora....SM1.asmapplicationOFFLINEOFFLINEora....E1.lsnrapplicationOFFLINEOFFLINEora.node1.gsdapplicationOFFLINEOFFLINEora.node1.onsapplicationOFFLINEOFFLINEora.nod