ORA-04031

"ORA-04031: Unable To Allocate 1667330712 Bytes Of Shared Memory ("shared Pool","unknown Object","sg (Doc ID 1627802.1)

APPLIES TO:

Oracle Database - Enterprise Edition - Version 11.2.0.3 to 12.1.0.1 [Release 11.2 to 12.1]
Information in this document applies to any platform.
***Checked for relevance on 28-Jul-2015***

SYMPTOMS

Alert log reports next error:

ORA-04031: unable to allocate 1667330712 bytes of shared memory
("shared pool","unknown object","sga heap(1,1)","KZS MTS Network Context")
 

CHANGES

 Kerberos is enabled in a shared server environment.

CAUSE

The issue is addressed in unpublished
Bug 16446347 - KERBEROS DOES NOT WORK IN SHARED SERVERS

The bug is fixed in:

12.2 (Future Release)
12.1.0.2 (Server Patch Set)
Please refer to:Note 16446347.8 - Bug 16446347 - Kerberos does not work in shared servers


SOLUTION

To solve the issue, use any of below alternatives:

Apply patch set 12.1.0.2

- OR -

Apply interim patch 16446347, if available for your platform and Oracle version.

To check for conflicting patches, please use the MOS Patch Planner Tool
Please refer to
Note 1317012.1 - How To Use MOS Patch Planner To Check And Request The Conflict Patches?

If no patch exists for your version, please contact Oracle Support for a backport request.

- OR -

As a workaround:
Disable Kerberos.

- OR -

Disable Shared Server Configuration if this is not an application requirement.


REFERENCES

NOTE:16446347.8 - Bug 16446347 - Kerberos does not work in shared servers