当前位置： 首页 > news >正文

Oracle 12.1.0.2补丁安装全流程

news 来源：原创 2025/8/21 14:46:36

第一步，先进行备份

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单机补丁安装完成。

相关文章：

Oracle 12.1.0.2补丁安装全流程

第一步，先进行备份 tar -cvf u01.tar /u01 第二步，更新OPatch工具包 根据补丁包中readme信息汇总提示的信息，下载对应版本的OPatch工具包，本次下载的版本为： p6880880_122010_Linux-x86-64.zip opatch版本为最新的…...

编程日记 2025/8/21 14:46:36

第19章：基于efficientNet实现的视频内容识别系统

目录 1.efficientNet 网络 2. 猫和老鼠 3. QT推理 4. 项目 1.efficientNet 网络 本章做了一个视频内容识别的系统 本文选用的模型是efficientNet b0版本 EfficientNet 是 Google 团队在 2019 年提出的一系列高效卷积神经网络模型，其核心思想是通过复合缩放&…...

编程日记 2025/8/20 10:08:41

【Java面试系列】Spring Cloud微服务架构中的分布式事务解决方案与Seata框架实现原理详解 - 3-5年Java开发必备知识

【Java面试系列】Spring Cloud微服务架构中的分布式事务解决方案与Seata框架实现原理详解 - 3-5年Java开发必备知识 引言 在微服务架构中，分布式事务是一个不可避免的挑战。随着业务复杂度的提升，如何保证跨服务的数据一致性成为了面试中的高频问题。本…...

编程日记 2025/8/17 18:27:25

div（HTML标准元素）和view（微信小程序专用组件）的主要区别体

div（HTML标准元素）和view（微信小程序专用组件）的主要区别体现在以下方面： 一、应用场景与开发框架 ‌适用平台不同‌ div是HTML/CSS开发中通用的块级元素，用于Web页面布局‌；view是微信小程序专…...

编程日记 2025/8/21 14:43:11

AI在多Agent协同领域的核心概念、技术方法、应用场景及挑战 的详细解析

以下是 AI在多Agent协同领域的核心概念、技术方法、应用场景及挑战 的详细解析： 1. 多Agent协同的定义与核心目标 多Agent系统（MAS, Multi-Agent System）： 由多个独立或协作的智能体（Agent）组成&#xff…...

编程日记 2025/8/20 2:21:32

03_Americanas精益管理项目_StarRocks

文章目录 03_StarRocks（一）StarRocks简介1、什么是StarRocks【理解】1）概述2）适用场景2、系统架构【理解】1）系统架构图2）数据管理3、使用【熟悉】（二）表设计4、StarRocks表设计【理解】1）列式存储2）索引3）加速处理5、数据模型【掌握】5-1 明细模型1）适用场景2）创…...

编程日记 2025/8/19 13:23:04

CSS进度条带斑马纹动画(有效果图)

