第一步，先进行备份
tar -cvf u01.tar /u01
第二步，更新OPatch工具包
根据补丁包中readme信息汇总提示的信息，下载对应版本的OPatch工具包，本次下载的版本为：
p6880880_122010_Linux-x86-64.zip
opatch版本为最新的12.2.0.1.46版本。
更新步骤如下：
cd $ORACLE_HOME
mv OPatch OPatch.bak
unzip /soft/p6880880_122010_Linux-x86-64.zip
提前配置好opatch环境变量，或者进入到OPatch中执行opatch命令：
[oracle@s203116 ~]$ opatch version
OPatch version:12.2.0.1.46
工具包满足readme中提示的12.2.0.1.30及以后版本后，进行下一步补丁安装。
第三步，补丁安装
解压补丁包，并进入补丁包目录，进行安装检查：
[root@s203116 src]# su - oracle
Last login: Thu Apr 17 11:01:57 CST 2025 on pts/0
[oracle@s203116 ~]$ cd /src/34057742/
[oracle@s203116 34057742]$ opatch prereq CheckConflictAgainstOHWithDetail -ph ./
Oracle Interim Patch Installer version 12.2.0.1.46
Copyright (c) 2025, Oracle Corporation. All rights reserved.
PREREQ session
Oracle Home : /u01/product/oracle/12.1.0/db_1
Central Inventory : /u01/product/oraInventory
from : /u01/product/oracle/12.1.0/db_1/oraInst.loc
OPatch version : 12.2.0.1.46
OUI version : 12.1.0.2.0
Log file location : /u01/product/oracle/12.1.0/db_1/cfgtoollogs/opatch/opatch2025-04-17_11-25-15AM_1.log
Invoking prereq "checkconflictagainstohwithdetail"
Prereq "checkConflictAgainstOHWithDetail" passed.
OPatch succeeded.
[oracle@s203116 34057742]$ opatch apply
Oracle Interim Patch Installer version 12.2.0.1.46
Copyright (c) 2025, Oracle Corporation. All rights reserved.
Oracle Home : /u01/product/oracle/12.1.0/db_1
Central Inventory : /u01/product/oraInventory
from : /u01/product/oracle/12.1.0/db_1/oraInst.loc
OPatch version : 12.2.0.1.46
OUI version : 12.1.0.2.0
Log file location : /u01/product/oracle/12.1.0/db_1/cfgtoollogs/opatch/opatch2025-04-17_11-25-52AM_1.log
Verifying environment and performing prerequisite checks...
Prerequisite check "CheckActiveFilesAndExecutables" failed.
The details are:
Following active files/executables/libs are used by ORACLE_HOME :/u01/product/oracle/12.1.0/db_1
/u01/product/oracle/12.1.0/db_1/lib/libclntsh.so.12.1
/u01/product/oracle/12.1.0/db_1/bin/oracle
UtilSession failed: Prerequisite check "CheckActiveFilesAndExecutables" failed.
Log file location: /u01/product/oracle/12.1.0/db_1/cfgtoollogs/opatch/opatch2025-04-17_11-25-52AM_1.log
OPatch failed with error code 73
报错信息是还有活动的会话占用，联系业务人员结束掉所有登录的窗口后，再进行安装检查成功。
安装检查通过后，进行正式补丁安装：
[oracle@s203116 34057742]$ opatch apply
Oracle Interim Patch Installer version 12.2.0.1.46
Copyright (c) 2025, Oracle Corporation. All rights reserved.
Oracle Home : /u01/product/oracle/12.1.0/db_1
Central Inventory : /u01/product/oraInventory
from : /u01/product/oracle/12.1.0/db_1/oraInst.loc
OPatch version : 12.2.0.1.46
OUI version : 12.1.0.2.0
Log file location : /u01/product/oracle/12.1.0/db_1/cfgtoollogs/opatch/opatch2025-04-17_11-29-50AM_1.log
Verifying environment and performing prerequisite checks...
Start OOP by Prereq process.
Launch OOP...
Oracle Interim Patch Installer version 12.2.0.1.46
Copyright (c) 2025, Oracle Corporation. All rights reserved.
Oracle Home : /u01/product/oracle/12.1.0/db_1
Central Inventory : /u01/product/oraInventory
from : /u01/product/oracle/12.1.0/db_1/oraInst.loc
OPatch version : 12.2.0.1.46
OUI version : 12.1.0.2.0
Log file location : /u01/product/oracle/12.1.0/db_1/cfgtoollogs/opatch/opatch2025-04-17_11-30-01AM_1.log
Verifying environment and performing prerequisite checks...
OPatch continues with these patches: 28729169 29141015 29494060 29918340 30340202 30700212 31113348 31550110 31985579 32328635 32768233 33128590 33477199 33711081 34057742
Do you want to proceed? [y|n]
y
User Responded with: Y
All checks passed.
Please shutdown Oracle instances running out of this ORACLE_HOME on the local system.
(Oracle Home = '/u01/product/oracle/12.1.0/db_1')
Is the local system ready for patching? [y|n]
y
User Responded with: Y
Backing up files...
Applying sub-patch '28729169' to OH '/u01/product/oracle/12.1.0/db_1'
Patching component oracle.ldap.rsf, 12.1.0.2.0...
Patching component oracle.rdbms.rman, 12.1.0.2.0...
Patching component oracle.rdbms.dbscripts, 12.1.0.2.0...
Patching component oracle.rdbms, 12.1.0.2.0...
Patching component oracle.rdbms.rsf, 12.1.0.2.0...
Applying sub-patch '29141015' to OH '/u01/product/oracle/12.1.0/db_1'
ApplySession: Optional component(s) [ oracle.has.crs, 12.1.0.2.0 ] not present in the Oracle Home or a higher version is found.
Patching component oracle.ldap.rsf, 12.1.0.2.0...
Patching component oracle.rdbms.deconfig, 12.1.0.2.0...
Patching component oracle.rdbms.rsf, 12.1.0.2.0...
Patching component oracle.rdbms.crs, 12.1.0.2.0...
Patching component oracle.rdbms, 12.1.0.2.0...
Patching component oracle.rdbms.dbscripts, 12.1.0.2.0...
Patching component oracle.rdbms.rman, 12.1.0.2.0...
Patching component oracle.tfa, 12.1.0.2.0...
Applying sub-patch '29494060' to OH '/u01/product/oracle/12.1.0/db_1'
ApplySession: Optional component(s) [ oracle.has.crs, 12.1.0.2.0 ] not present in the Oracle Home or a higher version is found.
Patching component oracle.ldap.rsf, 12.1.0.2.0...
Patching component oracle.network.rsf, 12.1.0.2.0...
Patching component oracle.rdbms.rsf, 12.1.0.2.0...
Patching component oracle.rdbms, 12.1.0.2.0...
Patching component oracle.ctx, 12.1.0.2.0...
Patching component oracle.sqlplus.ic, 12.1.0.2.0...
Patching component oracle.tfa, 12.1.0.2.0...
Patching component oracle.ldap.rsf.ic, 12.1.0.2.0...
Patching component oracle.rdbms.rman, 12.1.0.2.0...
Patching component oracle.rdbms.crs, 12.1.0.2.0...
Patching component oracle.oracore.rsf, 12.1.0.2.0...
Patching component oracle.rdbms.deconfig, 12.1.0.2.0...
Patching component oracle.rdbms.dbscripts, 12.1.0.2.0...
Patching component oracle.sqlplus, 12.1.0.2.0...
Patching component oracle.ctx.rsf, 12.1.0.2.0...
Applying sub-patch '29918340' to OH '/u01/product/oracle/12.1.0/db_1'
Patching component oracle.ldap.rsf, 12.1.0.2.0...
Patching component oracle.network.rsf, 12.1.0.2.0...
Patching component oracle.rdbms, 12.1.0.2.0...
Patching component oracle.rdbms.rsf, 12.1.0.2.0...
Patching component oracle.ctx, 12.1.0.2.0...
Patching component oracle.rdbms.dbscripts, 12.1.0.2.0...
Patching component oracle.rdbms.rman, 12.1.0.2.0...
Patching component oracle.rdbms.util, 12.1.0.2.0...
Patching component oracle.rdbms.dv, 12.1.0.2.0...
Patching component oracle.rdbms.lbac, 12.1.0.2.0...
Patching component oracle.ldap.rsf.ic, 12.1.0.2.0...
Patching component oracle.rdbms.deconfig, 12.1.0.2.0...
Applying sub-patch '30340202' to OH '/u01/product/oracle/12.1.0/db_1'
ApplySession: Optional component(s) [ oracle.rdbms.drdaas, 12.1.0.2.0 ] , [ oracle.rdbms.tg4tera, 12.1.0.2.0 ] , [ oracle.rdbms.tg4sybs, 12.1.0.2.0 ] , [ oracle.rdbms.tg4ifmx, 12.1.0.2.0 ] , [ oracle.rdbms.tg4db2, 12.1.0.2.0 ] , [ oracle.rdbms.tg4msql, 12.1.0.2.0 ] not present in the Oracle Home or a higher version is found.
Patching component oracle.ldap.rsf, 12.1.0.2.0...
Patching component oracle.rdbms.rsf, 12.1.0.2.0...
Patching component oracle.rdbms.util, 12.1.0.2.0...
Patching component oracle.rdbms, 12.1.0.2.0...
Patching component oracle.rdbms.oci, 12.1.0.2.0...
Patching component oracle.ldap.rsf.ic, 12.1.0.2.0...
Patching component oracle.rdbms.rman, 12.1.0.2.0...
Patching component oracle.rdbms.dbscripts, 12.1.0.2.0...
Patching component oracle.precomp.common, 12.1.0.2.0...
Patching component oracle.precomp.lang, 12.1.0.2.0...
Patching component oracle.rdbms.hsodbc, 12.1.0.2.0...
Applying sub-patch '30700212' to OH '/u01/product/oracle/12.1.0/db_1'
Patching component oracle.rdbms, 12.1.0.2.0...
Patching component oracle.network.rsf, 12.1.0.2.0...
Patching component oracle.rdbms.rsf, 12.1.0.2.0...
Patching component oracle.ldap.rsf, 12.1.0.2.0...
Patching component oracle.tfa, 12.1.0.2.0...
Patching component oracle.ldap.rsf.ic, 12.1.0.2.0...
Patching component oracle.assistants.server, 12.1.0.2.0...
Patching component oracle.rdbms.rman, 12.1.0.2.0...
Patching component oracle.rdbms.dbscripts, 12.1.0.2.0...
Patching component oracle.oraolap, 12.1.0.2.0...
Patching component oracle.precomp.lang, 12.1.0.2.0...
Patching component oracle.precomp.common, 12.1.0.2.0...
Patching component oracle.swd.oui, 12.1.0.2.0...
Patching component oracle.ordim.server, 12.1.0.2.0...
Patching component oracle.ctx, 12.1.0.2.0...
Applying sub-patch '31113348' to OH '/u01/product/oracle/12.1.0/db_1'
Patching component oracle.rdbms, 12.1.0.2.0...
Patching component oracle.rdbms.rsf, 12.1.0.2.0...
Patching component oracle.ldap.rsf, 12.1.0.2.0...
Patching component oracle.tfa, 12.1.0.2.0...
Patching component oracle.rdbms.rman, 12.1.0.2.0...
Patching component oracle.ldap.rsf.ic, 12.1.0.2.0...
Patching component oracle.rdbms.dbscripts, 12.1.0.2.0...
Patching component oracle.javavm.containers, 12.1.0.2.0...
Applying sub-patch '31550110' to OH '/u01/product/oracle/12.1.0/db_1'
Patching component oracle.rdbms, 12.1.0.2.0...
Patching component oracle.rdbms.rsf, 12.1.0.2.0...
Patching component oracle.dbtoolslistener, 12.1.0.2.0...
Patching component oracle.ldap.rsf, 12.1.0.2.0...
Patching component oracle.tfa, 12.1.0.2.0...
Patching component oracle.rdbms.rman, 12.1.0.2.0...
Patching component oracle.ldap.rsf.ic, 12.1.0.2.0...
Patching component oracle.rdbms.dv, 12.1.0.2.0...
Patching component oracle.rdbms.dbscripts, 12.1.0.2.0...
Patching component oracle.assistants.server, 12.1.0.2.0...
Patching component oracle.dbdev, 12.1.0.2.0...
Patching component oracle.oracore.rsf, 12.1.0.2.0...
Patching component oracle.rdbms.util, 12.1.0.2.0...
Patching component oracle.ctx, 12.1.0.2.0...
Applying sub-patch '31985579' to OH '/u01/product/oracle/12.1.0/db_1'
Patching component oracle.rdbms, 12.1.0.2.0...
Patching component oracle.rdbms.rsf, 12.1.0.2.0...
Patching component oracle.ldap.rsf, 12.1.0.2.0...
Patching component oracle.tfa, 12.1.0.2.0...
Patching component oracle.rdbms.dbscripts, 12.1.0.2.0...
Patching component oracle.ldap.rsf.ic, 12.1.0.2.0...
Patching component oracle.rdbms.rman, 12.1.0.2.0...
Patching component oracle.assistants.acf, 12.1.0.2.0...
Patching component oracle.ldap.owm, 12.1.0.2.0...
Patching component oracle.ctx, 12.1.0.2.0...
Applying sub-patch '32328635' to OH '/u01/product/oracle/12.1.0/db_1'
ApplySession: Optional component(s) [ oracle.nlsrtl.companion, 12.1.0.2.0 ] not present in the Oracle Home or a higher version is found.
Patching component oracle.dbdev, 12.1.0.2.0...
Patching component oracle.dbtoolslistener, 12.1.0.2.0...
Patching component oracle.ldap.rsf, 12.1.0.2.0...
Patching component oracle.duma, 12.1.0.2.0...
Patching component oracle.tfa, 12.1.0.2.0...
Patching component oracle.rdbms.rsf, 12.1.0.2.0...
Patching component oracle.rdbms, 12.1.0.2.0...
Patching component oracle.rdbms.rman, 12.1.0.2.0...
Patching component oracle.nlsrtl.rsf, 12.1.0.2.0...
Patching component oracle.rdbms.dv, 12.1.0.2.0...
Patching component oracle.oracore.rsf, 12.1.0.2.0...
Patching component oracle.xdk, 12.1.0.2.0...
Patching component oracle.ctx.atg, 12.1.0.2.0...
Patching component oracle.nlsrtl.rsf.core, 12.1.0.2.0...
Patching component oracle.xdk.parser.java, 12.1.0.2.0...
Patching component oracle.rdbms.dbscripts, 12.1.0.2.0...
Patching component oracle.ldap.rsf.ic, 12.1.0.2.0...
Applying sub-patch '32768233' to OH '/u01/product/oracle/12.1.0/db_1'
ApplySession: Optional component(s) [ oracle.network.cman, 12.1.0.2.0 ] not present in the Oracle Home or a higher version is found.
Patching component oracle.rdbms.rsf, 12.1.0.2.0...
Patching component oracle.rdbms, 12.1.0.2.0...
Patching component oracle.network.rsf, 12.1.0.2.0...
Patching component oracle.ctx, 12.1.0.2.0...
Patching component oracle.ldap.rsf, 12.1.0.2.0...
Patching component oracle.tfa, 12.1.0.2.0...
Patching component oracle.ldap.rsf.ic, 12.1.0.2.0...
Patching component oracle.rdbms.deconfig, 12.1.0.2.0...
Patching component oracle.rdbms.util, 12.1.0.2.0...
Patching component oracle.rdbms.dbscripts, 12.1.0.2.0...
Patching component oracle.sdo.locator, 12.1.0.2.0...
Patching component oracle.nlsrtl.rsf.core, 12.1.0.2.0...
Applying sub-patch '33128590' to OH '/u01/product/oracle/12.1.0/db_1'
Patching component oracle.rdbms.rsf, 12.1.0.2.0...
Patching component oracle.rdbms, 12.1.0.2.0...
Patching component oracle.ctx, 12.1.0.2.0...
Patching component oracle.tfa, 12.1.0.2.0...
Patching component oracle.rdbms.dbscripts, 12.1.0.2.0...
Patching component oracle.rdbms.crs, 12.1.0.2.0...
Patching component oracle.rdbms.deconfig, 12.1.0.2.0...
Patching component oracle.oraolap, 12.1.0.2.0...
Patching component oracle.rdbms.lbac, 12.1.0.2.0...
Applying sub-patch '33477199' to OH '/u01/product/oracle/12.1.0/db_1'
ApplySession: Optional component(s) [ oracle.network.cman, 12.1.0.2.0 ] not present in the Oracle Home or a higher version is found.
Patching component oracle.rdbms.rsf, 12.1.0.2.0...
Patching component oracle.rdbms, 12.1.0.2.0...
Patching component oracle.network.rsf, 12.1.0.2.0...
Patching component oracle.ldap.rsf, 12.1.0.2.0...
Patching component oracle.tfa, 12.1.0.2.0...
Patching component oracle.rdbms.rman, 12.1.0.2.0...
Patching component oracle.sdo, 12.1.0.2.0...
Patching component oracle.sdo.locator, 12.1.0.2.0...
Patching component oracle.ldap.rsf.ic, 12.1.0.2.0...
Patching component oracle.rdbms.util, 12.1.0.2.0...
Patching component oracle.rdbms.dbscripts, 12.1.0.2.0...
Patching component oracle.sdo.locator.jrf, 12.1.0.2.0...
Applying sub-patch '33711081' to OH '/u01/product/oracle/12.1.0/db_1'
ApplySession: Optional component(s) [ oracle.rdbms.tg4tera, 12.1.0.2.0 ] , [ oracle.rdbms.tg4ifmx, 12.1.0.2.0 ] , [ oracle.rdbms.tg4db2, 12.1.0.2.0 ] , [ oracle.rdbms.tg4sybs, 12.1.0.2.0 ] , [ oracle.rdbms.tg4msql, 12.1.0.2.0 ] , [ oracle.sysman.ccr.repeater, 12.1.0.2.0 ] , [ oracle.rdbms.tg4ifxm, 12.1.0.2.0 ] not present in the Oracle Home or a higher version is found.
Patching component oracle.network.rsf, 12.1.0.2.0...
Patching component oracle.rdbms.rsf, 12.1.0.2.0...
Patching component oracle.rdbms, 12.1.0.2.0...
Patching component oracle.tfa, 12.1.0.2.0...
Patching component oracle.rdbms.hsodbc, 12.1.0.2.0...
Patching component oracle.network.listener, 12.1.0.2.0...
Patching component oracle.ctx, 12.1.0.2.0...
Patching component oracle.rdbms.hs_common, 12.1.0.2.0...
Applying sub-patch '34057742' to OH '/u01/product/oracle/12.1.0/db_1'
ApplySession: Optional component(s) [ oracle.network.cman, 12.1.0.2.0 ] , [ oracle.rdbms.tg4tera, 12.1.0.2.0 ] , [ oracle.rdbms.tg4ifmx, 12.1.0.2.0 ] , [ oracle.rdbms.tg4db2, 12.1.0.2.0 ] , [ oracle.rdbms.tg4sybs, 12.1.0.2.0 ] , [ oracle.rdbms.tg4msql, 12.1.0.2.0 ] not present in the Oracle Home or a higher version is found.
Patching component oracle.rdbms.rsf, 12.1.0.2.0...
Patching component oracle.network.rsf, 12.1.0.2.0...
Patching component oracle.rdbms, 12.1.0.2.0...
Patching component oracle.ldap.rsf, 12.1.0.2.0...
Patching component oracle.swd.oui.core, 12.1.0.2.0...
Patching component oracle.tfa, 12.1.0.2.0...
Patching component oracle.rdbms.rman, 12.1.0.2.0...
Patching component oracle.ovm, 12.1.0.2.0...
Patching component oracle.ldap.rsf.ic, 12.1.0.2.0...
Patching component oracle.rdbms.dbscripts, 12.1.0.2.0...
Patching component oracle.rdbms.hsodbc, 12.1.0.2.0...
Composite patch 34057742 successfully applied.
Log file location: /u01/product/oracle/12.1.0/db_1/cfgtoollogs/opatch/opatch2025-04-17_11-30-01AM_1.log
OPatch succeeded.
You have mail in /var/spool/mail/oracle
提示succeeded后表示补丁安装成功。
查看补丁安装信息：
[oracle@s203116 34057742]$ opatch lsinv
Oracle Interim Patch Installer version 12.2.0.1.46
Copyright (c) 2025, Oracle Corporation. All rights reserved.
Oracle Home : /u01/product/oracle/12.1.0/db_1
Central Inventory : /u01/product/oraInventory
from : /u01/product/oracle/12.1.0/db_1/oraInst.loc
OPatch version : 12.2.0.1.46
OUI version : 12.1.0.2.0
Log file location : /u01/product/oracle/12.1.0/db_1/cfgtoollogs/opatch/opatch2025-04-17_11-33-42AM_1.log
Lsinventory Output file location : /u01/product/oracle/12.1.0/db_1/cfgtoollogs/opatch/lsinv/lsinventory2025-04-17_11-33-42AM.txt
Local Machine Information::
Hostname: s203116
ARU platform id: 226
ARU platform description:: Linux x86-64
Installed Top-level Products (1):
Oracle Database 12c 12.1.0.2.0
There are 1 products installed in this Oracle Home.
Interim patches (2) :
Patch 34057742 : applied on Thu Apr 17 11:32:58 CST 2025
Unique Patch ID: 24873298
Patch description: "Database Patch Set Update : 12.1.0.2.220719 (34057742)"
Created on 21 Jul 2022, 04:32:03 hrs PST8PDT
Sub-patch 33711081; "Database Patch Set Update : 12.1.0.2.220419 (33711081)"
Sub-patch 33477199; "Database Patch Set Update : 12.1.0.2.220118 (33477199)"
Sub-patch 33128590; "Database Patch Set Update : 12.1.0.2.211019 (33128590)"
Sub-patch 32768233; "Database Patch Set Update : 12.1.0.2.210720 (32768233)"
Sub-patch 32328635; "Database Patch Set Update : 12.1.0.2.210420 (32328635)"
Sub-patch 31985579; "Database Patch Set Update : 12.1.0.2.210119 (31985579)"
Sub-patch 31550110; "Database Patch Set Update : 12.1.0.2.201020 (31550110)"
Sub-patch 31113348; "Database Patch Set Update : 12.1.0.2.200714 (31113348)"
Sub-patch 30700212; "Database Patch Set Update : 12.1.0.2.200414 (30700212)"
Sub-patch 30340202; "Database Patch Set Update : 12.1.0.2.200114 (30340202)"
Sub-patch 29918340; "Database Patch Set Update : 12.1.0.2.191015 (29918340)"
Sub-patch 29494060; "Database Patch Set Update : 12.1.0.2.190716 (29494060)"
Sub-patch 29141015; "Database Patch Set Update : 12.1.0.2.190416 (29141015)"
Sub-patch 28729169; "Database Patch Set Update : 12.1.0.2.190115 (28729169)"
Sub-patch 28259833; "Database Patch Set Update : 12.1.0.2.181016 (28259833)"
Sub-patch 27547329; "Database Patch Set Update : 12.1.0.2.180717 (27547329)"
Sub-patch 27338041; "Database Patch Set Update : 12.1.0.2.180417 (27338041)"
Sub-patch 26925311; "Database Patch Set Update : 12.1.0.2.180116 (26925311)"
Sub-patch 26713565; "Database Patch Set Update : 12.1.0.2.171017 (26713565)"
Sub-patch 26609783; "Database Patch Set Update : 12.1.0.2.170814 (26609783)"
Sub-patch 25755742; "Database Patch Set Update : 12.1.0.2.170718 (25755742)"
Sub-patch 25171037; "Database Patch Set Update : 12.1.0.2.170418 (25171037)"
Sub-patch 24732082; "Database Patch Set Update : 12.1.0.2.170117 (24732082)"
Sub-patch 24006101; "Database Patch Set Update : 12.1.0.2.161018 (24006101)"
Sub-patch 23054246; "Database Patch Set Update : 12.1.0.2.160719 (23054246)"
Sub-patch 22291127; "Database Patch Set Update : 12.1.0.2.160419 (22291127)"
Sub-patch 21948354; "Database Patch Set Update : 12.1.0.2.160119 (21948354)"
Sub-patch 21359755; "Database Patch Set Update : 12.1.0.2.5 (21359755)"
Sub-patch 20831110; "Database Patch Set Update : 12.1.0.2.4 (20831110)"
Sub-patch 20299023; "Database Patch Set Update : 12.1.0.2.3 (20299023)"
Sub-patch 19769480; "Database Patch Set Update : 12.1.0.2.2 (19769480)"
Bugs fixed:
25437699, 26546664, 13854364, 29483723, 28774416, 19915271, 20172151
19516448, 24907917, 24796092, 22310426, 29434301, 20853821, 19130616
21153266, 23702338, 28250929, 19548064, 26556014, 22346829, 21387964
13542050, 25377044, 22072818, 31992953, 22734547, 22243983, 19012119
29625065, 19932634, 19869255, 18681056, 23324000, 22068305, 19439759
19303936, 18856106, 22916353, 21106027, 20023340, 22153958, 26256131
19134173, 20447445, 26513709, 25780343, 19769480, 21097043, 20677396
22205263, 20919320, 22075064, 22331786, 29621961, 31404014, 22551446
29250317, 27611612, 18440095, 22496904, 16439813, 18354830, 20596234
25115178, 22268833, 22515353, 19809171, 21186167, 26111842, 13787015
25405687, 22492533, 20173897, 24624166, 29707896, 25579761, 20181030
22860641, 21868720, 23068169, 32166272, 21383171, 19402853, 19888853
24341675, 20717081, 27370965, 19081128, 22173980, 34100909, 25722055
23514710, 29483771, 20951038, 22168163, 20569094, 24308635, 19791377
30860803, 30365745, 22475617, 19469538, 30225443, 20598042, 18988834
21924131, 21837606, 33027553, 25051465, 30320029, 20387265, 29378913
20673810, 21764119, 32436757, 32284725, 19124336, 31927930, 22294260
29796916, 6194865, 21300341, 18288842, 27223075, 22353199, 28305362
25670786, 26898563, 22495673, 19577410, 26248143, 23294548, 33441073
25328093, 26608137, 19931709, 30285540, 25423453, 23533807, 25600421
18122373, 23124895, 18856999, 27424405, 18893947, 26633558, 20076781
20926021, 26029780, 21196809, 22533631, 23725036, 27679641, 19562381
24808595, 19189317, 25669791, 21917884, 27213224, 29006527, 20711718
25982666, 25472885, 20684983, 22826718, 21773465, 20250147, 20144019
26263721, 19597439, 28867992, 21387128, 22007324, 21566639, 29869906
18111216, 24285405, 21425496, 26544823, 29477015, 22228324, 23172924
22520320, 28164480, 25058080, 22365117, 22645009, 25165496, 28950969
27185188, 27433385, 18774543, 20124446, 21834568, 30659882, 19371175
18940497, 22923409, 25489342, 32425124, 19044962, 19532017, 19662635
20753555, 33065437, 33621092, 20560611, 30822919, 19578247, 20705577
22238921, 22809871, 19995869, 30866988, 32747680, 18921743, 21897746
19018206, 19777862, 22223463, 19304354, 23020270, 25099339, 22214989
27199245, 30200680, 22977256, 20890311, 27445727, 20869721, 22258530
24555417, 18801391, 18648816, 32312586, 18819908, 30578221, 23628685
31501139, 23007241, 19593445, 21080143, 20582405, 20031873, 29828111
25489367, 18618122, 22501616, 26784509, 22727335, 24739928, 19068970
24713381, 23168363, 20432873, 20088237, 28644756, 31909295, 31089270
20087383, 25459958, 27534509, 26768025, 20686773, 33090848, 27623159
20868862, 21780146, 23315153, 20466628, 20397490, 30025002, 23240358
22178855, 27729678, 19329654, 30660412, 21275255, 20859910, 26203182
22568797, 19075256, 28026866, 25635149, 20844426, 20441797, 20175161
18548246, 21442094, 25079710, 27452046, 20782911, 24674955, 18840932
18740837, 20294666, 32222473, 30196358, 22062517, 27745728, 30116203
27092508, 29265446, 29637560, 21889720, 29965888, 19347458, 19450116
20117253, 19931367, 22092979, 21625179, 19272708, 33933784, 21281532
22662332, 19461270, 18700762, 19434529, 18799063, 18324100, 17008068
21246723, 20831538, 20424899, 20562898, 23184013, 20001168, 32252213
21241052, 21779541, 21270823, 28199085, 20736227, 19399918, 20017509
25555252, 25612095, 19067244, 33106822, 19943771, 18043064, 18885870
26243698, 26187943, 20324049, 30164714, 19536415, 23709062, 31787041
18628388, 27072923, 25047724, 31711889, 27847259, 20459944, 19185876
22465352, 24385625, 24920582, 24326444, 31908345, 30826474, 19627012
22733141, 32602194, 20468401, 27441326, 27620950, 16863642, 19639483
19621704, 27567477, 21479753, 25791890, 20581111, 20936731, 19440386
23054054, 32846272, 27629756, 19188927, 29342099, 20229001, 24570598
21172913, 17655240, 29379978, 21266085, 19028800, 19035573, 27400598
22470443, 19366375, 24523374, 25599425, 28072383, 19289642, 25906117
31013127, 23521523, 26956036, 29500257, 26088426, 17414008, 23019710
20897759, 22046677, 19663176, 20938170, 19891090, 21960504, 24509056
22894101, 26262953, 19723336, 28891984, 19835133, 17532734, 17495022
25300427, 21842017, 29483626, 27285244, 19687159, 20977794, 19945814
20734332, 16938780, 17551063, 27548131, 21977392, 24461826, 19676012
23315889, 24480567, 23053606, 19841800, 33096609, 30939307, 20245930
19001359, 32190284, 30215130, 19393542, 23533524, 29961353, 21099555
17532729, 27995248, 29814995, 19644859, 19908836, 21421886, 19358317
20803014, 23642282, 21418655, 24662775, 18890385, 30421204, 20347562
22379445, 18693124, 29009513, 19896336, 16090440, 27565906, 20048359
20468490, 19524384, 25392535, 21147908, 21695575, 20440930, 24718260
26110632, 31510891, 19591608, 22707244, 22296366, 18914624, 21522582
29893132, 19501299, 34096213, 26007010, 20425790, 27997875, 29122367
32786309, 16870214, 18202441, 26798411, 24415926, 19001390, 21157728
22606521, 21875360, 25091141, 28000269, 19149990, 20382309, 28371123
26353617, 19606174, 28542455, 20848335, 25495682, 19382851, 32119339
22762046, 24563422, 23125826, 22503297, 23338911, 27274536, 22730454
19354794, 20757079, 20298413, 19048007, 21532755, 23602213, 32386877
22160989, 22894949, 21059919, 18952989, 22518784, 32284608, 25885148
25484507, 20794034, 21061354, 17533661, 19883092, 24401351, 27667128
28023399, 18051556, 25330273, 26412540, 29689697, 19699191, 32676350
16875041, 18964978, 22157363, 23342170, 25766822, 21967197, 19601762
26110259, 20368850, 28201045, 20798891, 25606091, 31748000, 21133343
28501075, 18542562, 19017309, 24802934, 20134339, 24690216, 28107123
22507210, 32355765, 20101006, 27938623, 23501901, 18797519, 25997810
23029562, 21260397, 29726695, 19354335, 19730508, 22366558, 25822410
6599380, 21157342, 20717359, 18964939, 19871910, 29437712, 26366517
25695903, 19800418, 31848903, 20603431, 21542577, 22507234, 25600342
28587723, 20627866, 18110491, 24642295, 19518079, 19339555, 20466322
25823754, 25110233, 20169408, 24908321, 17274537, 26575788, 28204104
18899974, 30658421, 22347493, 19052488, 26198757, 19503821, 24350620
21220620, 19865345, 22816287, 31799139, 23492665, 20879889, 28022101
30186245, 21893235, 19363645, 18382302, 27086138, 33921275, 22826067
19248799, 8975044, 28432129, 19155797, 28289945, 19990037, 20509482
27255377, 29372460, 24717859, 22862134, 21526048, 28683167, 24929210
25486384, 21620471, 19433930, 32186646, 25123585, 20476175, 18549238
19684504, 19330795, 31421316, 32335769, 20899461, 19024808, 30248531
25809524, 30987088, 25760195, 28024793, 19928926, 18498878, 23314180
24737403, 20480209, 18904062, 26430737, 32117253, 25476125, 20856766
23627427, 17258582, 27169796, 34249359, 29247712, 20877664, 24577566
19430401, 19676905, 20925795, 22760679, 26482376, 24416451, 18673090
31022858, 22865673, 21315084, 26999139, 19375649, 31156383, 19989009
22820798, 18191823, 28023482, 25775213, 18197127, 24623975, 30803210
31194264, 27033652, 25639019, 17319928, 14705949, 19703301, 31836113
20308798, 28390273, 20122715, 6418158, 19258504, 21188532, 26832296
24792678, 23151677, 22467685, 16887946, 19693090, 26024732, 25077278
27012701, 19490948, 29483672, 29559723, 21516611, 21641760, 19818513
23002524, 26169341, 22761995, 21052842, 25835365, 32628221, 24693382
22165897, 19373893, 22359063, 18373438, 30398099, 28534493, 20470877
21632821, 22351572, 18604493, 22901797, 20978259, 24801152, 27276231
20907061, 25733479, 19523462, 19183343, 27080844, 28362607, 29719146
25093739, 28708023, 24413809, 25549931, 21308727, 20413820, 22176950
28986231, 25897615, 25643931, 21281607, 18841764, 28098160, 20558005
20093776, 29933718, 20618595, 19209117, 23104033, 19211433, 20078186
20331945, 19512341, 23066146, 22686674, 18607546, 26875822, 23115139
21294938, 20898997, 18510194, 21293600, 22454326, 24683149, 23061702
19309466, 19902195, 18250893, 19383839, 19781326, 16756406, 31786838
30031027, 18456643, 31106577, 29884958, 22364044, 18913440, 18845653
30816938, 22468255, 18417036, 23713236, 23140259, 21856522, 23028781
19243521, 19658708, 18272672, 31028986, 19174430, 18900107, 19184226
21969671, 22243719, 19068380, 20493163, 20688221, 20838453, 22250006
24307571, 33393503, 30758943, 21623164, 21534893, 22232606, 25427662
24589081, 24835538, 32878039, 22353346, 19790243, 26444887, 23088803
22529728, 30018017, 18492302, 24303148, 21101873, 27122162, 21188584
19390567, 20308238, 27217412, 21225209, 26245237, 19284031, 25205368
19450314, 23514911, 19016730, 32776891, 25904490, 27303938, 22517782
22721409, 32065792, 22022760, 20936905, 23197103, 23746128, 27897759
21514877, 18990023, 27207634, 22233505, 17210525, 21260431, 24470606
32190132, 25056052, 19370504, 24423416, 19124589, 32428097, 28491715
22690648, 25107334, 17722075, 20882568, 25653109, 23026585, 18604692
25546608, 20768076, 19178851, 30517516, 25161298, 28302049, 19050649
20920911, 29962939, 32296941, 19189525, 19060015, 27052607, 23555824
29633753, 32775512, 22458049, 21159665, 23302839, 25307368, 25699321
17409174, 20588486, 22729345, 22842151, 19238590, 16941434, 24397438
23108128, 20356733, 28215510, 22380919, 18436647, 23065323, 20825533
27873364, 20839705, 24790914, 20284155, 31658943, 23571055, 25539063
17365043, 24597536, 25914276, 20952966, 22961508, 19176223, 23237313
20011515, 31527103, 22083366, 27634991, 21419850, 31852482, 27986817
31233170, 23101501, 24737064, 28507324, 25547060, 27726780, 24600330
20635353, 28384353, 20043616, 20929771, 21450666, 31031715, 24752618
21354456, 20464614, 27375542, 18307021, 19708632, 28423598, 25633101
18973548, 29635990, 19718981, 23567857, 25655390, 19197175, 28797711
18818069, 19180770, 27516009, 19879746, 21785691, 20539050, 20424183
21894802, 19957298, 21797203, 20322560, 29962927, 29817278, 30179644
27751755, 21575362, 27133662, 21813400, 21429602, 29189889, 26153977
21863727, 19074147, 21380789, 19154375, 31675539, 25417056, 23080557
22374754, 25654936, 21492036, 18705806, 28420042, 22024071, 24838599
31525783, 29645349, 21184223, 23089357, 19404068, 19065677, 19018447
18308268, 27314697, 29027694, 22519146, 27419631, 19445860, 26654363
28281094, 21142837, 22179537, 21756699, 31667940, 20217801, 19550902
22760595, 25483815, 19543384, 25482971, 30252098, 27351628, 24966594
20374572, 24737581, 24530364, 21698350, 26513067, 32153619, 28043157
19306797, 18966843, 19077215, 20704450, 20543011, 19023822, 32105135
22836801, 21756677, 33040335, 20328248, 18674047, 18849537, 20315311
29163567, 22897344, 25178179, 19308965, 18948177, 20764012, 19468991
21756661, 19706965, 32368792, 20302006, 24831514, 32988028, 19032777
20862087, 18974476, 20603378, 29500963, 19307662, 21847223, 29655164
20281121, 28079127, 31637680, 19076343, 29511611, 18866977, 22808310
20904530, 20296619, 19831647, 30497057, 29458132, 25371030, 27404573
21037923, 25602488, 21517440, 33873839, 25971286, 19180394, 27337759
19174942, 20671094, 33414041, 18411216, 23263264, 24386767, 24737954
20641666, 25264559, 19930276, 23632545, 25616268, 20879709, 23003979
20165574, 28578164, 19547370, 22624709, 23084507, 23184263, 20228093
25093872, 32755493, 25060506, 19805359, 26324206, 31409964, 26729494
20354900, 29388020, 20378086, 24609530, 20361671, 18674024, 29343156
19689979, 24411921, 16619249, 19873610, 21641414, 21091431, 19440586
22757364, 22175564, 22499356, 20725343, 31001455, 19561643, 23265456
19195895, 20830459, 18475439, 30499600, 25790353, 21828126, 21665897
20746251, 19315668, 22568177, 25764020, 25357142, 23096938, 19941352
21329301, 21612959, 30305880, 28174827, 20446883, 27314206, 21299490
25313154, 21744290, 23591576, 18254023, 27302681, 20591183, 25643818
18548433, 27207110, 20402832, 29200700, 19315691, 28730253, 19174521
23177923, 20401975, 18306996, 18851894, 21424824, 27034890, 32851841
20318889, 21060755, 25240188, 26828994, 21049500, 22256560, 29170232
24545494, 23328639, 27229389, 20766180, 21977186, 25475853, 19527222
28821847, 25034396, 31987278, 21502702, 21291274, 18007682, 20475845
29408136, 22148226, 22528741, 20001466, 25417958, 22261050, 24652769
19326908, 19597583, 26822620, 24825843, 26318627, 20524085, 19054077
21385422, 22657942, 20428621, 21899588, 23326313, 28891741, 31827339
19333670, 18798250, 19285025, 21373473, 23260854, 23061453, 14643995
32803807, 22146062, 26145560, 28612674, 20588502, 19520602, 21476308
26546754, 25429959, 19141838, 21915719, 27101105, 19524158, 28758090
29869404, 23584909, 23548817, 25861398, 23025340, 19335438, 19058490
19207117, 18799993, 25919622, 26569225, 25986062, 20835241, 20958816
19475971, 24525353, 18967382, 25740844, 32287989, 20348653, 27504770
24812585, 21896069, 33034103, 30973003, 30295478, 25789277, 19171086
17867700, 19791273, 32359044, 27397048, 21241829, 18662619, 18419520
22654475, 19571367, 28636676, 19529868, 27434193, 27487919, 19708342
27929509, 26968670, 18743542, 32984679, 20657411, 19332396, 21821302
32649749, 33425127, 22855193, 23645516, 16777441, 33417987, 20528052
25288078, 27468303, 17777718, 28993590, 25192729, 31600023, 30889351
19176326, 32675227, 22018363, 24300640, 18849970, 20860659, 22905130
26121990, 21263635, 27710072, 23209741, 30698289, 18499088, 21037905
18775971, 27348081, 25856821, 24457597, 20554364, 26318200, 19468347
20657441, 24357500, 21285458, 15996848, 24425998, 30387666, 24437510
30668407, 20669434, 25415713, 22972770, 28369092, 20828947, 21373076
17428816, 25492379, 25551676, 14283239, 22922076, 23731896, 25575628
21239530, 20437153, 24848928, 20880215, 19051460, 29782211, 19013183
21095391, 25042823, 22695831, 24365589, 26844870, 25248384, 25634317
22236041, 20134113, 19587324, 20273319, 31945038, 30624864, 26758193
21063322, 22062026, 27829295, 25890782, 22077517, 22815955, 23854396
19972766, 27841399, 32097882, 16354467, 17760068, 21795111, 25179774
25879984, 22301880, 26844406, 25029423, 19390620, 26658759, 24321547
27097854, 21297872, 21913183, 22366322, 20171986, 21132297, 25957038
29944159, 29791152, 23170620, 24719736, 18868646, 29142109, 26637824
24784414, 16923858, 18427406, 31046619, 20914870, 22750215, 27443406
20842388, 31951628, 20474192, 21644640, 28849751, 29464779, 21794615
20471920, 22806698, 29944660, 29260956, 19188385, 23717151, 30522998
23126410, 20074391, 25823532, 19157754, 22495062, 24316947, 19065556
25947799, 20878790, 21322887, 22305887, 19617921, 24350831, 19578350
31696577, 26439748, 33247372, 23230647, 21072646, 20898391, 19291380
27060167, 22536802, 22087683, 21197626, 30117469, 21656630, 31228670
20373598, 22707866, 19279273, 18886413, 25490238, 20922010, 25150925
20778986, 22282748, 24642495, 20703000, 19079752, 24560906, 23125587
20144308, 19670108, 19068610, 20267166, 28639299, 19297917, 20564072
22950945, 19385656, 23528412, 21174504, 28357401, 29061016, 20557786
21911701, 19143550, 20118035, 20009833, 22454940, 19604659, 16359751
26039623, 22820579, 20212067, 29030780, 21668627, 26325856, 23272045
19487147, 23149541, 28025414, 21296029, 21629064, 23229229, 20708701
25353983, 19280225, 20613079, 21560152, 19213447, 27314390, 26336977
24393981, 22568016, 19269405, 21626377, 23105538, 25743479, 26198926
22185234, 28714988, 17890099, 21649497, 26446098, 18791688, 19721304
20130575, 19619732, 21164318, 23148260, 18090142, 22468781, 20139391
19978542, 25477657, 23543183, 19409212, 23035249, 21820934, 20677974
22264489, 18990693, 19452434, 21422580, 20235511, 23220453, 18742258
33916081, 23008056, 26126424, 18610915, 21978888, 22666802, 22510285
28889389, 31668061, 20832516, 26089440, 18733351, 20505778, 21675340
21787056, 21273804, 22782647, 20544065, 23266217, 17835294, 25210690
27846298, 21047218, 18371441, 26714910, 24385983, 24421668, 23195445
20513399, 30193165, 18909599, 23572982, 31862611, 32834168, 21515534
22256431, 19637186, 19022470, 24573817, 31172207, 19649152, 19201867
32442404, 24766121, 30218044, 21842740, 33090781, 19534363, 28566241
25489607
Patch 28440711 : applied on Tue Jan 15 15:35:14 CST 2019
Unique Patch ID: 22440644
Patch description: "Database PSU 12.1.0.2.181016, Oracle JavaVM Component (OCT2018)"
Created on 12 Sep 2018, 13:15:28 hrs PST8PDT
Bugs fixed:
19153980, 19176885, 19223010, 19231857, 19245191, 19623450, 19699946
19855285, 19877336, 19895326, 19895362, 19909862, 20408829, 20408866
20415564, 21047766, 21047803, 21068507, 21188537, 21555660, 21566944
21566993, 21659726, 21811517, 22118835, 22118851, 22139226, 22670385
22670413, 22674709, 22675136, 23177536, 23265914, 23265965, 23727148
24315824, 24448240, 24448282, 24534298, 24917972, 25067795, 25076732
25076756, 25437695, 25494379, 25494413, 25649873, 26023002, 26023025
26027162, 26570171, 26635845, 26637592, 27000663, 27000690, 27001733
27461789, 27461842, 27475603, 27642235, 27923320, 27952577, 27952584
28440711, 28502113, 28502128
OPatch succeeded.
[oracle@s203116 34057742]$
HOME目录已经安装补丁成功。
进行补丁注册：
[oracle@s203116 34057742]$ sqlplus / as sysdba
SQL*Plus: Release 12.1.0.2.0 Production on Thu Apr 17 11:34:11 2025
Copyright (c) 1982, 2014, Oracle. All rights reserved.
Connected to an idle instance.
SQL> starup
SP2-0042: unknown command "starup" - rest of line ignored.
SQL> startup
ORACLE instance started.
Total System Global Area 1.2080E+11 bytes
Fixed Size 7660560 bytes
Variable Size 2.1743E+10 bytes
Database Buffers 9.8784E+10 bytes
Redo Buffers 260771840 bytes
Database mounted.
Database opened.
SQL> show pdbs
CON_ID CON_NAME OPEN MODE RESTRICTED
2 PDB$SEED READ ONLY NO 3 ORAJCTMBIZ MOUNTED 4 ORAJCTMSOL MOUNTED 5 ORAJCTMRBAC MOUNTED
SQL> alter pluggable database all open;
Pluggable database altered.
SQL>
SQL> show pdbs
CON_ID CON_NAME OPEN MODE RESTRICTED
2 PDB$SEED READ ONLY NO 3 ORAJCTMBIZ READ WRITE NO 4 ORAJCTMSOL READ WRITE NO 5 ORAJCTMRBAC READ WRITE NO
SQL> edxit
[oracle@s203116 db_1]$ opatch version
OPatch Version: 12.2.0.1.46
OPatch succeeded.
[oracle@s203116 db_1]$ cd OPatch
[oracle@s203116 OPatch]$ ./datapatch -verbose
SQL Patching tool version 12.1.0.2.0 Production on Thu Apr 17 11:36:40 2025
Copyright (c) 2012, 2016, Oracle. All rights reserved.
Log file for this invocation: /u01/product/oracle/cfgtoollogs/sqlpatch/sqlpatch_35919_2025_04_17_11_36_40/sqlpatch_invocation.log
Connecting to database...OK
Note: Datapatch will only apply or rollback SQL fixes for PDBs
that are in an open state, no patches will be applied to closed PDBs.
Please refer to Note: Datapatch: Database 12c Post Patch SQL Automation
(Doc ID 1585822.1)
Bootstrapping registry and package to current versions...done
Determining current state...done
Current state of SQL patches:
Patch 28440711 (Database PSU 12.1.0.2.181016, Oracle JavaVM Component (OCT2018)):
Installed in the binary registry and CDB$ROOT ORAJCTMBIZ ORAJCTMRBAC ORAJCTMSOL PDB$SEED
Bundle series PSU:
ID 220719 in the binary registry and ID 181016 in PDB CDB$ROOT, ID 181016 in PDB PDB$SEED, ID 181016 in PDB ORAJCTMBIZ, ID 181016 in PDB ORAJCTMSOL, ID 181016 in PDB ORAJCTMRBAC
Adding patches to installation queue and performing prereq checks...
Installation queue:
For the following PDBs: CDB$ROOT PDB$SEED ORAJCTMBIZ ORAJCTMSOL ORAJCTMRBAC
Nothing to roll back
The following patches will be applied:
34057742 (DATABASE PATCH SET UPDATE 12.1.0.2.220719)
Installing patches...
Patch installation complete. Total patches installed: 5
Validating logfiles...
Patch 34057742 apply (pdb CDB$ROOT): SUCCESS
logfile: /u01/product/oracle/cfgtoollogs/sqlpatch/34057742/24873298/34057742_apply_ORAJCTM_CDBROOT_2025Apr17_11_37_00.log (no errors)
Patch 34057742 apply (pdb PDB$SEED): WITH ERRORS
logfile: /u01/product/oracle/cfgtoollogs/sqlpatch/34057742/24873298/34057742_apply_ORAJCTM_PDBSEED_2025Apr17_11_39_09.log (errors)
Error at line 7973: ORA-04068: existing state of packages has been discarded
Error at line 7974: ORA-04065: not executed, altered or dropped stored procedure "SYS.DBMS_STATS"
Error at line 7975: ORA-06508: PL/SQL: could not find program unit being called: "SYS.DBMS_STATS"
Patch 34057742 apply (pdb ORAJCTMBIZ): WITH ERRORS
logfile: /u01/product/oracle/cfgtoollogs/sqlpatch/34057742/24873298/34057742_apply_ORAJCTM_ORAJCTMBIZ_2025Apr17_11_39_09.log (errors)
Error at line 1925: ORA-04068: existing state of packages has been discarded
Error at line 1926: ORA-04065: not executed, altered or dropped stored procedure "SYS.DBMS_STATS"
Error at line 1927: ORA-06508: PL/SQL: could not find program unit being called: "SYS.DBMS_STATS"
Patch 34057742 apply (pdb ORAJCTMSOL): WITH ERRORS
logfile: /u01/product/oracle/cfgtoollogs/sqlpatch/34057742/24873298/34057742_apply_ORAJCTM_ORAJCTMSOL_2025Apr17_11_39_09.log (errors)
Error at line 1925: ORA-04068: existing state of packages has been discarded
Error at line 1926: ORA-04065: not executed, altered or dropped stored procedure "SYS.DBMS_STATS"
Error at line 1927: ORA-06508: PL/SQL: could not find program unit being called: "SYS.DBMS_STATS"
Patch 34057742 apply (pdb ORAJCTMRBAC): WITH ERRORS
logfile: /u01/product/oracle/cfgtoollogs/sqlpatch/34057742/24873298/34057742_apply_ORAJCTM_ORAJCTMRBAC_2025Apr17_11_39_09.log (errors)
Error at line 1925: ORA-04068: existing state of packages has been discarded
Error at line 1926: ORA-04065: not executed, altered or dropped stored procedure "SYS.DBMS_STATS"
Error at line 1927: ORA-06508: PL/SQL: could not find program unit being called: "SYS.DBMS_STATS"
Please refer to MOS Note 1609718.1 and/or the invocation log
/u01/product/oracle/cfgtoollogs/sqlpatch/sqlpatch_35919_2025_04_17_11_36_40/sqlpatch_invocation.log
for information on how to resolve the above errors.
SQL Patching tool complete on Thu Apr 17 11:40:09 2025
此报错为数据库启动之后，同步业务已经发起，同步进程、日志挖掘进程已经开始运行，导致出现包编译失败。后续检查数据库状态正常，进行统计信息收集等，调用此包正常，并且数据库中查询，补丁已经注册到数据库中。
需要注意的是：在正式生产环境中进行不行安装，一定要停止所有业务，整改补丁安装、注册完成后，再启动业务。
[oracle@s203116 OPatch]$ sqlplus / as sysdba
SQL*Plus: Release 12.1.0.2.0 Production on Thu Apr 17 11:41:04 2025
Copyright (c) 1982, 2014, Oracle. All rights reserved.
Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
SQL> show pdbs CON_ID CON_NAME OPEN MODE RESTRICTED ---------- ------------------------------ ---------- ---------- 2 PDB$SEED READ ONLY YES 3 ORAJCTMBIZ READ WRITE NO 4 ORAJCTMSOL READ WRITE NO 5 ORAJCTMRBAC READ WRITE NO
至此，整个12.1.0.2单机补丁安装完成。
