Data Pump Bundle Patches DATAPUMP BUNDLE PATCH 19.31.0.0.0
============================================================
unzip p6880880_190000_Linux-x86-64.zip -d $ORACLE_HOME/
export PATH=$ORACLE_HOME/OPatch:$PATH
$ORACLE_HOME/OPatch/opatch version
OPatch Version: 12.2.0.1.51 datapach version !!!
OPatch succeeded.
# No need to shutdown the database #
Description DATAPUMP BUNDLE PATCH 19.31.0.0.0
Product Oracle Database Family
Release
Oracle Database 19.31.0.0.0 DBRU
https://updates.oracle.com/Orion/PatchDetails/process_form?patch_num=39196236
[oracle@oracent19c ~]$ ls -lth p39196236_1931000DBRU_Generic.zip
-rw-r--r--. 1 oracle oinstall 2.7M May 2 14:21 p39196236_1931000DBRU_Generic.zip
[oracle@oracent19c ~]$
cd 39034528
[oracle@oracent19c 39034528]$ export PATH=$ORACLE_HOME/OPatch:$PATH
[oracle@oracent19c 39034528]$ opatch prereq CheckConflictAgainstOHWithDetail -ph ./
Oracle Interim Patch Installer version 12.2.0.1.51
Copyright (c) 2026, Oracle Corporation. All rights reserved.
PREREQ session
Oracle Home : /u01/app/oracle/product/19c/db_1
Central Inventory : /u01/app/oraInventory
from : /u01/app/oracle/product/19c/db_1/oraInst.loc
OPatch version : 12.2.0.1.51
OUI version : 12.2.0.7.0
Log file location : /u01/app/oracle/product/19c/db_1/cfgtoollogs/opatch/opatch2026-05-02_14-01-19PM_1.log
Invoking prereq "checkconflictagainstohwithdetail"
Prereq "checkConflictAgainstOHWithDetail" passed.
OPatch succeeded.
[oracle@oracent19c 39034528]$
Description DATAPUMP BUNDLE PATCH 19.31.0.0.0
Product Oracle Database Family
Release
Oracle Database 19.31.0.0.0 DBRU
export PATH=$ORACLE_HOME/OPatch:$PATH
$ORACLE_HOME/OPatch/opatch version
OPatch Version: 12.2.0.1.51
cd 39196236
[oracle@oracent19c 39196236]$ opatch prereq CheckConflictAgainstOHWithDetail -ph ./
Oracle Interim Patch Installer version 12.2.0.1.51
Copyright (c) 2026, Oracle Corporation. All rights reserved.
PREREQ session
Oracle Home : /u01/app/oracle/product/19c/db_1
Central Inventory : /u01/app/oraInventory
from : /u01/app/oracle/product/19c/db_1/oraInst.loc
OPatch version : 12.2.0.1.51
OUI version : 12.2.0.7.0
Log file location : /u01/app/oracle/product/19c/db_1/cfgtoollogs/opatch/opatch2026-05-02_15-42-30PM_1.log
Invoking prereq "checkconflictagainstohwithdetail"
Prereq "checkConflictAgainstOHWithDetail" passed.
OPatch succeeded.
[oracle@oracent19c 39196236]$
[oracle@oracent19c 39196236]$ opatch prereq CheckConflictAgainstOHWithDetail -ph ./
Oracle Interim Patch Installer version 12.2.0.1.51
Copyright (c) 2026, Oracle Corporation. All rights reserved.
PREREQ session
Oracle Home : /u01/app/oracle/product/19c/db_1
Central Inventory : /u01/app/oraInventory
from : /u01/app/oracle/product/19c/db_1/oraInst.loc
OPatch version : 12.2.0.1.51
OUI version : 12.2.0.7.0
Log file location : /u01/app/oracle/product/19c/db_1/cfgtoollogs/opatch/opatch2026-05-02_15-42-30PM_1.log
Invoking prereq "checkconflictagainstohwithdetail"
Prereq "checkConflictAgainstOHWithDetail" passed.
OPatch succeeded.
==== apply !!!!!!!!!!
[oracle@oracent19c 39196236]$
[oracle@oracent19c 39196236]$ opatch apply
Oracle Interim Patch Installer version 12.2.0.1.51
Copyright (c) 2026, Oracle Corporation. All rights reserved.
Oracle Home : /u01/app/oracle/product/19c/db_1
Central Inventory : /u01/app/oraInventory
from : /u01/app/oracle/product/19c/db_1/oraInst.loc
OPatch version : 12.2.0.1.51
OUI version : 12.2.0.7.0
Log file location : /u01/app/oracle/product/19c/db_1/cfgtoollogs/opatch/opatch2026-05-02_15-43-44PM_1.log
Verifying environment and performing prerequisite checks...
OPatch continues with these patches: 39196236
Do you want to proceed? [y|n]
y
User Responded with: Y
All checks passed.
Backing up files...
Applying interim patch '39196236' to OH '/u01/app/oracle/product/19c/db_1'
Patching component oracle.rdbms.dbscripts, 19.0.0.0.0...
Patching component oracle.rdbms, 19.0.0.0.0...
Patch 39196236 successfully applied.
Log file location: /u01/app/oracle/product/19c/db_1/cfgtoollogs/opatch/opatch2026-05-02_15-43-44PM_1.log
OPatch succeeded.
===============================
./datapatch
pwd
/home/oracle/39196236
[oracle@oracent19c 39196236]$ cd $ORACLE_HOME/
[oracle@oracent19c db_1]$ cd OPatch/
[oracle@oracent19c OPatch]$ ./datapatch -verbose
SQL Patching tool version 19.31.0.0.0 Production on Sat May 2 15:49:11 2026
Copyright (c) 2012, 2026, Oracle. All rights reserved.
Log file for this invocation: /u01/app/oracle/cfgtoollogs/sqlpatch/sqlpatch_19850_2026_05_02_15_49_11/sqlpatch_invocation.log
Connecting to database...OK
Gathering database info...done
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 interim SQL patches:
Interim patch 39196236 (DATAPUMP BUNDLE PATCH 19.31.0.0.0):
Binary registry: Installed
PDB CDB$ROOT: Not installed
PDB PDB$SEED: Not installed
PDB VIHAAN: Not installed
Current state of release update SQL patches:
Binary registry:
19.31.0.0.0 Release_Update 260426152757: Installed
PDB CDB$ROOT:
Applied 19.31.0.0.0 Release_Update 260426152757 successfully on 02-MAY-26 14.56.22.830803
PDB PDB$SEED:
Applied 19.31.0.0.0 Release_Update 260426152757 successfully on 02-MAY-26 15.22.20.360343
PDB VIHAAN:
Applied 19.31.0.0.0 Release_Update 260426152757 successfully on 02-MAY-26 15.22.33.737706
Adding patches to installation queue and performing prereq checks...done
Installation queue:
For the following PDBs: CDB$ROOT PDB$SEED VIHAAN
No interim patches need to be rolled back
No release update patches need to be installed
The following interim patches will be applied:
39196236 (DATAPUMP BUNDLE PATCH 19.31.0.0.0)
Installing patches...
Patch installation complete. Total patches installed: 3
Validating logfiles...done
Patch 39196236 apply (pdb CDB$ROOT): SUCCESS
logfile: /u01/app/oracle/cfgtoollogs/sqlpatch/39196236/28705537/39196236_apply_ORCL_CDBROOT_2026May02_15_50_04.log (no errors)
Patch 39196236 apply (pdb PDB$SEED): SUCCESS
logfile: /u01/app/oracle/cfgtoollogs/sqlpatch/39196236/28705537/39196236_apply_ORCL_PDBSEED_2026May02_15_56_54.log (no errors)
Patch 39196236 apply (pdb VIHAAN): WITH ERRORS (RETRYABLE)
logfile: /u01/app/oracle/cfgtoollogs/sqlpatch/39196236/28705537/39196236_apply_ORCL_VIHAAN_2026May02_15_56_54.log (errors)
-> Error at line 4097: script rdbms/admin/dpload.sql
- ORA-00604: error occurred at recursive SQL level 1
- ORA-00060: deadlock detected while waiting for resource
Adding patches to retry installation queue...done
Retry installation queue:
For the following PDBs: VIHAAN
No interim patches need to be rolled back
No release update patches need to be installed
The following interim patches will be applied:
39196236 (DATAPUMP BUNDLE PATCH 19.31.0.0.0)
Installing patches...
Patch installation complete. Total patches installed: 1
Validating logfiles...done
Patch 39196236 apply (pdb VIHAAN): SUCCESS
logfile: /u01/app/oracle/cfgtoollogs/sqlpatch/39196236/28705537/39196236_apply_ORCL_VIHAAN_2026May02_16_15_56.log (no errors)
SQL Patching tool complete on Sat May 2 16:25:29 2026
[oracle@oracent19c OPatch]$
@?/rdbms/admin/utlrp.sql
====
[oracle@oracent19c ~]$ opatch lspatches
39196236;DATAPUMP BUNDLE PATCH 19.31.0.0.0 <<<<<<<<<<<<<<<<<<<<<<<<
39034528;Database Release Update : 19.31.0.0.260421 (39034528)
29585399;OCW RELEASE UPDATE 19.3.0.0.0 (29585399)
OPatch succeeded.
==============
Readme
[oracle@oracent19c ~]$ cd 39196236/
[oracle@oracent19c 39196236]$ ls -ltr
total 28
-rw-rw-r--. 1 oracle oinstall 28585 Apr 29 15:21 README.txt
drwxr-x---. 4 oracle oinstall 35 Apr 29 15:21 files
drwxr-x---. 3 oracle oinstall 20 Apr 29 15:21 etc
[oracle@oracent19c 39196236]$ cat README.txt
Oracle Database 19 Release 19.31.0.0.260421DBRU
ORACLE DATABASE Patch for Bug# 39196236 for Generic Platforms
This patch is NOT RAC Rolling Installable.
This patch is Data Guard Standby-First Installable - Please read My Oracle Support Note (KB137118) Oracle Patch Assurance - Data Guard Standby-First Patch Apply for details on how to remove risk and reduce downtime when applying this patch. https://support.oracle.com/support/?documentId=KB137118
Released: Wed Apr 29 12:34:38 2026
This document describes how you can install the ORACLE DATABASE overlay patch for bug# 39196236 on your Oracle Database 19 Release 19.31.0.0.260421DBRU
Note: This patch can be applied without shutting down the Database Services.
(I) Prerequisites
--------------------
Before you install or deinstall the patch, ensure that you meet the following requirements:
Note: In case of an Oracle RAC environment, meet these prerequisites on each of the nodes.
1. Ensure that the Oracle home on which you are installing the patch or from which you are rolling back the patch is Oracle Database 19 Release 19.31.0.0.260421DBRU.
2. Ensure that 19 Release 19.31.0.0.260421DBRU Patch Set Update (PSU) 39034528 is already applied on the Oracle Database.
3. Ensure that you have OPatch 19 Release 12.2.0.1.49 or higher. Oracle recommends that you use the latest version available for 19 Release 12.2.0.1.49.
Note:
If you do not have OPatch 19 Release 12.2.0.1.49 or the latest version available for 19 Release 12.2.0.1.49, then download it from patch# 6880880 for 12.2.0.1.49.
For information about OPatch documentation, including any known issues, see My Oracle Support Document (KB151684) Latest Version of OPatch(6880880) https://support.oracle.com/support/?documentId=KB151684
4. Ensure that you set (as the home user) the ORACLE_HOME environment variable to the Oracle home.
5. Ensure that the $PATH definition has the following executables: make, ar, ld and nm. The location of these executables depends on your operating system. On many operating systems, they are located in /usr/ccs/bin.
6. Ensure that you verify the Oracle Inventory because OPatch accesses it to install the patches. To verify the inventory, run the following command.
$ opatch lsinventory
Note:
- If this command succeeds, it will list the Top-Level Oracle Products and one-off patches if any that are installed in the Oralce Home.
- Save the output so you have the status prior to the patch apply.
- If the command displays some errors, then contact Oracle Support and resolve the issue first before proceeding further.
7. (Only for Installation) Maintain a location for storing the contents of the patch ZIP file. In the rest of the document, this location (absolute path) is referred to as <PATCH_TOP_DIR>. Extract the contents of the patch ZIP file to the location (PATCH_TOP_DIR) you have created above. To do so, run the following command:
$ unzip -d <PATCH_TOP_DIR> p39196236_1931000DBRU_Generic.zip
8. (Only for Installation) Determine whether any currently installed interim patches conflict with this patch 39196236 as shown below:
$ cd <PATCH_TOP_DIR>/39196236
$ opatch prereq CheckConflictAgainstOHWithDetail -ph ./
The report will indicate the patches that conflict with this patch and the patches for which the current 39196236 is a superset.
Note:
When OPatch starts, it validates the patch and ensures that there are no conflicts with the software already installed in the ORACLE_HOME. OPatch categorizes conflicts into the following types:
- Conflicts with a patch already applied to the ORACLE_HOME that is a subset of the patch you are trying to apply - In this case, continue with the patch installation because the new patch contains all the fixes from the existing patch in the ORACLE_HOME. The subset patch will automatically be rolled back prior to the installation of the new patch.
- Conflicts with a patch already applied to the ORACLE_HOME - In this case, stop the patch installation and contact Oracle Support Services.
10. None
(II) Installation
-----------------
To install the patch, follow these steps:
1. Set your current directory to the directory where the patch is located and then run the OPatch utility by entering the following commands:
$ cd <PATCH_TOP_DIR>/39196236
$ opatch apply
2. Verify whether the patch has been successfully installed by running the following command:
$ opatch lsinventory
(III) Postinstallation
---------------------
1. Navigate to the <ORACLE_HOME>/OPatch directory:
$ cd <ORACLE_HOME>/OPatch
2. Install the SQL portion of the patch by running the following command:
$ datapatch
3. Start sqlplus and run the utlrp.sql to clear the invalids only if dpload.sql is a part of the patch
SQL> @?/rdbms/admin/utlrp.sql
Note: For a RAC environment, perform these steps on only one node.
(IV) Deinstallation
----------------------
Ensure to follow the Prerequsites (Section I). To deinstall the patch, follow these steps:
1. Deinstall the patch by running the following command:
$ opatch rollback -id 39196236
2. Ensure that you verify the Oracle Inventory and compare the output with the one run before the patch installation and re-apply any patches that were rolled back as part of this patch apply. To verify the inventory, run the following command:
$ opatch lsinventory
(V) Postdeinstallation
-----------------------
1. Navigate to the <ORACLE_HOME>/OPatch directory:
$ cd <ORACLE_HOME>/OPatch
2. Deinstall the SQL portion of the patch by running the following command:
$ datapatch
3. Start sqlplus and run the utlrp.sql to clear the invalids only if dpload.sql is a part of the patch
SQL> @?/rdbms/admin/utlrp.sql
No comments:
Post a Comment