【Oracle patch】installing one-off Patch on AIX systems, getting several WARNING 0711-415 0711-773在AIX上安装Oracle one-off patch 10190759时，出现以下报错： [p520]/tmp/oracle/patch/one-off $/oracle/app/oracle/product/11.2.0.3/dbhome_1/OPatch/opatch napply -local -oh /oracle/app/oracle/product/11.2.0.3/dbhome_1 -id 10190759
Oracle Interim Patch Installer version 11.2.0.3.0
Copyright (c) 2012, Oracle Corporation. All rights reserved.
Oracle Home : /oracle/app/oracle/product/11.2.0.3/dbhome_1
Central Inventory : /oracle/app/oraInventory
from : /oracle/app/oracle/product/11.2.0.3/dbhome_1/oraInst.loc
OPatch version : 11.2.0.3.0
OUI version : 11.2.0.3.0
Log file location : /oracle/app/oracle/product/11.2.0.3/dbhome_1/cfgtoollogs/opatch/opatch2012-04-26_11-01-42AM_1.logVerifying environment and performing prerequisite checks...
OPatch continues with these patches: 10190759 Do you want to proceed? [y|n]
y
User Responded with: Y
All checks passed.
Provide your email address to be informed of security issues, install and
initiate Oracle Configuration Manager. Easier for you if you use your My
Oracle Support Email address/User Name.
Visit [url]http://www.oracle.com/support/policies.html for details.
Email address/User Name: You have not provided an email address for notification of security issues.
Do you wish to remain uninformed of security issues ([Y]es, [N]o) [N]: yPlease shutdown Oracle instances running out of this ORACLE_HOME on the local system.
(Oracle Home = '/oracle/app/oracle/product/11.2.0.3/dbhome_1')
Is the local system ready for patching? [y|n]
y
User Responded with: Y
Backing up files...
Applying interim patch '10190759' to OH '/oracle/app/oracle/product/11.2.0.3/dbhome_1'Patching component oracle.rdbms, 11.2.0.3.0...Verifying the update...OPatch found the word "warning" 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 ldxdts is already exported.
ld: 0711-415 WARNING: Symbol ldxsto is already exported.
ld: 0711-415 WARNING: Symbol lnxadd is already exported.
ld: 0711-415 WARNING: Symbol lnxcopy is already exported.
ld: 0711-415 WARNING: Symbol lnxmin is already exported.
ld: 0711-415 WARNING: Symbol lnxmul is already exported.
ld: 0711-415 WARNING: Symbol lnxnur is already exported.
ld: 0711-415 WARNING: Symbol lnxren is already exported.
ld: 0711-415 WARNING: Symbol lnxsca is already exported.
ld: 0711-415 WARNING: Symbol lnxshift is already exported.
ld: 0711-415 WARNING: Symbol lnxsni is already exported.
ld: 0711-415 WARNING: Symbol lxgu2t is already exported.
ld: 0711-415 WARNING: Symbol sldxgd is already exported.
ld: 0711-773 WARNING: Object /oracle/app/oracle/product/11.2.0.3/dbhome_1/lib//liboraolap11.a[sxstime.o], imported symbol timezone
Symbol was expected to be local. Extra instructions
are being generated to reference the symbol.
ld: 0711-773 WARNING: Object /oracle/app/oracle/product/11.2.0.3/dbhome_1/lib//libgeneric11.a[sdbgrfu.o], imported symbol timezone
Symbol was expected to be local. Extra instructions
are being generated to reference the symbol.
ld: 0711-773 WARNING: Object /oracle/app/oracle/product/11.2.0.3/dbhome_1/lib//libordsdo11.a[mdowd.o], imported symbol ksudbrmseccnt_
Symbol was expected to be local. Extra instructions
are being generated to reference the symbol.
ld: 0711-773 WARNING: Object /oracle/app/oracle/product/11.2.0.3/dbhome_1/lib//libordsdo11.a[mdrt.o], imported symbol ksudbrmseccnt_
Symbol was expected to be local. Extra instructions
are being generated to reference the symbol.
ld: 0711-773 WARNING: Object /oracle/app/oracle/product/11.2.0.3/dbhome_1/lib//libordsdo11.a[mdidx.o], imported symbol ksudbrmseccnt_
Symbol was expected to be local. Extra instructions
are being generated to reference the symbol.
ld: 0711-773 WARNING: Object /oracle/app/oracle/product/11.2.0.3/dbhome_1/lib//libordsdo11.a[mdrcr.o], imported symbol kcbstdbz_
Symbol was expected to be local. Extra instructions
are being generated to reference the symbol.
ld: 0711-773 WARNING: Object /oracle/app/oracle/product/11.2.0.3/dbhome_1/lib//libordsdo11.a[mdrt.o], imported symbol kcbstdbz_
Symbol was expected to be local. Extra instructions
are being generated to reference the symbol.
ld: 0711-773 WARNING: Object /oracle/app/oracle/product/11.2.0.3/dbhome_1/lib//libordsdo11.a[mdrcnc.o], imported symbol mdrcnccmt_
Symbol was expected to be local. Extra instructions
are being generated to reference the symbol.
ld: 0711-783 WARNING: TOC overflow. TOC size: 227192 Maximum size: 65536
Extra instructions are being generated for each reference to a TOC
symbol if the symbol is in the TOC overflow area.
Patch 10190759 successfully applied.
OPatch Session completed with warnings.
Log file location: /oracle/app/oracle/product/11.2.0.3/dbhome_1/cfgtoollogs/opatch/opatch2012-04-26_11-01-42AM_1.logOPatch completed with warnings.
安装完成后，检查patch是成功的。
[p520]/home/oracle $/oracle/app/oracle/product/11.2.0.3/dbhome_1/OPatch/opatch lsinventory
Oracle Interim Patch Installer version 11.2.0.3.0
Copyright (c) 2012, Oracle Corporation. All rights reserved.

