Oracle EBS 12.1.3 to 12.2.4 Upgrade Issues

Completed a Successful Upgrade  iteration on one of the environment: 12.1.3 to 12.2.4

Below Mentioned are the few issues faced and their resolution:

The Install was done on a new Application server and then performed Upgrade.


1. While executing rapidwiz for Online Application ( 12.2.0)  installation, facing an error related to jre file:

libXtst.so.6: cannot open shared object file: No such file or directory


Solution:


Installed OS Package:  xorg-x11-libs-compat-6.8.2-1.EL.33.0.1.i386
AND

# unlink /usr/lib/libXtst.so.6
# ln -s /usr/X11R6/lib/libXtst.so.6.1 /usr/lib/libXtst.so.6



2. Error while adop :

Checking for existing adop sessions.
    [UNEXPECTED]Duplicate rows found for host appsmines01 in FND_OAM_CONTEXT_FILES table
*******FATAL ERROR*******
PROGRAM : (/u01/app/***/***/fs1/EBSapps/appl/ad/12.0.0/bin/adzdoptl.pl)
TIME    : Sat Jun 11 09:36:47 2016
FUNCTION: ADOP::CommonUtil::getAppltopId [ Level 1 ]
ERRORMSG: Duplicate rows found for host ausuldppimebs01 in FND_OAM_CONTEXT_FILES table


Solution:

Found duplicate entries for apps contextfile in fnd_oam_context_files
Repopulated xml entries by : fnd node cleanup , autoconfig on both db and apps side.



3. 12.2.4 upgrade patch 17919161 failed with below error :


ADOP session:

*******FATAL ERROR*******
PROGRAM : (/u01/app/***/fs1/EBSapps/appl/ad/12.0.0/bin/adzdoptl.pl)
TIME    : Sat Jun 11 20:58:29 2016
FUNCTION: ADOP::GlobalVars::_validateApplyRestartArgs [ Level 1 ]
ERRORMSG: When running adop after a previous patching cycle failed, you must specify either the 'abandon' or 'restart' parameter .


[STATEMENT] Please run adopscanlog utility, using the command

"adopscanlog -latest=yes"

to get the list of the log files along with snippet of the error message corresponding to each log file.


adop exiting with status = 255 (Fail)


LOGFILE:

The following Oracle Reports objects did not generate successfully:
au      plsql   INVISMMX.pll
An error occurred while generating Oracle Reports library files.
***
Continue as if it were successful :
***


Solution:

Installed OS package: openmotif21-2.1.30-11.EL7.i686.rpm and restaretd ADOP ( restart=yes).



4. on Database server fails:


$ perl cr9idata.pl
Can't locate File/CheckTree.pm in @INC (@INC contains: /usr/local/lib64/perl5 /usr/local/share/perl5 /usr/lib64/perl5/vendor_perl /usr/share/perl5/vendor_perl /usr/lib64/perl5 /usr/share/perl5 . /u01/app/oracle/product/11.2.0.4/db_5/appsutil/perl /u01/app/oracle/product/11.2.0.4/db_5/appsutil/perl /usr/local/lib64/perl5 /usr/local/share/perl5 /usr/lib64/perl5/vendor_perl /usr/share/perl5/vendor_perl /usr/lib64/perl5 /usr/share/perl5 .) at cr9idata.pl line 40.
BEGIN failed--compilation aborted at cr9idata.pl line 40.


Solution:


export PERL5LIB=$ORACLE_HOME/perl/lib/5.10.0:$ORACLE_HOME/perl/site_perl/5.10.0:$ORACLE_HOME/appsutil/perl
export PATH=$ORACLE_HOME/perl:$ORACLE_HOME/perl/lib:$ORACLE_HOME/perl/bin:$PATH




5. System Tablespace low on space: Patch hangs:

TABLESPACE_NAME                PERCENTAGE_USED SPACE_ALLOCATED SPACE_USED SPACE_FREE  DATAFILES
------------------------------ --------------- --------------- ---------- ---------- ----------
SYSTEM                                   99.31           12326   12240.91      85.09         13


Solution:


SQL> alter tablespace system add datafile '+DATA_1' size 25G;

Tablespace altered.


6.  After Upgrade, opmn/Apache doesnt start with below error :

/u01/app/***/fs1/inst/apps/*****/admin/scripts/adapcctl.sh: line 161: /u01/app/****/fs1/FMW_Home/webtier/instances/EBS_web_****_OHS1/bin/opmnctl: No such file or directory


Solution:

After R12.2.4 Upgrade Found OPMNCTL Missing While Starting Services (Doc ID 1953456.1)