打补丁17030189

环境：

OS:Centos 6.9

db:11.2.0.4

ogg:21C

 

1.解压
su - oracle
unzip -d <PATCH_TOP_DIR> p17030189_112040_Generic.zip

 

2.检查是否有冲突

[oracle@localhost 17030189]$cd <PATCH_TOP_DIR>/17030189
[oracle@localhost 17030189]$ /u01/app/oracle/product/11.2.0.4/db_1/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -ph ./
Oracle Interim Patch Installer version 11.2.0.3.4
Copyright (c) 2012, Oracle Corporation.  All rights reserved.

PREREQ session

Oracle Home       : /u01/app/oracle/product/11.2.0.4/db_1
Central Inventory : /u01/app/oraInventory
   from           : /u01/app/oracle/product/11.2.0.4/db_1/oraInst.loc
OPatch version    : 11.2.0.3.4
OUI version       : 11.2.0.4.0
Log file location : /u01/app/oracle/product/11.2.0.4/db_1/cfgtoollogs/opatch/opatch2022-10-13_01-15-06AM_1.log

Invoking prereq "checkconflictagainstohwithdetail"

Prereq "checkConflictAgainstOHWithDetail" passed.

OPatch succeeded.

 

3.打补丁

cd <PATCH_TOP_DIR>/17030189
/u01/app/oracle/product/11.2.0.4/db_1/OPatch/opatch apply
/u01/app/oracle/product/11.2.0.4/db_1/OPatch/opatch lsinventory

Patch  17030189     : applied on Thu Oct 13 01:18:29 GMT 2022
Unique Patch ID:  21118136
   Created on 17 May 2017, 17:43:14 hrs PST8PDT
   Bugs fixed:
     17030189

 

4.执行数据库脚本
$ sqlplus /nolog
SQL> CONNECT / AS SYSDBA
SQL> @/soft/patch/17030189/postinstall.sql