oms.core <600129> "Unable To Allocate Bytes Of Shared Memory" Error Received

(Doc ID 1286584.1)

Last updated on MAY 13, 2018

Applies to:

Oracle Communications Order and Service Management - Version 6.3.1 and later
Information in this document applies to any platform.
Checked for relevance on 06-Jul-2015

Goal

What is the solution to get rid of following exception?

<Jan 13, 2011 9:24:44 AM EET> <Error> <oms.core> <600129> <SQL Exception 604 : ORA-00604: error occurred at recursive SQL level 2
ORA-04031: unable to allocate 1048 bytes of shared memory ("shared pool","select /*+ rule */ bucket_cn...","Typecheck","kgghteInit")

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms