Issues faced while upgrading Oracle Applications (E-Business Suite) from 11i to R12.2

 Issue# 19:

-          adbldxml.pl is failing and pointing to wrong JRE location:

 

[ordpro@r12upgdb ~]$ cd $ORACLE_HOME/appsutil/bin

[ordpro@r12upgdb bin]$ perl adbldxml.pl tier=db appsuser=apps appspasswd=apps

 

Starting context file generation for db tier..

 

 

JRE_TOP not found at its desired location /oracle/dpro/db/tech_st/11.2.0.4/jre/1.4.2

Restart adbldxml.pl with value for jtop as an necessary argument

 

Solution:

-          Update the script with the correct JRE location:

[ordpro@r12upgdb bin]$ cat adbldxml.pl |grep "1.4.2"

              $jre_top=getOSFilePath("$oracle_home/jre/1.4.2");

                 $jre_top = getOSFilePath("$oracle_home/jre/1.4.2");

[ordpro@r12upgdb bin]$

[ordpro@r12upgdb bin]$ cp adbldxml.pl adbldxml.pl_org

[ordpro@r12upgdb bin]$ vi adbldxml.pl

[ordpro@r12upgdb bin]$

[ordpro@r12upgdb bin]$ diff adbldxml.pl adbldxml.pl_org

413c413

<               $jre_top=getOSFilePath("$oracle_home/jre");

---

>               $jre_top=getOSFilePath("$oracle_home/jre/1.4.2");

424c424

<                  $jre_top = getOSFilePath("$oracle_home/jre");

---

>                  $jre_top = getOSFilePath("$oracle_home/jre/1.4.2");

[ordpro@r12upgdb bin]$