My Oracle Support Banner

SMS Screens Doesn't Use Bind Variables when Querying Subscriber EDRs and Database Shared Pool is Overflow with Error "Ora-04031: Unable to Allocate Xxx Bytes of Shared Memory" (Doc ID 1440442.1)

Last updated on APRIL 23, 2021

Applies to:

Oracle Communications Network Charging and Control - Version 4.4.0 and later
Information in this document applies to any platform.

Symptoms

  1. PImanager, ccsProfileDaemon, smsMaster and ccsPeriodicCharge ...etc.
  2. Replication events were accumulated and not sent to the replication client nodes.
  3. Replication Jobs execution failed and were marked as broken.

On the impacted SMS node (These commands should be run from the SMS. If the SMS is a cluster, run these commands from only impacted node):

Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

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


In this Document
Symptoms
Changes
Cause
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.