My Oracle Support Banner

SARM Loses Oracle DB Connectivity (Doc ID 755307.1)

Last updated on JUNE 26, 2024

Applies to:

Oracle Communications ASAP - Version 5.2.0 to 5.2.4 [Release 5.2]
IBM AIX on POWER Systems (32-bit)
IBM AIX on POWER Systems (64-bit)
IBM AIX Based Systems (64-bit)IBM AIX Based Systems (32-bit)

Symptoms

SARM encountered the following error every one or two days and terminated:

Failed to open cursor
>> 202355.062:14:PROG:ASC_oci8_to_lda :1978:control/libasc/ocilib.c
Error: Open of cursor to Oracle Server IBMTSL failed rc = 0
>> 202355.062:14:PROG:ORACLE ERROR :1470:control/libasc/ocilib.c

-- ORACLE error OOPEN

>>202355.062:14:PROG:ORACLE ERROR :1474:control/libasc/ocilib.c
error message ORA-01001: invalid cursor

>>202355.062:14:PROG:ASC_ociparse :549 :control/libasc/ocilib.c
Failed to parse PLSQL block
>> 202355.062:14: LOW:ASC_ociclose_cursor :494 :control/libasc/ocilib.c
Failed to close cursor reason = 1001
>> 202355.062:14:PROG:ASC_lda_to_oci8 :2002:control/libasc/ocilib.c
Error: ASC_ociclose_cursor failed
>> 202355.062:14:PROG:ORACLE ERROR :1470:control/libasc/ocilib.c

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

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