环境说明 | | | | | | | | | | | | | | | | | p6880880_190000_Linux-x86-64.zip p30783543_190000_DB_Linux-x86-64.zip |
手动升级到19.7 1、 更新OPATCH 先将19.3中的OPATCH包更新为更高级的版本,否则在应用升级补丁时,会因版本过低,无法应用 查看当前OPATCH版本 [oracle@localhost OPatch]$ $ORACLE_HOME/OPatch/opatch version OPatch Version: 12.2.0.1.17 OPatch succeeded. 更新OPATCH后,再次检查版本,验证是否升级成功 [oracle@localhost 19.3.0]$ $ORACLE_HOME/OPatch/opatch version OPatch Version: 12.2.0.1.21 OPatch succeeded. 2、检查Patch 补丁版本冲突 [oracle@localhost 30869156]$ $ORACLE_HOME/OPatch/opatch prereqCheckConflictAgainstOHWithDetail -phBaseDir /setup/30869156/ Oracle Interim Patch Installer version 12.2.0.1.21 Copyright (c) 2020, Oracle Corporation. All rights reserved. PREREQ session Oracle Home :/u01/app/oracle/product/19.3.0 Central Inventory : /u01/app/oraInventory from :/u01/app/oracle/product/19.3.0/oraInst.loc OPatch version :12.2.0.1.21 OUI version :12.2.0.7.0 Log file location : /u01/app/oracle/product/19.3.0/cfgtoollogs/opatch/opatch2020-07-01_19-52-01PM_1.log Invoking prereq "checkconflictagainstohwithdetail" Prereq "checkConflictAgainstOHWithDetail" passed. OPatch succeeded. 3、应用PATCH包,升级OJVM[oracle@localhost 30783543]$/u01/app/oracle/product/19.3.0/OPatch/opatch apply -local/setup/30783543/30805684/ Oracle Interim Patch Installer version 12.2.0.1.21 Copyright (c) 2020, Oracle Corporation. All rights reserved. Oracle Home :/u01/app/oracle/product/19.3.0 Central Inventory : /u01/app/oraInventory from :/u01/app/oracle/product/19.3.0/oraInst.loc OPatch version :12.2.0.1.21 OUI version :12.2.0.7.0 Log file location :/u01/app/oracle/product/19.3.0/cfgtoollogs/opatch/opatch2020-07-01_21-01-58PM_1.log Verifying environment and performing prerequisite checks... Prerequisite check "CheckSystemCommandAvailable"failed. The details are: Missing command :fuser UtilSession failed: Prerequisite check"CheckSystemCommandAvailable" failed. Log file location: /u01/app/oracle/product/19.3.0/cfgtoollogs/opatch/opatch2020-07-01_21-01-58PM_1.log OPatch failed with error code 73 报错处理 需要安装一个psmic包,使用yun源进行安装 [root@localhost setup]# yum install -y psmisc Loaded plugins: langpacks, product-id, search-disabled-repos,subscription-manager This system is not registered with an entitlement server. Youcan use subscription-manager to register. yum | 4.3 kB 00:00:00 Resolving Dependencies --> Running transaction check ---> Package psmisc.x86_64 0:22.20-15.el7 will be installed --> Finished Dependency Resolution Dependencies Resolved =============================================================================================================================== Package Arch Version Repository Size =============================================================================================================================== Installing: psmisc x86_64 22.20-15.el7 yum 141 k Transaction Summary =============================================================================================================================== Install 1 Package Total download size: 141 k Installed size: 475 k Downloading packages: Running transaction check Running transaction test Transaction test succeeded Running transaction Installing :psmisc-22.20-15.el7.x86_64 1/1 Verifying : psmisc-22.20-15.el7.x86_64 1/1 Installed: psmisc.x86_640:22.20-15.el7 Complete! 再次进行PATCH安装,安装OJVM [oracle@localhost 30783543]$ /u01/app/oracle/product/19.3.0/OPatch/opatchapply -local /setup/30783543/30805684/ Oracle Interim Patch Installer version 12.2.0.1.21 Copyright (c) 2020, Oracle Corporation. All rights reserved. Oracle Home :/u01/app/oracle/product/19.3.0 Central Inventory : /u01/app/oraInventory from :/u01/app/oracle/product/19.3.0/oraInst.loc OPatch version :12.2.0.1.21 OUI version :12.2.0.7.0 Log file location :/u01/app/oracle/product/19.3.0/cfgtoollogs/opatch/opatch2020-07-01_22-59-52PM_1.log Verifying environment and performing prerequisite checks... OPatch continues with these patches: 30805684 Do you want to proceed? [y|n] y User Responded with: Y All checks passed. Please shutdown Oracle instances running out of thisORACLE_HOME on the local system. (Oracle Home = '/u01/app/oracle/product/19.3.0') Is the local system ready for patching? [y|n] y User Responded with: Y Backing up files... Applying interim patch '30805684' to OH'/u01/app/oracle/product/19.3.0' Patching component oracle.javavm.server, 19.0.0.0.0... Patching component oracle.javavm.server.core, 19.0.0.0.0... Patching component oracle.rdbms.dbscripts, 19.0.0.0.0... Patching component oracle.rdbms, 19.0.0.0.0... Patch 30805684 successfully applied. Log file location:/u01/app/oracle/product/19.3.0/cfgtoollogs/opatch/opatch2020-07-01_22-59-52PM_1.log OPatch succeeded. 4、安装DB的PATCH[oracle@localhost 30783543]$ /u01/app/oracle/product/19.3.0/OPatch/opatchapply -local /setup/30783543/30869156/ Oracle Interim Patch Installer version 12.2.0.1.21 Copyright (c) 2020, Oracle Corporation. All rights reserved. Oracle Home :/u01/app/oracle/product/19.3.0 Central Inventory : /u01/app/oraInventory from :/u01/app/oracle/product/19.3.0/oraInst.loc OPatch version :12.2.0.1.21 OUI version :12.2.0.7.0 Log file location :/u01/app/oracle/product/19.3.0/cfgtoollogs/opatch/opatch2020-07-01_23-03-24PM_1.log Verifying environment and performing prerequisite checks... OPatch continues with these patches: 30869156 Do you want to proceed? [y|n] y User Responded with: Y All checks passed. Please shutdown Oracle instances running out of thisORACLE_HOME on the local system. (Oracle Home = '/u01/app/oracle/product/19.3.0') Is the local system ready for patching? [y|n] y User Responded with: Y Backing up files... Applying interim patch '30869156' to OH '/u01/app/oracle/product/19.3.0' ApplySession: Optional component(s) [ oracle.network.gsm,19.0.0.0.0 ] , [ oracle.rdbms.ic, 19.0.0.0.0 ] , [ oracle.tfa, 19.0.0.0.0 ] , [oracle.oraolap.mgmt, 19.0.0.0.0 ] , [ oracle.rdbms.tg4db2, 19.0.0.0.0 ] , [oracle.options.olap.awm, 19.0.0.0.0 ] , [ oracle.sqlj, 19.0.0.0.0 ] , [oracle.net.cman, 19.0.0.0.0 ] , [ oracle.network.cman, 19.0.0.0.0 ] , [oracle.assistants.asm, 19.0.0.0.0 ] , [ oracle.options.olap, 19.0.0.0.0 ] , [oracle.xdk.parser.java.jaxb2, 19.0.0.0.0 ] , [ oracle.assistants.usm,19.0.0.0.0 ] , [ oracle.jdk, 1.8.0.191.0 ] not present in the Oracle Home or a higher version is found. Patching component oracle.rdbms.rsf, 19.0.0.0.0... Patching component oracle.rdbms, 19.0.0.0.0.. 等待它执行完成 5、验证
查看版本 SQL>select banner_full from v$version; SQL> selectcomp_name,version,status from dba_registry; 打开所有的PDB SQL>alter pluggable database all open; 编译无效对象 SQL> @?/rdbms/admin/utlrp.sql 更新补丁字典信息 cd $ORACLE_HOME/OPatch ./datapatch -verbose 查看补丁字典信息 SQL> select PATCH_ID,PATCH_TYPE,ACTION,STATUS,TARGET_VERSIONfrom dba_registry_sqlpatch;
|