Monday, 18 July 2016

Issues during upgrade from R12.2.0. to R12.2.4.. When following document 1617461.1 to apply 18288881:R12.TXK.C.Delta.5 merged with Patch 19445058:R12.TXK.C

Issue:

When following document 1617461.1 to apply 18288881:R12.TXK.C.Delta.5 merged with Patch 19445058:R12.TXK.C

Applying the Latest AD and TXK Release Update Packs to Oracle E-Business Suite Release 12.2 (Doc ID 1617461.1)
  Section 3: Apply the R12.AD.C.Delta.5 and R12.TXK.C.Delta.5 Release Update Packs
     3.1: Path A - Upgrade and New Installation Customers
        6 On the run edition application tier file system, use hotpatch mode to apply Patch 18288881:R12.TXK.C.Delta.5 
           merged with Patch 19445058:R12.TXK.C (plus additional critical patches).
           $ adop phase=apply patches=18288881,19445058 hotpatch=yes merge=yes

Solution:


1. Source the Database tier environment file.

2.Unzip Patch 17537119: EBS Technology Codelevel Checker:
  unzip p17537119_R12_GENERIC.zip
  Confirm the following files are present after unzipping.
    checkDBpatch.sh
    checkDBpatch.cmd
    txk_R1220_DB_base_bugs.xml
    README.txt

3. Run checkDBpatch.sh.

4. Check if TXK_TCC_RESULTS gets installed using the following select:

SQL> select count(table_name) from all_tables where table_name='TXK_TCC_RESULTS';
5. Re-apply Patch 18288881:R12.TXK.C.Delta.5 merged with Patch 19445058:R12.TXK.C

Alert are not getting fired from concurrent programs in R12 (12.1.3)

Issue:

Alert are not getting fired from concurrent programs in R12 (12.1.3)

Alert: Version : 12.0.0

Copyright (c) 1979, 1999, Oracle Corporation. All rights reserved.

ALECDC module: Check Periodic Alert
+---------------------------------------------------------------------------+

Current system time is 15-JUL-2016 12:30:16

+---------------------------------------------------------------------------+

/u01/devap/apps/apps_st/appl/alr/12.0.0/bin/ALECDC
Program was terminated by signal 11


+---------------------------------------------------------------------------+
No completion options were requested.

Output file size: 
0


Output is not being printed because:
The print option has been disabled for this report.

+---------------------------------------------------------------------------+
Concurrent request completed
Current system time is 15-JUL-2016 12:30:16

Solution:

Please download patch 13728376 from metalink and apply it.




OS Watcher Installation in RAC

 Step:1 Download and untar the oswbb812.tar under the grid user in RAC on the both nodes. Follow the OS Watcher User's Guide (Doc ID 153...