Solution : https://service.sap.com/sap/support/notes/1733335 (SAP Service marketplace login required)
Summary :
This SAP Note addresses a hanging tnslsnr process issue when SAP applications attempt to connect or reconnect to Oracle Database versions 11.2.0.2 and 11.2.0.3. A key symptom is an inability to use "sqlplus / as sysdba", with Oracle logs showing ORA-3136 warnings. The problem originates from previous SAP Bundle Patches which manipulate the Oracle binary's linking options relating to the USLA heap. Solutions include applying an Oracle patch that supports a new linking flag, shrsymtab, if the AIX system supports it. Users without the new linker support should refrain from using online patching with the shrsymtab option. Patch installations should verify AIX versions for compatibility. APAR IV20880 is referenced for related system crash issues.
Key words :
nsf/5cb5ed706d254a8186256c71006d2e0a/9b6f0d3d238834df85257997005cb4ae/$file/hot%20patching%20012312, -brtllib -bexpfull -bshrsymtabthe official ibm statement, 10190759 - processes consuming additional memory due, 5 20120310190759 - processes consuming additional memory due, 2 20120310190759 - processes consuming additional memory due, usla heap13443029 - memory leak fix, online patching / hot patchingplease check, online patching / hot patchingpatch 13640901 - added, installed apar iv20880 online patching, oracle binary disabling online patching
Related Notes :
| 1656659 | GI 11.2.0: Patches / Patch Collections for 11.2.0.3 |
| 1631931 | Oracle 11.2.0: Patches / Patch collections for 11.2.0.3 |
| 1597736 | GI 11.2.0: Patches / Patch Collections for 11.2.0.2 |
| 1552849 | Oracle 11g: Process consuming more memory running on AIX |
| 1503709 | Oracle 11.2.0: Patches / Patch collections for 11.2.0.2 |