My Oracle Support Banner

ALM 8.0.7 Processes and Batches Fail With Multiple "ORA-01013", "ORA-01023" and "ORA-03106" Errors (Doc ID 2597384.1)

Last updated on FEBRUARY 07, 2020

Applies to:

Oracle Financial Services Asset Liability Management - Version 8.0.7 and later
Information in this document applies to any platform.
Oracle Financial Services Asset Liability Management - OFS ALM
Oracle Financial Services Analytical Applications Infrastructure - OFSAAI
Oracle Financial Services Analytical Applications - OFSAA

Symptoms

On ALM 8.0.7 all processes, batches and jobs are failing with OFS 203105 & multiple ORA errors as per below:

ERROR


Module Logging OFS errors: (203105) Oracle drv_oci error: OCI Function: [54] - oparse() SQL
  Function: [5] -
UPDATE Oracle Error: ORA- 01023: Cursor context not found
  (Invalid cursor number) Driver Function: drv_oci::Prepare() SQL
  Statement:
ALTER SESSION
SET CURSOR_SHARING = FORCE


Module Logging OFS errors: (203105) Oracle drv_oci error: OCI Function: [4] - oexec(),
  oexn() SQL Function: [52] -
ALTER SESSION Oracle Error: ORA- 01013: user requested cancel of
  current operation Driver Function: drv_oci::Execute() SQL
  Statement:
ALTER SESSION
SET CURSOR_SHARING = FORCE


Module Logging OFS errors: (203105) Oracle drv_oci error: OCI Function: [16] - oclose() SQL
  Function: [52] -
ALTER SESSION Oracle Error: ORA- 03106: fatal two- task
  communication protocol error Driver Function: drv_oci::EndSQL SQL
  Statement:
ALTER SESSION
SET CURSOR_SHARING = FORCE

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
Cause
Solution
References


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