ASAP 7 Cluster Deploy - Nagra Cartridge/Service Model Creates Wrong Sequences Distributed On Cluster

(Doc ID 1323419.1)

Last updated on OCTOBER 28, 2013

Applies to:

Oracle Communications ASAP - Version 7.0.0 and later
Information in this document applies to any platform.
***Checked for Relevance on 28-Oct-2013***

Symptoms

 The Customer successfully deployed the NAGRA CAS cartrdige on an ASAP7 in the testing environments. However they found a strange issue when deploying in Production on Clustered (RAC) environment.

The following error message was received:


[exec] Not detected sequence for TRANS_NUMBER. Creating it...
[exec] ./Nagra/CAS/common/scripts/SarPatch_configure[312]: SELECT TRANS_NUMBER.nextval FROM dual^J *^J
ERROR at line 1:^JORA-02289: sequence does not exist: Syntaxfehler
[exec]
[exec] Sequence created.



This indicates that there is a problem with the sequence TRANS_NUMBER.
When the customer crosschecked with their DBA, they found out that the sequence is created independently on both (cluster) nodes, so it counts up independently on both nodes. Thus the script:

SarPatch_configure is checking if NEXTVAL > 0 and it fails. According to the DBA it gets connected to one of the nodes at random and gets different values. According to the documentation the script should use different statements for creating sequences that are accepted in sync on multiple nodes.

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