19.3 安装最新 19.11 RU

安装最新opatch,版本最低要求：

MOS ID: 6880880 

OPatch utility version 12.2.0.1.24 

unzip p6880880_122010_Linux-x86-64.zip
rm -rf /u01/app/19.3/OPatch/
mv OPatch/ /u01/app/19.3/
/u01/app/19.3/OPatch/opatch version
OPatch Version: 12.2.0.1.25

OPatch succeeded.

安装RU,停止数据软件和监听

[oracle@db01 soft]$ unzip p32545013_190000_Linux-x86-64.zip 
[oracle@db01 soft]$ cd 32545013/
[oracle@db01 32545013]$ /u01/app/19.3/OPatch/opatch apply

安装日志：

[oracle@db01 32545013]$ /u01/app/19.3/OPatch/opatch apply
Oracle Interim Patch Installer version 12.2.0.1.25
Copyright (c) 2021, Oracle Corporation.  All rights reserved.


Oracle Home       : /u01/app/19.3
Central Inventory : /u01/app/oraInventory
   from           : /u01/app/19.3/oraInst.loc
OPatch version    : 12.2.0.1.25
OUI version       : 12.2.0.7.0
Log file location : /u01/app/19.3/cfgtoollogs/opatch/opatch2021-05-20_16-53-10PM_1.log

Verifying environment and performing prerequisite checks...
OPatch continues with these patches:   32545013

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/app/19.3')


Is the local system ready for patching? [y|n]
y
User Responded with: Y
Backing up files...
Applying interim patch '32545013' to OH '/u01/app/19.3'
ApplySession: Optional component(s) [ oracle.network.gsm, 19.0.0.0.0 ] , [ oracle.rdbms.ic, 19                           .0.0.0.0 ] , [ oracle.rdbms.tg4db2, 19.0.0.0.0 ] , [ oracle.tfa, 19.0.0.0.0 ] , [ oracle.optio                           ns.olap.api, 19.0.0.0.0 ] , [ oracle.ons.cclient, 19.0.0.0.0 ] , [ oracle.options.olap, 19.0.0                           .0.0 ] , [ oracle.network.cman, 19.0.0.0.0 ] , [ oracle.oid.client, 19.0.0.0.0 ] , [ oracle.on                           s.eons.bwcompat, 19.0.0.0.0 ] , [ oracle.net.cman, 19.0.0.0.0 ] , [ oracle.xdk.companion, 19.0                           .0.0.0 ] , [ oracle.jdk, 1.8.0.191.0 ]  not present in the Oracle Home or a higher version is                            found.

Patching component oracle.rdbms.rsf, 19.0.0.0.0...

********************
*******************
*******************

Patching component oracle.precomp.lang, 19.0.0.0.0...

Patching component oracle.jdk, 1.8.0.201.0...
Patch 32545013 successfully applied.
Sub-set patch [29517242] has become inactive due to the application of a super-set patch [32545013].
Please refer to Doc ID 2161861.1 for any possible further required actions.
Log file location: /u01/app/19.3/cfgtoollogs/opatch/opatch2021-05-20_16-53-10PM_1.log

OPatch succeeded.

补丁信息检测： 已经成功应用到19.11

[oracle@db01 32545013]$ /u01/app/19.3/OPatch/opatch lspatches
32545013;Database Release Update : 19.11.0.0.210420 (32545013)
29585399;OCW RELEASE UPDATE 19.3.0.0.0 (29585399)

OPatch succeeded.

数据库补丁升级，打开数据库：

SQL> show pdbs;

    CON_ID CON_NAME                       OPEN MODE  RESTRICTED
---------- ------------------------------ ---------- ----------
         2 PDB$SEED                       READ ONLY  NO
         3 PDB                            READ WRITE NO

[oracle@db01 32545013]$ cd /u01/app/19.3/OPatch/
[oracle@db01 OPatch]$ ./datapatch -verbose
SQL Patching tool version 19.11.0.0.0 Production on Thu May 20 17:03:07 2021
Copyright (c) 2012, 2021, Oracle.  All rights reserved.

Log file for this invocation: /u01/app/oracle/cfgtoollogs/sqlpatch/sqlpatch_50200_2021_05_20_17_03_07/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...

Current state of interim SQL patches:
  No interim patches found

Current state of release update SQL patches:
  Binary registry:
    19.11.0.0.0 Release_Update 210413004009: Installed
  PDB CDB$ROOT:
    Applied 19.3.0.0.0 Release_Update 190410122720 successfully on 20-MAY-21 04.27.26.941542 PM
  PDB PDB:
    Applied 19.3.0.0.0 Release_Update 190410122720 successfully on 20-MAY-21 04.34.43.870673 PM
  PDB PDB$SEED:
    Applied 19.3.0.0.0 Release_Update 190410122720 successfully on 20-MAY-21 04.34.43.870673 PM

Adding patches to installation queue and performing prereq checks...done
Installation queue:
  For the following PDBs: CDB$ROOT PDB$SEED PDB
    No interim patches need to be rolled back
    Patch 32545013 (Database Release Update : 19.11.0.0.210420 (32545013)):
      Apply from 19.3.0.0.0 Release_Update 190410122720 to 19.11.0.0.0 Release_Update 210413004009
    No interim patches need to be applied

Installing patches...
Patch installation complete.  Total patches installed: 3

Validating logfiles...done
Patch 32545013 apply (pdb CDB$ROOT): SUCCESS
  logfile: /u01/app/oracle/cfgtoollogs/sqlpatch/32545013/24175065/32545013_apply_CDB01_CDBROOT_2021May20_17_03_40.log (no errors)
Patch 32545013 apply (pdb PDB$SEED): SUCCESS
  logfile: /u01/app/oracle/cfgtoollogs/sqlpatch/32545013/24175065/32545013_apply_CDB01_PDBSEED_2021May20_17_09_48.log (no errors)
Patch 32545013 apply (pdb PDB): SUCCESS
  logfile: /u01/app/oracle/cfgtoollogs/sqlpatch/32545013/24175065/32545013_apply_CDB01_PDB_2021May20_17_09_49.log (no errors)
SQL Patching tool complete on Thu May 20 17:17:19 2021

补丁安装检查：

SQL> select patch_id,action,status from dba_registry_sqlpatch;

  PATCH_ID ACTION          STATUS
---------- --------------- -------------------------
  29517242 APPLY           SUCCESS
  32545013 APPLY           SUCCESS

重新编译无效对象：

cd $ORACLE_HOME/rdbms/admin
sqlplus /nolog
SQL> CONNECT / AS SYSDBA
SQL> @utlrp.sql