Oracle 12.1.0.2补丁安装全流程

最新推荐文章于 2025-09-19 09:57:04 发布

原创

最新推荐文章于 2025-09-19 09:57:04 发布 · 1k 阅读

16 ·

CC 4.0 BY-SA版权

文章标签：

#oracle #数据库

第一步，先进行备份

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

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

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

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

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]

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]

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'