Posts

Oracle EBS 12.2 Java upgrade in the application server

1. Why upgrade java in application server ?       Older versions (1.7.0_130 or lower) do not support TLSv1.2. To integrate EBS and Oracle Cloud EBS needs to be TLSv1.2 compliant. 2. To get the list of Java versions in Oracle Support go to this note and scroll down. The java versions can be downloaded as patches. All Java SE Downloads on MOS (Doc ID 1439822.1)   For the same version of Java , we can download Linux 86 version (32 bit) and Linux x86-64 (64 bit versions) 3. To upgrade Java use this note: Using the Latest JDK 7.0 Update with Oracle E-Business Suite Release 12.2 (Doc ID 1530033.1) 4. JDKtest.jsp file did not work in EBS 12.2 despite setting the profile option %Allow%Unrestriceted% to Yes. To circumvent the issue, I added this line " The JDK version is: <%= System.getProperty("java.version") %>" to the top of OA.jsp     Compile this file using  : perl -x $FND_TOP/patch/115/bin/ojspCompile.pl   --co...
Post a Comment
Read more

LOB related tasks

Tables that use LOB objects usually grow quickly in size. LOB object can be either inline or can be stored outside the table row. There are certain in built rules that will decide if an LOB object is stored inline or not. Refer to this Blog: Query to view LOB data (inline) sizing in a table: select    table_name,round((blocks*8),2) "size (kb)" ,    round((num_rows*avg_row_len/1024),2) "actual_data (kb)",    (round((blocks*8),2) - round((num_rows*avg_row_len/1024),2)) "wasted_space (kb)" from    dba_tables where    table_name = 'table name'   and (round((blocks*8),2) > round((num_rows*avg_row_len/1024),2)) / If LOB segment is stored outside the table (there is a index in the table that points to the LOB segments) use this to view the size : select table_name,column_name,segment_name,a.bytes/1024/1024/1024  from dba_segments a       join      dba_...
Post a Comment
Read more

Jan-2019

Applying app tier patch in EBS 12.2.7 1. copy patch file to $PATCH_TOP in the app tier. In a multi node app tier environment copy the patch to all app tiers ($PATCH_TOP) 2. run adop phase=prepare           adop phase=apply patches=<patch num>           adop phase=finalize           adop phase=cutover (adformsrvctl.sh may error out. make sure this script runs successfully. To fix the script i had to change servlet=socket           adop phase=cleanup 3. Login to EBS and validate. Run a concurrent request and check output /log. Finding all patches applied in Weblogic home cd $FMW_HOME/utils/bsu  (10.3.6) ./bsu.sh -report cd $FMW_HOME/OPatch (12c) ./opatch lspatches database patch rollback ================= opatch rollback -id <patch num> Unable to lock Central Inventory.  OPatch will attempt to re-lock. ================...
Post a Comment
Read more