Oracle_RAC数据库GI的PSU升级(112040到112048)

1、oracle.rac 数据库 gi 的 psu 升级(11.2.0.4.0 到 11.2o4.8)本次演示为升级oracle rac数据库，用gi的psu升级，从11.2.0.4.0升级到11.2.0.4.8。 演示环境：两个节点:racl> rac2gi 的 psu 升级包(11.204.8)： p21352635_112040_linux-x86-64.zip解压缩后的目录：/setup/oracleup/21523375grid 0<$grid_home： /u01/app/11.2.0/gridoracle 的$oracle_home： /u01/app/oracle/pr

2、oduct/11.2.0/db_l:升级 opatch下载最新的opatch程序并替换gi_home和oracle_home下的opatch目录注意：racl和rac2两个节点的grid和oracle都要升级opatch版本 到opatch目录下:oracleracl db_l $ pwd/u01/app/oracle/product/11.2.0/db_l备份之前的opatch目录：oracleracl db_l $ mv opatch/ opatch_20151116/解压缩下载的最新的opatch版木：oracleracl db_l$ unzip p6880880_112000_linu

3、x-x86-64.zip查看opatch版本，己升级到最新的11.2.0.3.12版本 oracleracl db_l $ cd opatch/ oracleracl opatch $ ./opatch versionopatch version: 11.2.0.3.12opatch succeeded二：生成ocm文件在racl和rac2分别生成ocm.rsp文件。 oracleracl psu$ pwd /uol/app/oracle/psu oracleracl psu$ /u01/app/oracle/product/11.2.0/db_l/opatch/ocm/bin/emocmrs

4、poracleracl psu$ isocm.rsp三：给grid_home安装补丁1> racl：root用户执行rootracl # /u01/app/11.2.0/grid/opatch/opatch auto /setup/oraclellp/21523375 -oh/u01/app/11.2.0/grid/ -ocmrf/uol/app/oracle/psu/ocm.rspexecuting /uol/app/11.2.o/grid/perl/bin/perl /u01/app/11.2.0/grid/opatch/crs/patchll203.pl-patchdir /set

5、up/oracleup -patchn 21523375 -oh /u01/app/11.2.0/grid/ -ocmrf/uol/app/oracle/psu/ocm.rsp -paramfile /u01/app/11.2.0/grid/crs/install/crsconfig_paramsthis is the main log file: /u01/app/11.2.0/grid/cfgtoollogs/opatchauto2015-ll-16_15-39-09.logthis file will show your detected configuration and all th

6、e steps that opatchauto attempted to do on your system:/u01/app/ll.2.0/grid/cfgtoollogs/opatchauto2015-ll-16_15-39-09.report jog2015-11-16 15:39:09: starting clusterware patch setupusing configuration parameter file: /u01/app/11.2.0/grid/crs/install/crsconfig_paramsstopping crs.stopped crs successfu

7、llyapply successful for home apply successful for home apply successful for home/u01/app/11.2.0/grid/u01/app/11.2.0/grid/u01/app/11.2.0/gridpatch /setup/oracleup/21523375/21352635patch /setup/oracleup/21523375/21352649patch /setup/oracleup/21523375/21352642starting crs.in stalling trace file an alyz

8、ercrs-4123: oracle high availability services has been started.opatch auto succeeded.2、上述执行完毕后，再在rac2±执行：root用户执行rootrac2 # /u01/app/11.2.0/grid/opatch/opatch auto /setup/oracleup/21523375 -oh/u01/app/11.2.0/grid/ -ocmrf /uol/app/oracle/psu/ocm.rsp四：给db home安装补丁集1、 racl：root用户执行rootracl # /u01/

9、app/oracle/product/11.2.0/db_l/opatch/opatch auto/setup/oracleup/21523375 -oh /u01/app/oracle/product/11.2.0/db_l -ocmrf /uol/app/oracle/psu/ocm.rspexecuting /u01/app/11.2.0/grid/perl/bin/perl /u01/app/oracle/product/11.2.0/db_l/opatch/crs/patchll203.pl -patchdir /setup/oraclellp -patchn 21523375 -o

10、h /u01/app/oracle/product/11.2.0/db_l -ocmrf /uol/app/oracle/psu/ocm.rsp -paramfile /u01/app/11.2.0/grid/crs/install/crsconfig_paramsthis is the main log file:/u01/app/oracle/product/11.2.0/db_l/c fgtoollogs/opatchauto2015-ll-16_16-31-45.logthis file will show your detected configuration and all the

11、 steps that opatchauto attempted to do on your system:/u01/app/oracle/product/ll.2.0/db_l/cfgtoollogs/opatchauto2015-ll-16_16-31-45.report.log2015-11-16 16:31:45: starting clusterware patch setupusing configuration parameter file: /u01/app/11.2.0/grid/crs/install/crsconfig_paramsstopping rac /u01/ap

