BRM Package ACCT_SYNC Exceeding Open Cursors In Oracle Database (Doc ID 2056048.1)

Last updated on JULY 28, 2017

Applies to:

Oracle Communications Offline Mediation Controller - Version 6.0.0 to 6.0.0.3.0 [Release 6.0]
Oracle Communications Billing and Revenue Management - Version 7.5.0.0.0 to 7.5.0.0.0 [Release 7.5.0]
Information in this document applies to any platform.

Symptoms

On :  OCOMC 6.0 PS3 / NM Core

In recent days, suddenly the BRM_PIN Package called ACCT_SYNC is holding maximum number of cursors and throwing exceptions in OCOMC Nodes.

Polling Interval for the BRM Queue IFW_RECYCLE_SYNC_QUEUE is set as 1 minute.

Note : If Customer restarts OCOMC Server then around 700 cursors are getting released, but when they start again, after sometime the same issue is occurring.

Parameter value from Oracle Database :-

NAME                                     TYPE          VALUE
----------------------------       -----------   ------------------------------
open_cursors                         integer        800
session_cached_cursors          integer         50


STEPS
-----------
The issue can be reproduced at will with the following steps:
- Go to OMC_HOME/ocomc/bin
- Execute ./gui from x11 Display enabled.
- This will open OMC GUI Console.
- Login with the credentials.
- Stop RECYCLE_CC Node
- Check the Number of Open Cursors. Its very less.
- Start the RECYCLE_CC Node and wait for few hours.
- Check the Open Cursor count in database, it says 800+ for Single session ID which is holding BRM_PIN Database user.

Changes

 

Cause

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