Oracle Database/ERP/Cloud/RAC/Misc Solutions

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                                        ...

  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 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 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)