Oracle Identity Manager(OIM) 11g error: ORA-12516: TNS:LISTENER COULD NOT FIND AVAILABLE HANDLERWITH MATCHING PROTOCOL STACK

Issue:

OIM Managed Server some times shows  ORA-12516: TNS:LISTENER COULD NOT FIND AVAILABLE HANDLER WITH MATCHING PROTOCOL STACK error.

Solution:

Connect OIM database as schema owner(Example: DEV_OIM) and increate processes and sessions count as shown below:

alter system set processes=300 scope=spfile;

alter system set sessions=300 scope=spfile;

Note: You need to restart database to take effect.

Thanks