Oracle 12.2.0.1单机和rac集群打最新的PSU补丁
👉 本文共约396个字，系统预计阅读时间或需2分钟。
最新的PSU补丁如下：
注意：GI PSU补丁包里已经包含了PSU，即31718723的补丁包里已经包含了31537677，所以，下载只需要下载31718723即可。
1 2 | ./obsutil cp -r obs://oracle/Linux-x86-12201/p33290750_122010_Linux-x86-64.zip /soft/ ./obsutil cp -r obs://oracle/Linux-x86-12201/p6880880_210000_Linux-x86-64.zip /soft/ |
本人提供Oracle、MySQL、PG等数据库的培训和考证业务，私聊QQ646634621或微信db_bao，谢谢！
最新的OPATCH工具下载地址：https://updates.oracle.com/download/6880880.html ，需要注意大版本的匹配。
单机DB环境
单机的DB环境直接打33261817的PSU即可。
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 | su - oracle unzip -d $ORACLE_HOME /soft/p6880880_210000_Linux-x86-64.zip cd /soft/ unzip p33290750_122010_Linux-x86-64.zip cd 33290750/33261817 $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -ph ./ shutdown immediate $ORACLE_HOME/OPatch/opatch apply chown oracle.oinstall /u01/app/oracle/product/12.2.0/dbhome_1/bin/extjobO $ORACLE_HOME/OPatch/opatch lspatches -- 更新数据库 $ORACLE_HOME/OPatch/datapatch -verbose select PATCH_ID from dba_registry_sqlpatch; @?/rdbms/admin/utlrp.sql |
rac环境
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 | -- 以下命令在每个节点都需要执行： su - grid unzip /soft/Linux-x86-12201/p6880880_210000_Linux-x86-64.zip -d $ORACLE_HOME su - oracle unzip /soft/Linux-x86-12201/p6880880_210000_Linux-x86-64.zip -d $ORACLE_HOME su - grid $ORACLE_HOME/OPatch/opatch lsinventory -detail -oh $ORACLE_HOME su - grid unzip /soft/p33290750_122010_Linux-x86-64.zip -d /soft/ su - root /u01/app/12.2.0/grid/OPatch/opatchauto apply /soft/33290750 -- 若oracle的psu没有打，则需要继续 su - oracle cd /soft/33290750/33261817 $ORACLE_HOME/OPatch/opatch apply chown oracle.oinstall /u01/app/oracle/product/12.2.0/dbhome_1/bin/extjobO -- 查询 su - grid $ORACLE_HOME/OPatch/opatch lspatches su - oracle $ORACLE_HOME/OPatch/opatch lspatches ##### 上述补丁打完之后再执行如下的db操作 -- DB $ORACLE_HOME/OPatch/datapatch -verbose select PATCH_ID from dba_registry_sqlpatch; @?/rdbms/admin/utlrp.sql select * from DBA_REGISTRY_HISTORY d; |
日志：
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 | [root@odsa ~]# /u01/app/12.2.0/grid/OPatch/opatchauto apply /soft/33290750 OPatchauto session is initiated at Wed Nov 24 19:55:30 2021 System initialization log file is /u01/app/12.2.0/grid/cfgtoollogs/opatchautodb/systemconfig2021-11-24_07-55-31PM.log. Session log file is /u01/app/12.2.0/grid/cfgtoollogs/opatchauto/opatchauto2021-11-24_07-55-50PM.log The id for this session is DHS4 Executing OPatch prereq operations to verify patch applicability on home /u01/app/12.2.0/grid Patch applicability verified successfully on home /u01/app/12.2.0/grid Executing patch validation checks on home /u01/app/12.2.0/grid Patch validation checks successfully completed on home /u01/app/12.2.0/grid Performing prepatch operations on CRS - bringing down CRS service on home /u01/app/12.2.0/grid Prepatch operation log file location: /u01/app/grid/crsdata/odsa/crsconfig/crspatch_odsa_2021-11-24_07-56-09PM.log CRS service brought down successfully on home /u01/app/12.2.0/grid Start applying binary patch on home /u01/app/12.2.0/grid Binary patch applied successfully on home /u01/app/12.2.0/grid Performing postpatch operations on CRS - starting CRS service on home /u01/app/12.2.0/grid Postpatch operation log file location: /u01/app/grid/crsdata/odsa/crsconfig/crspatch_odsa_2021-11-24_08-02-07PM.log CRS service started successfully on home /u01/app/12.2.0/grid OPatchAuto successful. --------------------------------Summary-------------------------------- Patching is completed successfully. Please find the summary as follows: Host:odsa CRS Home:/u01/app/12.2.0/grid Version:12.2.0.1.0 Summary: ==Following patches were SUCCESSFULLY applied: Patch: /soft/33290750/26839277 Log: /u01/app/12.2.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2021-11-24_19-57-15PM_1.log Patch: /soft/33290750/31802727 Log: /u01/app/12.2.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2021-11-24_19-57-15PM_1.log Patch: /soft/33290750/33116894 Log: /u01/app/12.2.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2021-11-24_19-57-15PM_1.log Patch: /soft/33290750/33239961 Log: /u01/app/12.2.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2021-11-24_19-57-15PM_1.log Patch: /soft/33290750/33261817 Log: /u01/app/12.2.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2021-11-24_19-57-15PM_1.log OPatchauto session completed at Wed Nov 24 20:04:39 2021 Time taken to complete the session 9 minutes, 9 seconds |
