Tuesday, February 21, 2012

Issues while applying RUP 7 Patch on 11.5.10 CU2 on IBM AIX

1 ld: 0711-783 WARNING: TOC overflow. TOC size: 78748 Maximum size: 65536
Extra instructions are being generated for each reference to a TOC
symbol if the symbol is in the TOC overflow area.
ld: 0711-101 FATAL ERROR: Allocation of 16204512 bytes failed
in routine init_symtab_info. There is not enough memory available.      

Solution: ld: 0711-101 FATAL ERROR: While Relinking Product MSC MSO MSR (Doc ID 330990.1)       
LDR_CNTRL=""MAXDATA=0x40000000""
export LDR_CNTRL          Run the patch again      
                           "
2.AD Worker error:
The index cannot be created as the table has duplicate keys.
Use the following SQL statement to identify the duplicate keys:

SELECT TRANSACTION_ID, count(*)
FROM ICX.ICX_TRANSACTIONS
GROUP BY TRANSACTION_ID
HAVING count(*)>1

AD Worker error:
Unable to compare or correct tables or indexes or keys because of the error above                                                                          

 Solution: Patch 6241631-11i.ATG_PF.H.RUP7 fails on icxwtab.odf: Table Has Duplicate Keys (Doc ID 1148403.1)            
    1. Run the backup copy of ICXDLTMP.sql as the APPS user from the 11i.ATG_PF.H.delta.7 Patch directory.
    For example :
    sqlplus apps/apps_pwd @patch Directory/backup/[SID]/[HostName]/icx/sql/ICXDLTMP.sql           
 2. Restart the failed worker via the adctrl Utility using option 2"