patching grid infrastructure using ZDOGIP
When running /u01/app/19.16.0/grid/root.sh -transparent -nodriverupdate on node 2
of RAC cluster it fails with
Can't locate strict.pm: /root/perl5/lib/perl5/strict.pm: (null) at /u01/app/19.16.0/grid/sqlpatch/sqlpatch.pl line 108.
BEGIN failed--compilation aborted at /u01/app/19.16.0/grid/sqlpatch/sqlpatch.pl line 108.
2022/08/22 17:31:43 CLSRSC-488: Patching the Grid Infrastructure Management Repository database failed.
Died at /u01/app/19.16.0/grid/crs/install/crspatch.pm line 1916.
The command '/u01/app/19.16.0/grid/perl/bin/perl -I/u01/app/19.16.0/grid/perl/lib -I/u01/app/19.16.0/grid/crs/install /u01/app/19.16.0/grid/crs/install/rootcrs.pl -transparent -nodriverupdate -dstcrshome /u01/app/19.16.0/grid -postpatch' execution failed
[root@node2 ~]#
running on node 1 runs successfully
Entries will be added to the /etc/oratab file as needed by
Database Configuration Assistant when a database is created
Finished running generic part of root script.
Now product-specific root actions will be performed.
Relinking oracle with rac_on option
LD_LIBRARY_PATH='/u01/app/19.15.0/grid/lib:/u01/app/19.16.0/grid/lib:'
Using configuration parameter file: /u01/app/19.16.0/grid/crs/install/crsconfig_params
The log of current session can be found at:
/u01/app/grid/crsdata/e03572/crsconfig/rootcrs_e03572_2022-08-22_04-02-55PM.log
Using configuration parameter file: /u01/app/19.16.0/grid/crs/install/crsconfig_params
The log of current session can be found at:
/u01/app/grid/crsdata/e03572/crsconfig/crs_prepatch_apply_oop_e03572_2022-08-22_04-02-56PM.log
2022/08/22 16:03:05 CLSRSC-347: Successfully unlock /u01/app/19.16.0/grid
2022/08/22 16:03:06 CLSRSC-671: Pre-patch steps for patching GI home successfully completed.
Using configuration parameter file: /u01/app/19.16.0/grid/crs/install/crsconfig_params
The log of current session can be found at:
/u01/app/grid/crsdata/e03572/crsconfig/crs_postpatch_apply_oop_e03572_2022-08-22_04-03-06PM.log
Oracle Clusterware active version on the cluster is [19.0.0.0.0]. The cluster upgrade state is [NORMAL]. The cluster active patch level is [3063913975].
2022/08/22 16:03:29 CLSRSC-329: Replacing Clusterware entries in file 'oracle-ohasd_dummy.service'
2022/08/22 16:04:11 CLSRSC-329: Replacing Clusterware entries in file 'oracle-ohasd.service'
Oracle Clusterware active version on the cluster is [19.0.0.0.0]. The cluster upgrade state is [ROLLING PATCH]. The cluster active patch level is [3063913975].
2022/08/22 16:05:17 CLSRSC-4015: Performing install or upgrade action for Oracle Trace File Analyzer (TFA) Collector.
2022/08/22 16:05:18 CLSRSC-672: Post-patch steps for patching GI home successfully completed.
[root@node1 app]# 2022/08/22 16:07:58 CLSRSC-4003: Successfully patched Oracle Trace File Analyzer (TFA) Collector.
To fix it I did the following
1. Locate the strict.pm file location
ls -l /<GRID_HOME>/perl/lib/5.28.0/strict.pm
ls -l /usr/share/perl5/strict.pm
2. Set the Perl variable as below:
export PERL5LIB=<grid_home>/perl/lib/:/usr/share/perl5/
export PATH=$PATH:<grid_home>/perl/lib/:/usr/share/perl5/
e.g.
export PERL5LIB=/<GRID_HOME>/perl/lib/:/usr/share/perl5/
export PATH=$PATH:/<GRID_HOME>/perl/lib/:/usr/share/perl5/
3. Rerun the /u01/app/19.16.0/grid/root.sh -transparent -nodriverupdate
SQL Patching tool version 19.16.0.0.0 Production on Tue Aug 23 11:53:18 2022
Copyright (c) 2012, 2022, Oracle. All rights reserved.
Log file for this invocation: /u01/app/grid/cfgtoollogs/sqlpatch/sqlpatch_35258_2022_08_23_11_53_18/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:
No interim patches found
Current state of release update SQL patches:
Binary registry:
19.16.0.0.0 Release_Update 220703022223: Installed
PDB CDB$ROOT:
Applied 19.15.0.0.0 Release_Update 220331125408 successfully on 03-MAY-22 16.12.58.011967
PDB GIMR_DSCREP_10:
Applied 19.15.0.0.0 Release_Update 220331125408 successfully on 03-MAY-22 16.13.00.084820
PDB PDB$SEED:
Applied 19.15.0.0.0 Release_Update 220331125408 successfully on 03-MAY-22 16.12.59.018312
Adding patches to installation queue and performing prereq checks...done
Installation queue:
For the following PDBs: CDB$ROOT PDB$SEED GIMR_DSCREP_10
No interim patches need to be rolled back
Patch 34133642 (Database Release Update : 19.16.0.0.220719 (34133642)):
Apply from 19.15.0.0.0 Release_Update 220331125408 to 19.16.0.0.0 Release_Update 220703022223
No interim patches need to be applied
Installing patches...
Patch installation complete. Total patches installed: 3
Validating logfiles...done
Patch 34133642 apply (pdb CDB$ROOT): SUCCESS
logfile: /u01/app/grid/cfgtoollogs/sqlpatch/34133642/24865470/34133642_apply__MGMTDB_CDBROOT_2022Aug23_11_54_00.log (no errors)
Patch 34133642 apply (pdb PDB$SEED): SUCCESS
logfile: /u01/app/grid/cfgtoollogs/sqlpatch/34133642/24865470/34133642_apply__MGMTDB_PDBSEED_2022Aug23_11_55_26.log (no errors)
Patch 34133642 apply (pdb GIMR_DSCREP_10): SUCCESS
logfile: /u01/app/grid/cfgtoollogs/sqlpatch/34133642/24865470/34133642_apply__MGMTDB_GIMR_DSCREP_10_2022Aug23_11_55_26.log (no errors)
SQL Patching tool complete on Tue Aug 23 11:56:34 2022
2022/08/23 11:57:37 CLSRSC-4015: Performing install or upgrade action for Oracle Trace File Analyzer (TFA) Collector.
2022/08/23 11:57:40 CLSRSC-672: Post-patch steps for patching GI home successfully completed.
[root@node2~]#