While installing one-off Patch on AIX systems, getting several WARNING messages: OUI-67215 - TOC ove

APPLIES TO:

Oracle Database - Enterprise Edition - Version 8.1.7.4 and later
IBM AIX on POWER Systems (64-bit)
***Checked for relevance on 03-Jan-2013*** 

SYMPTOMS

You are trying to install an Interim/One-off Patch on AIX platform.
You are encountering WARNINGs in the relinking stage of the Patch Apply.

Example: when applying CPUOct2006 to Oracle DB 10.2.0.2 on AIX

Running make for target ioracle ApplySession adding interim patch '5490848' to inventory Verifying the update... Inventory check OK: Patch ID 5490848 is registered in Oracle Home inventory with proper meta-data. Files check OK: Files from Patch ID 5490848 are present in Oracle Home. The local system has been patched and can be restarted. -------------------------------------------------------------------------------- The following warnings have occurred during OPatch execution: 1) OUI-67215: OPatch found the word "failed" in the stderr of the make command. Please look at this stderr. You can re-run this make command. Stderr output: ld: 0711-783 WARNING: TOC overflow. TOC size: 67040 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-783 WARNING: TOC overflow. TOC size: 67040 Maximum size: 65536 Extra instructions are being generated for each reference to a TOC symbol if the symbol is in the TOC overflow area. /local/sdmd/oracle/product/10.2/bin/genoccish[82]: xlC: 0403-006 Execute permission denied. ar: A file or directory in the path name does not exist. ar: 0707-117 The fopen system call failed on file /local/sdmd/oracle/product/10.2/lib/shr.o. /local/sdmd/oracle/product/10.2/bin/genoccish[82]: xlC: 0403-006 Execute permission denied. ar: A file or directory in the path name does not exist. ar: 0707-117 The fopen system call failed on file /local/sdmd/oracle/product/10.2/lib32/shr.o.

While relinking the Database 11.2.0.2 $ORACLE_HOME/bin/oracle binary on AIX (for example, when applying a patch) the linker may report a large number (5000+) of warning messages like the ones below:

OPatch found the word "error" in the stderr of the make command.
Please look at this stderr. You can re-run this make command.
Stderr output:
...
ld: 0711-415 WARNING: Symbol ... is already exported.
ld: 0711-319 WARNING: Exported symbol not defined: ...
ld: 0711-773 WARNING: Object ... imported symbol timezone symbol was expected to be local.

Ask Questions, Get Help, And Share Your Experiences With This Article

Would you like to explore this topic further with other Oracle Customers, Oracle Employees, and Industry Experts?

Click here to join the discussion where you can ask questions, get help from others, and share your experiences with this specific article.
Discover discussions about other articles and helpful subjects by clicking here to access the main My Oracle Support Community page for Database Install/Upgrade.

CAUSE

Following  errors are involved:

1) TOC overflow
ld: 0711-783 WARNING: TOC overflow. TOC size: 67040 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-783 WARNING: TOC overflow. TOC size: 67040 Maximum size: 65536  Extra instructions are being generated for each reference to a TOC  symbol if the symbol is in the TOC overflow area.

These are ignorable WARNINGs as discussed in : 
Note 245372.1 - TOC overflow Warning Can Safely Be Ignored

Recently,Installation/Patching of Oracle Database 12c on AIX 64-Bit Platforms may genrate a similar error as above

TLS Overflow
ld: 0711-786 WARNING: TLS overflow. TLS size: 224352 Maximum size: 65536  Extra instructions are being generated for some direct references  to TLS symbols.

 

2) C++ compiler
$ORACLE_HOME/bin/genoccish[82]: xlC: 0403-006 Execute permission denied. ar: 0707-117 The fopen system call failed on file /local/sdmd/oracle/product/10.2/lib/shr.o.
$ORACLE_HOME/bin/genoccish[73]: xlC: not found. ar: A file or directory in the path name does not exist.  ar: 0707-117 The fopen system call failed on file /local/sdmd/oracle/product/10.2/lib/shr.o.

$ORACLE_HOME/bin/genoccish is unable to execute or find the C++ compiler

3) Symbol xxxxxx is already exported.
Symbol xxxxxx is already exported. ... ld: 0711-319 WARNING: Exported symbol not defined:  Cause: Bug 9828407

 

4) Many ld warnings like ld: 0711-415,ld: 0711-319,ld: 0711-773
Issue is due to unpublished Bug 12677676. This is a platform specific issue and only occurs when relinking or applying a patch on 11.2.0.X (AIX 64-bit) & higher. Other platforms are not affected.

 

SOLUTION

1) TOC overflow

These are ignorable WARNINGs as discussed in : 
Note 245372.1 - TOC overflow Warning Can Safely Be Ignored 

Further Information:

While installing One-off patches (except on 8.1.7.4) on an AIX system, 
you may see warning messages similar to the following when re-linking:

ld: 0711-773 WARNING:  ld: 0711-783 WARNING:  ld: 0711-319 WARNING:  ld: 0711-415 WARNING:  ld: 0711-224 WARNING:  ld: 0711-324 WARNING:  ld: 0711-301 WARNING:  ld: 0711-345

These warning messages are not problematic if they are reported during relinking of any binary.

Also,The TLS Overflow Message,reported during Installation/Patching of Oracle Database 12c on AIX 64-Bit Platform may be safely ignored as per confirmation from Development on Bug 18647132

 

2) C++ compiler

Check if the current Patch apply is reflected in the inventory :

% cd $ORACLE_HOME/OPatch
% ./opatch lsinventory

If the Patch is recorded in the Installed Patches list:

If you are not using OCCI
Ignore the above Warnings.

If you are using OCCI
Install the xlC compiler for AIX, as described in : Note 282036.1 - Minimum Software Versions and Patches Required to Support Oracle Products on IBM pSeries Set the xlC permissions such that the 'oracle' user can execute this compiler. Execute $ORACLE_HOME/bin/genoccish Note: The TOC overflow should be ignored

If the Patch is NOT recorded in the Installed Patches list:

If you are not using OCCI
Reapply the patch and ignore the errors

If you are using OCCI
Install the xlC compiler for AIX, as described in : Note 282036.1 - Minimum Software Versions and Patches Required to Support Oracle Products on IBM pSeries Set the xlC permissions such that the 'oracle' user can execute this compiler. Reapply the patch and ignore the errors Note: The TOC overflow should be ignored

Note :- If getting this error when xlC is installed and is in PATH, please also refer Note 558292.1

3)  Ignore the warnings

BUG 9828407 states: 

Most versions of ld will only forward parse the link line.  The warnings are due to the method Oracle uses when parsing the link line to ensure the forward parsing resolves the symbols we require. The side-effect of this on some platforms, such as AIX, is that we then end up reporting a lot of duplicate symbols due to the multiple inclusions of the libraries on the link line ... These are just 'noise' from the linker being 'pedantic' on AIX ... but it does no harm and can be safely ignored.

4) For Oracle Database/Client 11.2.0.2,Download and apply Patch:12677676 which is available on My Oracle Support.