RW-50010: Error: - script has returned an error: 2 (Executing cr9idata.pl) During R12.2 Installation on Oracle Linux 8

Problem

Faced below error while Installing 12.2 on Linux 8.

Unable to execute cr9idata.pl

Executing cr9idata.pl

Executing: perl /u01/oracle/DEV/12.1.0/nls/data/old/cr9idata.pl

Unable to execute cr9idata.pl

RW-50010: Error: - script has returned an error:   2

RW-50004: Error code received when running external process.  Check log file for details.

Running Database Install Driver for DEV instance

Solution:

I have installed the following rpms:

Install the following rpm 

[root@dev02 DEV_dev2]#yum list perl-File-CheckTree*

Available Packages

perl-File-CheckTree.noarch                                                                         4.42-303.el8                                                                         ol8_appstream

perl-File-CheckTree.src                                                                            4.42-303.el8                                                                         ol8_appstream

[root@dev02 DEV_dev2]# yum install perl-File-CheckTree*

[root@dev02 DEV_dev2]#yum list perl-File-CheckTree*

Last metadata expiration check: 0:10:24 ago on Sun 21 Feb 2021 11:39:26 PM +03.

Installed Packages

perl-File-CheckTree.noarch                                                                        4.42-303.el8                                                                         @ol8_appstream

Available Packages

perl-File-CheckTree.src                                                                           4.42-303.el8                                                                         ol8_appstream

[root@dev02 DEV_dev2]#

The above is after installing the rpm. 

Grid Patching fails to start CRS

 

Latest CPU Patching on the 19c Grid home fails with below errors:

OPATCHAUTO-68061: The orchestration engine failed.

OPATCHAUTO-68061: The orchestration engine failed with return code 1

OPATCHAUTO-68061: Check the log for more details.

OPatchAuto failed.

Also it mentions to solve the issue and do opathauto resume. 

Solution:

Verify the patches have been applied on both the nodes:

cd /u01/app/19.3.0/grid/bin

 [root@DC2-GTDB-V-01 bin]# ./kfod op=patches

---------------

List of Patches

===============

29340594

32218454

32218663

32222571

32240590

[root@DC2-GTDB-V-01 bin]#

[root@DC2-GTDB-V-02 bin]# ./kfod op=patches

---------------

List of Patches

===============

29340594

32218454

32218663

32222571

32240590

[root@DC2-GTDB-V-02 bin]# 

The perform the following steps 

as root

cd $GI_HOME/bin

clscfg -localpatch

clscfg -patch

After this restart the CRS and verify if its started properly.

TNS-12518: TNS:listener could not hand off client connection

 TNS-12518: TNS:listener could not hand off client connection

While Connecting to oracle RAC database using sqlplus gives the following errors:

TNS-12518: TNS:listener could not hand off client connection
TNS-12547: TNS:lost contact
 TNS-12560: TNS:protocol adapter error
  TNS-00517: Lost contact
   Linux Error: 32: Broken pipe

Solution:

Check the permissions on the oracle executable in the RDBMS Home

cd $ORACLE_HOME/bin

ls -ltr oracle

It should have 6751 permission

chmod 6751 oracle

How to Change Private IP in RAC Cluster (19c) on OEL 8

 How to Change Private IP in RAC Cluster (19c) on OEL 8

In this post, we will see how to change the Private IP of a 2-Node Oracle. 

The purpose of this note is to describe how to change or update the private network (cluster_interconnect) information in Oracle Clusterware.

./oifcfg getif

ens192  10.92.27.0  global  public

ens224  192.168.221.0  global  cluster_interconnect,asm

ens161  192.168.27.8  global  cluster_interconnect,asm

[root@DC2-GTDB-V-01 bin]# 

To set any interface

./oifcfg setif -global ens161/192.168.27.0:cluster_interconnect,asm

To Delete any interface

./oifcfg delif -global ens224/192.168.221.0

Ref:

How to Modify Private Network Information in Oracle Clusterware (Doc ID 283684.1)