特点
限制点
新数据库需要手工enable补丁我们挑其中一个限制点做说明,比如第1个,新创建的数据库需要再次手工去enable补丁。 从一个通过opatch apply online --connectString的命令打成功的环境,dbca新建一个test数据库。 [oracle@oracle 18034737]$ opatch apply online -connectString zkm:sys:oracle: Oracle Interim Patch Installer version 11.2.0.3.21 Copyright (c) 2020, Oracle Corporation. All rights reserved. Oracle Home : /u01/app/oracle/product/11.2.0/db_1 Central Inventory : /u01/app/oraInventory from : /u01/app/oracle/product/11.2.0/db_1/oraInst.loc OPatch version : 11.2.0.3.21 OUI version : 11.2.0.4.0 Log file location : /u01/app/oracle/product/11.2.0/db_1/cfgtoollogs/opatch/opatch2020-06-06_19-26-40PM_1.log Verifying environment and performing prerequisite checks... OPatch continues with these patches: 18034737 Do you want to proceed? [y|n] y User Responded with: Y All checks passed. Provide your email address to be informed of security issues, install and initiate Oracle Configuration Manager. Easier for you if you use your My Oracle Support Email address/User Name. Visit http://www.oracle.com/support/policies.html for details. Email address/User Name: You have not provided an email address for notification of security issues. Do you wish to remain uninformed of security issues ([Y]es, [N]o) [N]: Y Backing up files... The patch should be applied/rolled back in '-all_nodes' mode only. Converting the RAC mode to '-all_nodes' mode. Applying interim patch '18034737' to OH '/u01/app/oracle/product/11.2.0/db_1' Patching component oracle.rdbms, 11.2.0.4.0... Installing and enabling the online patch 'bug18034737.pch', on database 'zkm'. Patch 18034737 successfully applied. Log file location: /u01/app/oracle/product/11.2.0/db_1/cfgtoollogs/opatch/opatch2020-06-06_19-26-40PM_1.log OPatch succeeded. [oracle@oracle 18034737]$ cd $ORACLE_HOME/hpatch [oracle@oracle hpatch]$ ll total 528 -rw-r--r--. 1 oracle oinstall 264374 Jun 6 19:26 bug18034737.pch -rw-------. 1 oracle oinstall 1 Jun 6 19:26 bug18034737.pchzkm.fixup -rwx------. 1 oracle oinstall 263350 Jun 6 19:26 bug18034737.so -rw-------. 1 oracle oinstall 712 Jun 6 19:26 orapatchzkm.cfg [oracle@oracle trace]$ opatch lspatches 18034737;
dbca:
新库的patch是未启用的状态: [oracle@oracle hpatch]$ sqlplus / as sysdba SQL*Plus: Release 11.2.0.4.0 Production on Sat Jun 6 19:46:25 2020 Copyright (c) 1982, 2013, Oracle. All rights reserved. Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options SYS@test> oradebug patch list Patch File Name State ================ ========= No patches currently installed
需要通过opatch手工启动, [oracle@oracle hpatch]$ opatch util EnableOnlinePatch -connectString test:sys:oracle -id 18034737 Oracle Interim Patch Installer version 11.2.0.3.21 Copyright (c) 2020, Oracle Corporation. All rights reserved. Oracle Home : /u01/app/oracle/product/11.2.0/db_1 Central Inventory : /u01/app/oraInventory from : /u01/app/oracle/product/11.2.0/db_1/oraInst.loc OPatch version : 11.2.0.3.21 OUI version : 11.2.0.4.0 Log file location : /u01/app/oracle/product/11.2.0/db_1/cfgtoollogs/opatch/opatch2020-06-06_19-48-25PM_1.log Invoking utility "enableonlinepatch" Installing and enabling the online patch 'bug18034737.pch', on database 'test'. OPatch succeeded. [oracle@oracle hpatch]$ sqlplus / as sysdba SQL*Plus: Release 11.2.0.4.0 Production on Sat Jun 6 19:48:38 2020 Copyright (c) 1982, 2013, Oracle. All rights reserved. Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options SYS@test> oradebug patch list Patch File Name State ================ ========= bug18034737.pch ENABLED
参考文档Limits Of Online Patching (Doc ID 1463390.1)
|
|