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.
==============================================
check $ORACLE_HOME/oraInst.loc file. This one usually points to the central inventory.
go inventory location (example :/etc/orauser/oraInventory). Check locks directory and the locks file within. change permission and try to apply patch again.

Query text from v$sql
================
set long 100000

spool display_sql.lst
select
   sql_id,dbms_lob.substr(sql_fulltext,3000)
from
   v$sql
where
   lower(sql_fulltext) like lower('%TEXT%TEXT1%');

R12.2.7
=====
Relinking PYUGEN needs to be done using adadmin only. Relink from command line always throws error.

The issue was with the quantum/lib files not being copied to the second admin node of app tier.
Concurrent processes were running on the second node and the Quick Pay process failed.

October PSU - GI
=============

Running the analyze command :
/grid/12.1.0/grid/OPatch/opatchauto apply /patchlocation/psu/oct2018/28349311 -analyze







Comments

Post a Comment

Popular posts from this blog

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_...
Read more

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...
Read more