Oracle Installation and upgrade: a series of errors and patches after the upgrade to 11.2.0.3

In the test environment aix6106, after Patch: 10190759 is installed, database boot generates a ORA-07445: predictionencountered: coredump [PC: 0x0] [SIGILL]

In the test environment aix6106, after Patch: 10190759 is installed, database boot produces a ORA-07445: exception encountered: core dump [PC: 0x0] [SIGILL]

After Oracle is upgraded to 11.2.0.3, there will be a series of Performance or Wrong Results. According to the metalink Document ID 1392633.1, the solution is as follows:

Scope
This note concerns itself with highly updated patches in 11.2.0.3 that are not supported in PSU updates, either because they contain optimizer layer fixes or because the PSU that will contain in them has not yet been released.
Things to Consider Before Upgrading to 11.2.0.3 to Avoid Poor Performance or Wrong Results
While we try and include important fixes in the PSUs that are released on a quarterly basis, there are restrictions as to what can go into a PSU. one of the restrictions is fixes that may change execution plans, I. e. optimizer layer fixes. the reason for this is that it has CES the amount of testing required to go from one PSU to another. other fixes may not yet have been released in a PSU.
Please consider applying the following patches, in addition to the latest PSU, to avoid certain performance, ORA-600/ORA-7445, and wrong results issues.
Patches relevant for all platforms
Patch: 13656236 Merge patch fixing the following two bugs:
Document: 13004894.8 Wrong results with SQL _TRACE/10046
Document: 13370330.8Bug 13370330-ORA-600 [qkeIsExprReferenced1] From Query With Virtual Column
Patch: 13831007 merge request on top of 11.2.0.3.0 for bugs 12797420 13588248
This merge primary des 3 fixes in the area of Mutex Contention plus addresses a regression created by one of them. this merge can be used on either 11.2.0.3.0 or 11.2.0.3.1. we are hoping to have them encoded in the 11.2.0.3.2 PSU.

There is no problem when installing the above patch on linux. However, some exceptions occur when installing the following patch on AIX.

Patches specific to IBM AIX
Patch: 12412983AIX: "asynch descriptor resize" wait not necessary on AIX
Patch: 12596494 generally higher cpu usage in 11.2.0.2 THAN 10.2.0.4
Patch: 13443029 memory leak fix for online patching/HOT PATCHING
This operation CES memory usage associated with the online patching feature.
AIX 6.1 TL7 or above (such as AIX 7.1) must be installed before either installing the patch or relinking the Oracle binary for it to be without tive. if you are on an earlier version of AIX, then you may wish to consider installingPatch: 10190759 instead, but keep in mind that doing so will disable online patching.
In the test environment aix6106, after Patch: 10190759 is installed, database boot produces a ORA-07445: exception encountered: core dump [PC: 0x0] [SIGILL] [ADDR: 0x0] [PC: 0x0] [Illegal opcode] [], and then install Patch: 13443029, it may be related to my system environment ......
Please seethis notefrom IBM for more information.
13343438 this patch: If PSU to 11.2.0.3.1 is installed, it will conflict with PSU. If you need to install PSU after upgrading to 11.2.0.3.0, we recommend that you do not install this patch first.
As follows:
[Oracle @ p520 p13348650] $/oracle/app/oracle/product/11.2.0.3/OPatch/opatch prereq CheckConflictAgainstOHWithDetail-phBaseDir. /13348650/custom/server/13348650-oh/oracle/app/oracle/product/11.2.0.3
Oracle Interim Patch Installer version 11.2.0.3.0
Copyright (c) 2012, Oracle Corporation. All rights reserved.
PREREQ session
Oracle Home:/oracle/app/oracle/product/11.2.0.3
Central Inventory:/oracle/app/oraInventory
From:/oracle/app/oracle/product/11.2.0.3/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/export toollogs/opatch/opatch2012-04-01_14-50-11PM_1.log
Invoking prereq "checkconflictagainstohwithdetail"
The ZOP-40: the patch (es) has conflicts with other patches installed in The Oracle Home (or) among themselves.
Prereq "checkConflictAgainstOHWithDetail" failed.
Summary of Conflict Analysis:
There are no patches that can be applied now.
Following patches have conflicts. Please contact Oracle Support and get the merged patch of the patches:
12412983,133 43438
Following patches will be rolled back from Oracle Home on application of the patches in the given list:
12412983
Conflicts/Supersets for each patch are:
Patch: 13343438
Conflict with 12412983
Conflict details:
/Oracle/app/oracle/product/11.2.0.3/lib/libserver11.a:/ksfd. o
OPatch succeeded.

If the original patch has been installed, we recommend that you roll back the conflicting patch before installing PSU.
/Oracle/app/oracle/product/11.2.0.3/OPatch/opatch rollback-local-oh/oracle/app/oracle/product/11.2.0.3-id 12412983

For more information about Oracle, see the Oracle topic page? Tid = 12

,