SARM Loses Oracle DB Connectivity (Doc ID 755307.1)

Last updated on NOVEMBER 01, 2013

Applies to:

Oracle Communications ASAP - Version 5.2.0 to 5.2.4 [Release 5.2]
IBM AIX on POWER Systems (64-bit)
IBM AIX on POWER Systems (32-bit)
IBM AIX Based Systems (64-bit)IBM AIX Based Systems (32-bit)
***Checked for relevance on 01-NOV-2013***

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

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