12、p/oracle/product/11.2.0/db_l.stopped rac /u01/app/oracle/product/11.2.0/db_l successfullypatch /setup/oraclellp/21523375/21352635 apply successful for home /u01/app/oracle/product/11.2.0/db_lpatch /setup/oraclellp/21523375/21352649/custom/server/21352649 apply successful for home /u01/app/oracle/pro

13、duct/11.2.0/db_lstarting rac /u01/app/oracle/product/11.2.0/db_l.started rac /u01/app/oracle/product/11.2.0/db_l successfullyopatch auto succeeded2、上述执行完毕后，再在rac2±执行：root用户执行rootrac2 # /u01/app/oracle/product/11.2.0/db_l/opatch/opatch auto /setup/oracleup/21523375 -oh /u01/app/oracle/product/11

14、.2.0/db_l -ocmrf /uol/app/oracle/psu/ocm.rsp五：更新dbaegistry_history视图信息oracleracl $ sqlplus / as sysdbasql> ?/rdbms/admin/catbundle.sql psu apply确认升级后的dba_registry_history视图：sql> select actionomments from registry$history;actioncommentsapplypatchset 11.2.0.2.0applypsu 11.2.0.4.82 rows selected.

15、六：检查gi及oracle版本査看racl和rac2两个节点的gi和oracle版本，下面以racl为例 查看gi版本，已升级至ij 11.2.0.4.8roraclc*racl oratchjf pwd /uol/app/u 2 o/gr i d/opatch (crac1«<racl oeatchls ./opatch lsinventory oracle interfb paten installer version 11.2.0.3.12 copyright (c) 201$. oracle corporation all rights reserved.oracle

16、hcmc: /u0l/app/ll.2.0/9r1dcemral inventory : /uol/app/oraxnvtntoryfroo: /u0l/app/ll.2.0/gr1d/orainst. locofatch version : 11.2.0.3.12oui 11.2 o 4 olc9 1le location : /uol/app/ll.2.0/gr1d/cfgtoollo9s/opatch/opatch20l5-ll-l66-25-l6pm.l. loglslrwentory output file location : /uol/app/11.2.0/gr 1 d/cfgt

17、ool 1 ogs/opatch/1 $ 1 nv/1 $ 1 nventory201 -11-16u6-2s-16pm. txtlocal machine information:hostnaoe: racl.locndooudnaftu platfora 1d: 226 a*u platfora description: linux x8664tnet 11top- i0v0i pr/wlurt (1) ?oracle grid infrastructure ila11.2.0.4.0there are 1 products installed 1n this oracle home.im

18、«r 1a patches (1):patch 213s2642: applied on mon nov 16 ls:s2:ie cst 201sunique patch xo： 19203841 patch description:patch sttcreated on 5 sep 2015. 00:03:11 0ug f 17510275. 17376318, 17696s47, 18185024, 17070158,21369858. 17203009, 17699423.18168684. 1747s94617172303, 20140148. 1748«76

19、71;t17363999,update : 111.2.0.4. (213s2642)m hrs pstbpdr16318126. 1772177s. 1891s417. 176)6008.19690653,17611362,1815s334, 18143006.18610j07, 1716424. 19919907, 1742s14s.175036051905318218321597 20681968patch 211s2649: applied on mon nov 16 15:$o:47 cst 201$unique patch xo： 192o3s41patch description

20、: "ocw patch set update : 11.2.0.4.1 (21352m9) created on 2 sep 2015, 23:43:49 hrs pstspotbugs fixed:查看oracle版本，已升级到11.2.0.4.8oracle now centra) inventoryofac<h version:/uol/app/orac1e/product/l1.2.0/db.l:/uol/app/orainventory:/uol/app/oracle/prcxluct/11.2.0/db.l/orairot.loc:11.2.0. 3.12lora

21、cieracl oratenjs pwd /u01/app/oraclt/product/11.2.o/db 1/opatch ora()e«racl oratchh ./opatch lsinventory oracle interla ratch installer version 11.2.0.3.12 copyright (c) 201s. oracle corpcratlon al) rights reserved.oui vertians 11.7.0.4.0loa file location : /uol/叩p/orm2/prodxt/ll20/db/“gt8l1ogs

22、/op"th/ophch2015ll16j6 6-12imj. loglsimentory output file location : /uol/app/orac 1 «/pr(xluct/ii.2.0/db/cfgtoollogs/opatch/1 s 1 nv? lllh5emory2015-ll-16.16u6-12pm.txt local machine information:hostnam： racl. localdonalnamu hatfor226amu flatfora description: linux x8664installed top-level products (1):oracle database llg11.2.0.4.0there are 1 products installed in this oracle nornt.patch 213s2649: applied on mon nov 16 16:40:16 cst 201spatch id： 19203841 description: *'ocw