效果图 .wxml <view class"tb"><view class"tb-line" style"transform:translateX({{w%}})" /> </view> <button bind:tap"updateLine">增加进度</button>.js Page({data: {w:0,},updateLine(){this.…...

编程日记 2025/8/19 17:51:28

C++ static的使用方法及不同作用

在 C 里&#xff0c;static 是一个用途广泛的关键字&#xff0c;在不同场景下有不同含义&#xff0c;下面为你详细介绍&#xff1a; 1. 全局变量前的 static 当 static 用在全局变量前时&#xff0c;它会改变变量的链接属性。 默认全局变量&#xff1a;默认的全局变量具有外…...

编程日记 2025/8/20 7:29:48

CSS 美化页面（四）

一、浮动float属性 ‌属性值‌‌描述‌‌适用场景‌left元素向左浮动&#xff0c;腾出右侧空间供其他元素使用&#xff0c;其他内容会围绕在其右侧‌。横向排列元素&#xff08;如导航菜单&#xff09;、图文混排布局‌。right元素向右浮动&#xff0c;腾出左侧空间供其他元素使…...

编程日记 2025/8/17 20:47:45

驱动-原子操作

前面 对并发与竞争进行了实验&#xff0c; 两个 app 应用程序之间对共享资源的竞争访问引起了数据传输错误&#xff0c; 而在 Linux 内核中&#xff0c; 提供了四种处理并发与竞争的常见方法&#xff1a; 分别是原子操作、 自旋锁、 信号量、 互斥体&#xff0c; 这里了解下原子…...

编程日记 2025/8/20 5:03:34

Flutter ListView 详解

ListView 是 Flutter 中用于构建滚动列表的核心组件&#xff0c;支持垂直、水平滚动以及复杂的动态布局。本文将深入解析其核心用法、性能优化策略和高级功能实现&#xff0c;助你打造流畅高效的列表界面。 一、基础篇&#xff1a;快速构建各类列表 1. 垂直列表&#xff08;默…...

编程日记 2025/8/17 19:54:46

关于视频的一些算法内容，不包含代码等

视频算法&#xff1a; 视频降噪&#xff0c; 去除视频中的噪音&#xff0c;提高图像质量 工作原理&#xff1a; 时域降噪&#xff1a;利用相邻帧之间的相似性&#xff0c;通过平均或滤波来减少随机噪声。 空域降噪&#xff1a;在单帧内使用滤波器&#xff08;高斯滤波器&am…...

编程日记 2025/8/21 8:16:32

OpenCV 图形API（43）颜色空间转换-----将 BGR 图像转换为 LUV 色彩空间函数BGR2LUV()

操作系统&#xff1a;ubuntu22.04 OpenCV版本&#xff1a;OpenCV4.9 IDE:Visual Studio Code 编程语言&#xff1a;C11 算法描述 将图像从BGR色彩空间转换为LUV色彩空间。 该函数将输入图像从BGR色彩空间转换为LUV。B、G和R通道值的传统范围是0到255。 输出图像必须是8位无符…...

编程日记 2025/8/17 18:27:13

keil报错 ..\..\Libraries\CMSIS\stm32f10x.h(298): error: #67: expected a “}“

报错原因&#xff1a; 通常是由于启动文件、头文件定义或驱动选择不一致导致的。以下是一些具体的解决方案&#xff0c;可以帮助你解决这个问题&#xff1a; 检查步骤&#xff1a; 1. 检查启动文件 确保你的启动文件与你的芯片型号相匹配。例如&#xff0c;如果你的芯片是S…...

编程日记 2025/8/21 8:08:45

图像预处理-添加水印

一.ROI切割 类似裁剪图片&#xff0c;但是原理是基于Numpy数组的切片操作(ROI数组切片是会修改原图数据的)&#xff0c;也就是说这个“裁剪”不是为了保存“裁剪”部分&#xff0c;而是为了方便修改等处理。 import cv2 as cv import numpy as npimg cv.imread(../images/dem…...

编程日记 2025/8/19 11:39:13

扩展欧几里得算法【Exgcd】的内容与题目应用

1.简介 exgcd的目的是表示出二元一次不定方程的通解。 形式化地&#xff0c;exgcd算法就是输入a&#xff0c;b&#xff0c;c的值&#xff0c;返回一组x&#xff0c;y&#xff0c;满足 a x b y c axbyc axbyc。 2.1方程无整数解的情况 当 c 不能被 a &#xff0c;b最小公倍…...

编程日记 2025/8/18 20:25:41

OpenCV day5

函数内容接上文&#xff1a;OpenCV day4-CSDN博客 目录 9.cv2.adaptiveThreshold(): 10.cv2.split()&#xff1a; 11.cv2.merge()&#xff1a; 12.cv2.add()&#xff1a; 13.cv2.subtract()&#xff1a; 14.cv2.multiply()&#xff1a; 15.cv2.divide()&#xff1a; 1…...

编程日记 2025/8/19 14:27:07

Spring DI 详解

学习过 IoC 后&#xff0c;就知道我们可以将对象交给 Spring 进行管理&#xff0c;但是我们在一个类会有若干属性&#xff0c;也就是这个类依赖于这若干个属性&#xff0c;那么我们就可以将交给 Spring 管理的对象注入到这个类中&#xff0c;这也就是依赖注入。 依赖注入有三种…...

编程日记 2025/8/17 19:06:00

解锁动态规划的奥秘：从零到精通的创新思维解析（9）

前言&#xff1a; 小编在前几日写了关于动态规划中的多状态dp的问题&#xff0c;此时小编将会讲述一个动态规划我们常常会遇到的一类问题——股票问题&#xff0c;股票问题就类似小编上一篇所讲述的粉刷房子的问题&#xff0c;可以通过一个二维的dp表来代替多个一维的dp表。买卖…...

编程日记 2025/8/19 17:14:11

redis 配置日志和数据存储位置

Redis配置日志和数据存储位置 介绍 Redis是一个开源的高性能键值存储数据库&#xff0c;常用于缓存、消息队列和实时分析等场景。在使用Redis时&#xff0c;我们需要配置日志和数据存储位置&#xff0c;以便更好地管理和监控Redis的运行状态。本文将介绍如何配置Redis的日志和数…...

编程日记 2025/8/21 8:47:18

STL详解 - stack与queue的模拟实现

目录 一、容器适配器 1. 什么是适配器模式 2. stack与queue的底层结构 3. deque的原理与缺陷 3.1 deque的原理 3.2 deque的缺陷 4. 为何选择deque作为默认底层容器 二、stack与queue的模拟实现 1. stack的实现 2. queue的实现 一、容器适配器 1. 什么是适配器模式 适…...

编程日记 2025/8/17 20:55:22

Chromium 134 编译指南 macOS篇：获取源代码（四）

1. 引言 在Chromium 134的开发之旅中&#xff0c;获取源代码是一个至关重要的里程碑。本文将引导您完成这一关键步骤&#xff0c;为后续的编译和开发工作奠定坚实的基础。无论您是出于学习目的&#xff0c;还是计划开发自己的浏览器项目&#xff0c;掌握获取Chromium源码的方法…...

编程日记 2025/8/20 4:00:00

关于 IntelliJ IDEA 中频繁出现的 Kotlin 及其核心作用

关于 IntelliJ IDEA 中频繁出现的 Kotlin 及其核心作用 1. Kotlin 是什么&#xff1f; Kotlin 是由 JetBrains&#xff08;IntelliJ IDEA 的开发商&#xff09;设计的一种现代化编程语言&#xff0c;2016年正式发布&#xff0c;2017年被 Google 指定为 Android 官方开发语言。…...

编程日记 2025/8/20 14:07:54

MYOJ_11700(UVA10591)Happy Number(快乐数)(超快解法：图论思想解题)

原题(English) Let the sum of the square of the digits of a positive integer S0S0​ be represented by S1S1​. In a similar way, let the sum of the squares of the digits of S1S1​ be represented by S2S2​ and so on. If Si1Si​1 for some i≥1i≥1, then the or…...

编程日记 2025/8/19 17:14:14

2843. 统计对称整数的数目

2843. 统计对称整数的数目 题目链接&#xff1a;2843. 统计对称整数的数目 代码如下&#xff1a; class Solution { public:int countSymmetricIntegers(int low, int high) {int res 0;for (int i low;i < high;i) {string s to_string(i);int n s.size();if (n % 2 …...

编程日记 2025/8/21 1:27:56

【模块化拆解与多视角信息6】自我评价：人设构建的黄金50字——从无效堆砌到精准狙击的认知升级

写在最前 作为一个中古程序猿，我有很多自己想做的事情，比如埋头苦干手搓一个低代码数据库设计平台（目前只针对写java的朋友），比如很喜欢帮身边的朋友看看简历，讲讲面试技巧，毕竟工作这么多年，也做到过高管，有很多面人经历，意见还算有用，大家基本都能拿到想要的offe…...

编程日记 2025/8/17 21:28:14

ServletRequestAttributeListener 的用法笔记250417

ServletRequestAttributeListener 的用法笔记250417 以下是关于 ServletRequestAttributeListener 的用法详解&#xff0c;涵盖核心方法、实现步骤、典型应用场景及注意事项&#xff0c;帮助您有效监听请求级别属性&#xff08;ServletRequest 中的属性&#xff09;的变化&…...

编程日记 2025/8/17 21:38:46

大模型在胃十二指肠溃疡预测及诊疗方案制定中的应用研究

目录 一、引言 1.1 研究背景与目的 1.2 国内外研究现状 1.3 研究方法和创新点 二、大模型相关理论基础 2.1 大模型的基本原理 2.2 适用于医疗领域的大模型类型 2.3 大模型在医疗领域的应用现状和潜力 三、胃十二指肠溃疡的疾病特征 3.1 疾病概述 3.2 诊断方法 3.3 …...

编程日记 2025/8/17 17:59:56

第九节：React HooksReact 18+新特性-React 19的use钩子如何简化异步操作？

对比&#xff1a;useEffect vs use处理Promise 代码题&#xff1a;用use改写数据请求逻辑 React 19 use 钩子&#xff1a;异步操作革命性简化方案&#xff08;附完整代码对比&#xff09; 一、useEffect vs use 处理 Promise 核心差异对比 对比维度useEffect 方案use 钩子方案…...

编程日记 2025/8/16 22:57:39

【React】项目的搭建

create-react-app 搭建vite 搭建相关下载 在Vue中搭建项目的步骤&#xff1a;1.首先安装脚手架的环境&#xff0c;2.通过脚手架的指令创建项目 在React中有两种方式去搭建项目&#xff1a;1.和Vue一样&#xff0c;先安装脚手架然后通过脚手架指令搭建&#xff1b;2.npx create-…...

编程日记 2025/8/17 20:15:36

方案精读：华为数字化转型实践案例合集【附全文阅读】

华为数字化转型旨在通过数字化变革实现全连接的智能华为，成为行业标杆，提升客户满意度和运营效率。其以客户为中心，基于 “双轮驱动” 理念，从转意识、方法、文化、组织、模式等方面入手，构建数字化平台，推进数据治理，保障安全，开展业务重构。通过合同 360、产品设计与…...

编程日记 2025/8/17 20:09:43

VScode使用Pyside6（环境篇）

Pyside6的环境搭建&#xff1a; cmd命令窗口输入&#xff1a;pip install pyside6 使用everthing进行查找&#xff1a;&#xff08;非常好用的一款搜索工具 &#xff09; 进入PySide6文件夹中&#xff0c;点击designer.exe,查看是否能够点开。 VScode环境搭建&#xff1a; 下…...

编程日记 2025/8/19 23:08:38

智能云图库-12-DDD重构

本节重点​ 之前我们已经完成了本项目的功能开发。由于本项目功能丰富、代码量大&#xff0c;如果是在企业中维护开发的项目&#xff0c;传统的 MVC 架构可能会让后续的开发协作越来越困难。所以本节鱼皮要从 0 带大家学习一种新的架构设计模式 —— DDD 领域驱动设计。 大纲…...

编程日记 2025/8/19 4:04:18

Linux 网络配置

文章目录 网络基础知识IP地址子网掩码DNS Linux操作系统网络配置 网络基础知识 IP地址 IP地址是用于区分同一个网络中的不同主机的唯一标识。 Internet中的主机要与其他机器通信必须具有一个IP地址&#xff0c;因为网络中传输的数据包必须携带目的IP地址和源IP地址&#xff…...

编程日记 2025/8/20 6:33:43

05-DevOps-Jenkins自动拉取构建代码2

通过前面的操作&#xff0c;已经成功完成了源代码的打包工作&#xff0c;具体操作参见下面的文章&#xff1a; 05-DevOps-Jenkins自动拉取构建代码-CSDN博客 验证打包文件 验证打包后的文件是否存在&#xff0c;进入到Jenkins的工作目录中&#xff0c;找到对应的jar包&#x…...

编程日记 2025/8/19 1:28:58

ESP32之OTA固件升级流程，基于VSCode环境下的ESP-IDF开发，基于阿里云物联网平台MQTT-TLS连接通信（附源码）

目录 1.创建产品和设备 2.准备工作 2.1 获取基础工程 2.2 基本知识概述 2.2.1 OTA升级流程 2.2.2 主题和数据格式 &#xff08;1&#xff09;设备上报版本号 ①请求主题&#xff08;设备 -> 阿里云&#xff09;&#xff1a; ②响应主题&#xff08;阿里云->设备…...

编程日记 2025/8/17 21:38:38

【秣厉科技】LabVIEW工具包——OpenCV 教程（20）：拾遗 - imgproc 基础操作（下）

文章目录 前言imgproc 基础操作&#xff08;下&#xff09;8. 霍夫检测9. 滤波与模糊10. 拟合与包围 总结 前言 需要下载安装OpenCV工具包的朋友&#xff0c;请前往 此处 &#xff1b;系统要求&#xff1a;Windows系统&#xff0c;LabVIEW>2018&#xff0c;兼容32位和64位。…...

编程日记 2025/8/21 1:31:43

kafka发送消息，同时支持消息压缩和不压缩

1、生产者配置 nacos中增加配置&#xff0c;和公共spring-kafka配置字段有区分 需要发送压缩消息时&#xff0c;使用该配置类发送即可 import org.apache.kafka.clients.producer.ProducerConfig; import org.springframework.beans.factory.annotation.Autowired; import or…...

编程日记 2025/8/19 4:55:39

AOSP世界时间的更新

在 AOSP&#xff08;Android Open Source Project&#xff09;中&#xff0c;世界时间的更新主要涉及设备时区数据的管理和更新&#xff0c;以确保设备能够正确显示全球各地的时间。AOSP 依赖 IANA 时区数据库&#xff08;也称为 tzdata&#xff09;来提供时区规则和世界时间数…...

编程日记 2025/8/19 14:07:43

Python + 链上数据可视化：让区块链数据“看得懂、用得上”

Python + 链上数据可视化：让区块链数据“看得懂、用得上” 区块链技术的透明性和去中心化特性，使得链上数据成为金融、供应链、NFT 以及 DeFi 领域的关键参考。可是，对于普通用户而言，链上数据往往晦涩难懂，难以直接利用。那么，如何利用 Python 提取、分析并直观展示链上…...

编程日记 2025/8/19 16:02:33

方德桌面操作系统V5.0-G23 vim无法复制粘贴内容

1.修改 Vim 配置文件 rootyuhua-virtualmachine:/etc/docker# sudo vim /usr/share/vim/vim82/defaults.vim 2.在第82行找到set mousea行&#xff0c;将其为set mouse-a。如果文件中没有set mousea&#xff0c;则修改添加set mouse-a。 3.保存文件并退出 Vim&#xff1a; 4…...

编程日记 2025/8/18 21:57:29

[linux] vim 乱码

1. 确保终端支持中文 设置终端编码为 UTF-8，运行： echo $LANG如果不是 UTF-8（如 en_US.UTF-8），你可以设置为： export LANG=zh_CN.UTF-8 export LC_ALL=zh_CN.UTF-8 2. 确保 Vim 使用 UTF-8 编码 打开 .vimrc 或输入以下命令： :set encoding=utf-8 :set fileencodin…...

编程日记 2025/8/20 21:34:52

天洑参加人工智能校企产学研及人才对接活动——走进南京大学人工智能学院

4月15日&#xff0c;人工智能校企产学研及人才对接——走进南京大学人工智能学院活动在南京大学成功举办。此次活动由江苏省人工智能学会、南京大学人工智能学院主办&#xff0c;江苏省工业和信息化厅党组成员、副厅长池宇&#xff0c;南京大学副校长周志华出席。江苏省工业和信…...

编程日记 2025/8/19 7:20:26

33、单元测试实战练习题

以下是三个练习题的具体实现方案&#xff0c;包含完整代码示例和详细说明&#xff1a; 练习题1&#xff1a;TDD实现博客评论功能 步骤1&#xff1a;编写失败测试 # tests/test_blog.py import unittest from blog import BlogPost, Comment, InvalidCommentErrorclass TestBl…...

编程日记 2025/8/17 18:24:39

《AI大模型应知应会100篇》第22篇：系统提示词(System Prompt)设计与优化

第22篇&#xff1a;系统提示词(System Prompt)设计与优化 摘要 在大语言模型&#xff08;LLM&#xff09;应用中&#xff0c;系统提示词&#xff08;System Prompt&#xff09;是控制模型行为的核心工具之一。它不仅定义了模型的身份、角色和行为规范&#xff0c;还直接影响输…...

编程日记 2025/8/17 18:26:51

【KWDB 创作者计划】_深度学习篇---松科AI加速棒

文章目录 前言一、简介二、安装与配置硬件连接驱动安装软件环境配置三、使用步骤初始化设备调用SDK接口检测设备状态：集成到AI项目四、注意事项兼容性散热固件更新安全移除五、硬件架构与技术规格核心芯片专用AI处理器内存配置接口类型物理接口虚拟接口能效比散热设计六、软件…...

编程日记 2025/8/20 20:55:22

【Quest开发】在虚拟世界设置具有遮挡关系的透视窗口

软件&#xff1a;Unity 2022.3.51f1c1、vscode、Meta XR All in One SDK V72 硬件&#xff1a;Meta Quest3 仅针对urp管线 参考了YY老师这篇&#xff0c;可以先看他的再看这个可能更好理解一些&#xff1a;Unity Meta Quest MR 开发&#xff08;七&#xff09;&#xff1a;使…...

编程日记 2025/8/17 21:27:24

Spark on K8s 在vivo大数据平台的混部实战

作者&#xff1a;vivo 互联网大数据团队- Qin Yehai 在离线混部可以提高整体的资源利用率&#xff0c;不过离线Spark任务部署到混部容器集群需要做一定的改造&#xff0c;本文将从在离线混部中的离线任务的角度&#xff0c;讲述离线任务是如何进行容器化、平台上的离线任务如何…...

编程日记 2025/8/20 15:28:08

Mac配置Java的环境变量

刚拿到手的Mac mini M4如何去设置java的环境变量&#xff1f; 第一步&#xff1a; 首先&#xff0c;你先下载好intelliJ IDEA&#xff0c;然后在里面自带的jdk列表里选择你自己想要使用的jdk的版本以及供应商。 下面是我自己使用的jdk版本以及供应商&#xff1a; 第二步&am…...

编程日记 2025/8/17 18:29:47

RPCRT4!OSF_CCONNECTION::OSF_CCONNECTION函数分析之创建一个RPCRT4!OSF_CCALL--RPC源代码分析

RPCRT4!OSF_CCONNECTION::OSF_CCONNECTION函数分析之创建一个RPCRT4!OSF_CCALL 第一部分&#xff1a; 1: kd> p RPCRT4!OSF_CCONNECTION::OSF_CCONNECTION0x167: 001b:77bf6957 393dec35c877 cmp dword ptr [RPCRT4!gfRPCVerifierEnabled (77c835ec)],edi 1: kd> …...

编程日记 2025/8/17 18:21:54