Data Pump (DPBP) Patching

Overview

The following session covers patching Data Pump (AKA DPBP).

Review MOS Doc ID 2819284.1 Data Pump Recommended Proactive Patches For 19.10 and Above and make the required changes to the below for your environment.

Session

 -- Prep: Copy then Unzip Patch File
 cp /u04/sccu/patches/DPBP/p39657094_1932000DBRU_Generic.zip /u01/orasw/patches
 Perform below as the oracle user.

 cd /u01/orasw/patches
 unzip p39657094_1932000DBRU_Generic.zip

  -- Execute opatch
 SQLPLUS> shutdown immediate
 lsnrctl stop

 export CV_ASSUME_DISTID=OEL8.1;export PATH=$PATH:/usr/ccs/bin;export PATH=$PATH:$ORACLE_HOME/OPatch;cd $ORACLE_HOME/OPatch
 ./opatch apply /u01/orasw/patches/39657094
     All checks passed.
     Backing up files...
     Applying interim patch '39657094' to OH '/u01/app/oracle/product/19.3.0.0.0/dbhome_1'
     ...
     OPatch succeeded.

 -- Execute datapatch (assume still in $ORACLE_HOME/OPatch)
 lsnrctl start
 SQLPLUS> startup

 >>> Only do on PRIMARY of a Data Guard (DG) env or if not in DG env.
 ./datapatch -verbose
    Connecting to database...OK
    Gathering database info...done
    Bootstrapping registry and package to current versions...done
    Determining current state...done
    ...
    Patch 39657094 apply: SUCCESS

 SQLPLUS> @?/rdbms/admin/utlrp.sql

 -- Get Patch Status
 SELECT patch_id, action, status, description
 FROM dba_registry_sqlpatch
 WHERE patch_id=39657094;