Policy Server : Log Failed: Reason: ORA-01000: Maximum Open Cursors Exceeded (Doc ID 2230153.1)

Last updated on FEBRUARY 16, 2017

Applies to:

Oracle Communications IP Service Activator - Version 7.3.0.0.0 and later
Information in this document applies to any platform.

Symptoms

While monitoring the policy_server.log file, there were many lines with "CTable: Execute failed: ORA-01000: maximum open cursors exceeded"

EXAMPLE:
20161018-144208|0700|INF1|SQL Error With execute
20161018-144208|0700|INF1|CTable: Execute failed: ORA-01000: maximum open cursors exceeded
...............|....|....|. Statement: select max("Id") from "DeviceConfigurationLog". Position: 0. Native Code: 1000
20161018-144208|0700|INF1|CLogSinkSA: Log failed: Reason: ORA-01000: maximum open cursors exceeded
...............|....|....|. Table: DeviceConfigurationLog
20161018-144208|0700|INF1|Confirmation save failed: std::exception
20161018-144208|0700|INF1|SQL Error With execute
20161018-144208|0700|INF1|CTable: Execute failed: ORA-01000: maximum open cursors exceeded
...............|....|....|. Statement: select max("Id") from "DeviceConfigurationLog". Position: 0. Native Code: 1000
20161018-144208|0700|INF1|CLogSinkSA: Log failed: Reason: ORA-01000: maximum open cursors exceeded

 

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