Oracle Home : /oracle/app/oracle/product/11.2.0.3/dbhome_1
Central Inventory : /oracle/app/oraInventory
from : /oracle/app/oracle/product/11.2.0.3/dbhome_1/oraInst.loc
OPatch version : 11.2.0.3.0
OUI version : 11.2.0.3.0
Log file location : /oracle/app/oracle/product/11.2.0.3/dbhome_1/cfgtoollogs/opatch/opatch2012-04-26_11-04-36AM_1.log

Lsinventory Output file location : /oracle/app/oracle/product/11.2.0.3/dbhome_1/cfgtoollogs/opatch/lsinv/lsinventory2012-04-26_11-04-36AM.txt

--------------------------------------------------------------------------------
Installed Top-level Products (1):

Oracle Database 11g 11.2.0.3.0
There are 1 products installed in this Oracle Home.

Interim patches (3) :

Patch 10190759 : applied on Thu Apr 26 11:03:32 GMT+08:00 2012
Unique Patch ID: 14249255
Created on 8 Dec 2011, 15:26:38 hrs UTC
Bugs fixed:
10190759

查询metalink，以上报错解决方法如下，但以上报错也是可以忽略的：

[size=18pt]Applies to: Oracle Server - Enterprise Edition - Version: 10.2.0.2.0
This problem can occur on any platform.[size=18pt]SymptomsYou are trying to install an Interim/One-off Patch on AIX platform.
You are encountering WARNINGs in the relinking stage of the Patch Apply.

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

...
...
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.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~[size=18pt]CauseThese are not errors and are just expected WARNING messages.
They can be ignored.

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
The following issues are specific to AIX.

(i) When installing patches on ALL releases you may receive the following error:
######################################
xlC: not found
######################################
OR
######################################
xlC: 0403-006 Execute permission denied.
######################################
If you are not using OCCI, then the error message can be safely ignored.
If you are using OCCI, the then AIX C++ compiler must be installed and in the PATH.
Further, the ORACLE user must have execute (x) permissions on xlC.
Issue the following to confirm the above :
######################################
% which xlC
% xlC
######################################
If you are indeed using OCCI :
and if xlC is not found, determine its location and add the directory to the PATH environment variable.
If it is not installed, it is required to be installed for suppressing the above received WARNINGs.
Once it is installed, determine its location and add the directory to the PATH environment variable.
Ensure that the ORACLE user has execute permissions on xlC executable.

(ii)
##############################################################
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.
###############################################################
are ignorable WARNINGs as discussed in :
Note 245372.1 - TOC overflow Warning Can Safely Be Ignored
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Table Of Contents (TOC) area is a piece of memory which is reserved for compiling
programs The maximum size of the TOC is 64K and this can be blown by some
programs. The TOC message is just a warning and can 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:
############################
ld: 0711-773 WARNING:
ld: 0711-783 WARNING:
ld: 0711-319 WARNING:
ld: 0711-415 WARNING:
ld: 0711-224 WARNING:
############################
when re-linking 64-bit binaries in 32-bit kernel mode.
These warning messages are not problematic if they are reported
during relinking of any 64-bit binary in 32-bit kernel mode.
To check the current mode of the kernel, run the following command:

% /usr/sbin/bootinfo -K

The result will be "32" for 32-bit or "64" for 64-bit kernel mode.
By default the result will be 32.

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~[size=18pt]SolutionPlease check if the current Patch apply is reflected in the inventory :

% cd $ORACLE_HOME/OPatch
% ./opatch lsinventory

Look for Installed Interim Patch #
If the Patch applied, is available in the Installed Patches list, and

(i) If you are not using OCCI, then :
=======================
Ignore the above Warnings.
=======================

(ii) If you are using OCCI,
==========================================
a. Rollback the applied Patch.
b. 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
c. Set the xlC permissions such that the 'oracle' user can execute this compiler.
d. Re-apply the Patch to correct the xlC WARNINGs.
e. The TOC errors, if still exist, must be ignored.
==========================================

------------------------ O ---- X ---- O -----------------------------

Additional Information :
~~~~~~~~~~~~~~~~~~~~~
In case the applied Patch is not available in opatch lsinventory output in the first place,
then there are different issues that have caused the patch apply failure.
Please log a Service Request with Oracle Support
and provide the OPatch apply failure log + system RDA for further analysis.