Issue

Error while applying Oracle E-Business Suite Release 12.2.0 to 12.2.4 Upgrade Patch 17919161

Error Description

Under u17919161.log

Generating library "INVISMMX.pll" with command:

/u01/oracle/VIS/fs1/EBSapps/10.1.2/bin/rwconverter source=/u01/oracle/VIS/fs1/EBSapps/appl/au/12.0.0/plsql/INVISMMX.pll dest=/u01/oracle/VIS/fs1/EBSapps/appl/admin/VIS/out/tmp001.pll stype=pllfile dtype=pllfile overwrite=yes batch=yes compile_all=yes 

/u01/oracle/VIS/fs1/EBSapps/10.1.2/bin/rwconverter: error while loading shared libraries: libXm.so.2: cannot open shared object file: No such file or directory

ERROR [code=127] generating library "INVISMMX.pll" from input file

/u01/oracle/VIS/fs1/EBSapps/appl/au/12.0.0/plsql/INVISMMX.pll

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

Under adworker1.log

Generating Oracle Reports files...

Generating library "INVISMMX.pll" with command:

/u01/oracle/VIS/fs1/EBSapps/10.1.2/bin/rwconverter source=/u01/oracle/VIS/fs1/EBSapps/appl/au/12.0.0/plsql/INVISMMX.pll dest=/u01/oracle/VIS/fs1/EBSapps/appl/admin/VIS/out/tmp001.pll stype=pllfile dtype=pllfile overwrite=yes batch=yes compile_all=yes 

/u01/oracle/VIS/fs1/EBSapps/10.1.2/bin/rwconverter: error while loading shared libraries: libXm.so.2: cannot open shared object file: No such file or directory

ERROR [code=127] generating library "INVISMMX.pll" from input file

/u01/oracle/VIS/fs1/EBSapps/appl/au/12.0.0/plsql/INVISMMX.pll

Generated    0 files successfully.

Generated    0 files with non-fatal warnings.

Generated    1 files with fatal errors.

Root cause of the issue

Missing openmotif21-2.1.30-11.EL5.i386.rpm package. This is a pre-requisite for installing Oracle E-Business Suite Release 12.2.4 (Refer to MOS DocId 1330701.1).

Resolution

Install openmotif21-2.1.30-11.EL5.i386.rpm package using the following commands using 'root' user:

Step 1 - Download openmotif21-2.1.30-11.EL5.i386.rpm package

wget https://oss.oracle.com/projects/compat-oracle/dist/files/Enterprise_Linux/openmotif21-2.1.30-11.EL5.i386.rpm

Step 2 - Install rpm package

rpm -Uvh openmotif21-2.1.30-11.EL5.i386.rpm

Step 3 - Make sure it has been installed successfully

rpm -qa | grep 'openmotif'

Step 4 - Restart your patch application using ADOP utility

Environment

• Oracle E-Busienss Suite Release 12.2.4
• Oracle Linix 5.7 (x86-64)