Patch 34133642 - Database Release Update 19.16.0.0.220719

p34133642_190000_Linux-x86-64

・ p34133642_190000_Linux-x86-64_README

Record

System Operation: RHEL 8.7
Database Software: 19.3.0.0.0 Single Instance CDB

Check the current opatch version and patches.

~]# /u01/app/oracle/product/19.0.0/dbhome_1/OPatch/opatch version
OPatch Version: 12.2.0.1.17
OPatch succeeded.

~]$ $ORACLE_HOME/OPatch/opatch lspatches
29585399;OCW RELEASE UPDATE 19.3.0.0.0 (29585399)
29517242;Database Release Update : 19.3.0.0.190416 (29517242)
OPatch succeeded.

Update OPatch utility version 12.2.0.1.30 or later to apply this patch.
- Patch 6880880_190000 - record 1

Determine whether any currently installed interim patches conflict with the patch being installed, 34133642.

~]# chown oracle:oinstall /soft/p34133642_190000_Linux-x86-64.zip
~]$ unzip -q -d /soft /soft/p34133642_190000_Linux-x86-64.zip
~]$ cd /soft/34133642
34133642]$ $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -ph ./

If this is not a RAC environment, shut down all instances and listeners associated with the Oracle home that you are updating.

~]$ sqlplus / as sysdba

SQL*Plus: Release 19.0.0.0.0 - Production on Mon May 29 10:25:27 2023
Version 19.3.0.0.0

Copyright (c) 1982, 2019, Oracle.  All rights reserved.

Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.3.0.0.0

SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> exit
Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.3.0.0.0

~]$ lsnrctl stop

LSNRCTL for Linux: Version 19.0.0.0.0 - Production on 29-MAY-2023 10:26:15

Copyright (c) 1991, 2019, Oracle.  All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=oracle19cdg)(PORT=1521)))
The command completed successfully

Opatch apply.

~]$ cd /soft/34133642/
34133642]$ $ORACLE_HOME/OPatch/opatch apply
...
OPatch succeeded.

34133642]$ $ORACLE_HOME/OPatch/opatch lspatches
34133642;Database Release Update : 19.16.0.0.220719 (34133642)
29585399;OCW RELEASE UPDATE 19.3.0.0.0 (29585399)
OPatch succeeded.

Load Modified SQL Files into the Database. For each separate database running on the same shared Oracle home being patched, run the datapatch utility

For Single/Multitenant (CDB/PDB) DB:

~]$ sqlplus /nolog

SQL*Plus: Release 19.0.0.0.0 - Production on Mon May 29 11:13:32 2023
Version 19.16.0.0.0

Copyright (c) 1982, 2022, Oracle.  All rights reserved.

SQL> conn / as sysdba
Connected to an idle instance.

SQL> startup
ORACLE instance started.

Total System Global Area 4177523144 bytes
Fixed Size                  9142728 bytes
Variable Size             788529152 bytes
Database Buffers         3372220416 bytes
Redo Buffers                7630848 bytes
Database mounted.
Database opened.

SQL> alter pluggable database all open;

Pluggable database altered.

SQL> quit
Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.16.0.0.0

~]$ $ORACLE_HOME/OPatch/datapatch -verbose
...
Installing patches...
Patch installation complete.  Total patches installed: 3

Validating logfiles...done
Patch 34133642 apply (pdb CDB$ROOT): SUCCESS
  logfile: /u01/app/oracle/cfgtoollogs/sqlpatch/34133642/24865470/34133642_apply_COCO_CDBROOT_2023May29_11_17_15.log (no errors)
Patch 34133642 apply (pdb PDB$SEED): SUCCESS
  logfile: /u01/app/oracle/cfgtoollogs/sqlpatch/34133642/24865470/34133642_apply_COCO_PDBSEED_2023May29_11_27_29.log (no errors)
Patch 34133642 apply (pdb PDB): SUCCESS
  logfile: /u01/app/oracle/cfgtoollogs/sqlpatch/34133642/24865470/34133642_apply_COCO_PDB_2023May29_11_27_29.log (no errors)

Automatic recompilation incomplete; run utlrp.sql to revalidate.
  PDBs: PDB PDB$SEED

SQL Patching tool complete on Mon May 29 11:34:59 2023

Check the following log files in $ORACLE_BASE/cfgtoollogs/sqlpatch/34133642/<unique patch ID> for errors

Any (pluggable) database that has invalid objects after the execution of datapatch should have utlrp.sql run to revalidate those objects.

~]$ cd $ORACLE_HOME/rdbms/admin
admin]$ $ORACLE_HOME/perl/bin/perl $ORACLE_HOME/rdbms/admin/catcon.pl -n 1 -e -b utlrp -d $ORACLE_HOME/rdbms/admin utlrp.sql
catcon::set_log_file_base_path: ALL catcon-related output will be written to [/u01/app/oracle/product/19.0.0/dbhome_1/rdbms/admin/utlrp_catcon_18663.lst]

catcon::set_log_file_base_path: catcon: See [/u01/app/oracle/product/19.0.0/dbhome_1/rdbms/admin/utlrp*.log] files for output generated by scripts

catcon::set_log_file_base_path: catcon: See [/u01/app/oracle/product/19.0.0/dbhome_1/rdbms/admin/utlrp_*.lst] files for spool files, if any

catcon.pl: completed successfully
admin]$ sqlplus / as sysdba

SQL*Plus: Release 19.0.0.0.0 - Production on Mon May 29 11:43:21 2023
Version 19.16.0.0.0

Copyright (c) 1982, 2022, Oracle.  All rights reserved.

Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.16.0.0.0

SQL> alter session set container=pdb;

Session altered.

SQL> SELECT count(*) FROM dba_objects WHERE status = 'INVALID';

  COUNT(*)
----------
         0