Upgrade to Oracle EBS 12.2.11 – Issues and Solutions Part 3
In this last and final blog post (previous ones Part 2 & Part 1) we will explore the issues specific to RUP Oracle 12.2.11.
Let’s dive in…
RUP 12.2.11 — Patch 31856789
a. Relinking failed due to Environment Variables
vi adrelink.log
Removing extra variables from the environment…
adrelink will save the following variables (if set):
- Generic:
“PATH ORACLE_HOME TMPDIR TZ APPL_TOP APPLFENV PLATFORM LD_LIBRARY_PATH COBDIR
LIBPATH NLS_LANG JAVA_TOP PERL5LIB”
- Shell-Specific: “PS1 PS2 PS3 PS4 IFS MAILCHECK _ LOGNAME A__z”
Beginning pass 1.
Processing 383 environment variables…
/d01/apps/*****/fs1/EBSapps/appl/ad/12.0.0/bin/adrelinknew.sh: line 1078:
unset: `}’: not a valid identifier
/d01/apps/*****/fs1/EBSapps/appl/ad/12.0.0/bin/adrelinknew.sh: line 1078:
unset: `which%%’: not a valid identifier
/d01/apps/*****/fs1/EBSapps/appl/ad/12.0.0/bin/adrelinknew.sh: line 1078:
unset: `${which_declare}’: not a valid identifier
/d01/apps/*****/fs1/EBSapps/appl/ad/12.0.0/bin/adrelinknew.sh: line 1078:
unset: `|’: not a valid identifier
/d01/apps/*****/fs1/EBSapps/appl/ad/12.0.0/bin/adrelinknew.sh: line 1078:
unset: `/usr/bin/which’: not a valid identifier
/d01/apps/*****/fs1/EBSapps/appl/ad/12.0.0/bin/adrelinknew.sh: line 1078:
unset: — : invalid option
unset: usage: unset [-f] [-v] [-n] [name …]
adrelink is exiting with status 2
End of adrelink session
The Solution:
Unset the variables (as directed by Oracle Support) and re-try.
unset which_declare unset which_opt unset which_shell unset which unset _
b. Forms objects did not generate successfully
After running for more than 6 hours and just when I had visualized “light” on the other end of the tunnel, the RUP failed!
The following Oracle Forms objects did not generate successfully: inv forms/US INVIDTMP.fmx inv forms/US INVIVCSU.fmx inv forms/US INVIDITM.fmx An error occurred while generating Oracle Forms files.
On compiling the Forms binaries manually, this is what the error message looked like:
Compiling package body MTL_ITEM_TEMPL_ATTRIBUTES_02… Compilation error on package body MTL_ITEM_TEMPL_ATTRIBUTES_02: PL/SQL ERROR 201 at line 955, column 12 identifier ‘CS_LOOKUPS’ must be declared PL/SQL ERROR 0 at line 953, column 5 SQL Statement ignored Form not created
The Solution: Remember to talk to your colleagues
My senior’s wisdom saved me a lot of time! And the Forms were generated successfully!
USER is “APPS” SQL> desc CS_LOOKUPS; ERROR: ORA-04043: object CS_LOOKUPS does not exist CREATE OR REPLACE FORCE EDITIONABLE VIEW “APPS”.”CS_LOOKUPS” (“LOOKUP_TYPE”, “LOOKUP_CODE”, “LAST_UPDATE_DATE”, “LAST_UPDATED_BY”, “LAST_UPDATE_LOGIN”, “CREATION_DATE”, “CREATED_BY”, “MEANING”, “ENABLED_FLAG”, “START_DATE_ACTIVE”, “END_DATE_ACTIVE”, “DESCRIPTION”, “ATTRIBUTE_CATEGORY”, “ATTRIBUTE1”, “ATTRIBUTE2”, “ATTRIBUTE3”, “ATTRIBUTE4”, “ATTRIBUTE5”, “ATTRIBUTE6”, “ATTRIBUTE7”, “ATTRIBUTE8”, “ATTRIBUTE9”, “ATTRIBUTE10”, “ATTRIBUTE11”, “ATTRIBUTE12”, “ATTRIBUTE13”, “ATTRIBUTE14”, “ATTRIBUTE15”, “TAG”) AS SELECT LV.LOOKUP_TYPE, LV.LOOKUP_CODE, LV.LAST_UPDATE_DATE, LV.LAST_UPDATED_BY, LV.LAST_UPDATE_LOGIN, LV.CREATION_DATE, LV.CREATED_BY, LV.MEANING, LV.ENABLED_FLAG, LV.START_DATE_ACTIVE, LV.END_DATE_ACTIVE, LV.DESCRIPTION, LV.ATTRIBUTE_CATEGORY, LV.ATTRIBUTE1, LV.ATTRIBUTE2, LV.ATTRIBUTE3, LV.ATTRIBUTE4, LV.ATTRIBUTE5, LV.ATTRIBUTE6, LV.ATTRIBUTE7, LV.ATTRIBUTE8, LV.ATTRIBUTE9, LV.ATTRIBUTE10, LV.ATTRIBUTE11, LV.ATTRIBUTE12, LV.ATTRIBUTE13, LV.ATTRIBUTE14, LV.ATTRIBUTE15, LV.TAG FROM FND_LOOKUP_VALUES LV WHERE lv.LANGUAGE = userenv(‘LANG’) and lv.View_APPLICATION_ID = 170 and lv.SECURITY_GROUP_ID = fnd_global.lookup_security_group(LV.LOOKUP_TYPE, LV.VIEW_APPLICATION_ID); 2 View created.
c. Generating library INVISMMX.pll failed with the error shown
/d01/apps/*****/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 /d01/apps/*****/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. adrepgen is exiting with status 1
The Solution:
As Root, run the following commands:
[root@******* lib]# cd /usr/lib [root@******* lib]# ln -s libXm.so.4.0.4 libXm.so.2
d. Post 12.2.11 RUP Cleanup phase displayed a strange message
adop phase=cleanup
**********************
[UNEXPECTED]The following patches failed to apply on admin node <*******> in hotpatch mode, session ID <2>
Patches: <2394134,33441060>
You can either resolve the failure and reapply the patches, or ignore the failure and allow processing to continue.
[WARNING] Only continue if you are sure it is safe to do so — continuing without first resolving the failure may lead to inconsistency and data loss.
To reapply the patches in the existing session, answer ‘N’.
To ignore the failure and continue processing, answer ‘Y’.
Do you want to continue (Y/N)? [N]
The patches were already applied..so why???
SQL> select BUG_NUMBER, CREATION_DATE from apps.ad_bugs where bug_number in(‘32394134’,’33441060'); BUG_NUMBER CREATION_ — — — — — — — — — — — — — — — — — — — - 32394134 31-MAR-22 33441060 31-MAR-22
Still not satisfied with the conflicting messages, I ran the Upgrade Analyzer tool to lay the doubts to rest.
The Solution:
And continued with the Cleanup phase…
Do you want to continue (Y/N)? [N]Y Processing cleanup actions in parallel. Log: /d01/apps/*****/fs_ne/EBSapps/log/adop/2/20220404_170752/cleanup/*******/log/cleanup.log Generating report of queued DDL actions. Output: /d01/apps/*****/fs_ne/EBSapps/log/adop/2/20220404_170752/cleanup/*******/adzdallddls.out Running cleanup in STANDARD mode. Log: @ADZDSHOWLOG.sql “2022/04/05 04:03:21” Generating log report. Output: /d01/apps/*****/fs_ne/EBSapps/log/adop/2/20220404_170752/cleanup/*******/adzdshowlog.out The cleanup phase completed successfully. adop exiting with status = 0 (Success)
Hope this helps and see you on the other side of a successful, unscathed upgrade to EBS 12.2.11!
