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
>> 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 |