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

 Issue# 18:

ð    While creating new DB xml file

 

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

 

Starting context file generation for db tier..

ERROR: Unable to set CLASSPATH

     Jars and zips are missing at these locations

    /oracle/dpro/db/tech_st/11.2.0.4/jdbc/lib/ojdbc14.jar

    /oracle/dpro/db/tech_st/11.2.0.4/jdbc/lib/classes12.zip

    /oracle/dpro/db/tech_st/11.2.0.4/jdbc/lib/classes12.jar

 [ordpro@r12upgdb bin]$

 

Solution:

-          Copy the missing files from old Oracle Home:

[ordpro@dbmig ~]$ cd /u03/db/tech_st/dprodb/9.2.0/jdbc/lib/

[ordpro@dbmig lib]$ ls

classes111.jar  classes12dms.jar  classes12.zip      nls_charset11.zip  nls_charset12.zip  ocrs12.zip     ojdbc14.jar

classes111.zip  classes12.jar     nls_charset11.jar  nls_charset12.jar  ocrs12.jar         ojdbc14_g.jar

[ordpro@dbmig lib]$ scp ojdbc14.jar classes12.zip classes12.jar  ordpro@172.10.10.210:/oracle/dpro/db/tech_st/11.2.0.4/jdbc/lib/

ordpro@172.10.10.210's password:

ojdbc14.jar                                                                                                                               100% 1185KB   1.2MB/s   00:00   

classes12.zip                                                                                                                             100% 1216KB   1.2MB/s   00:00   

classes12.jar                                                                                                                             100% 1206KB   1.2MB/s   00:00   

[ordpro@dbmig lib]$