ASAP 7 Cluster Deploy - Nagra Cartridge/Service Model Creates Wrong Sequences Distributed On Cluster
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***
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] ./Nagra/CAS/common/scripts/SarPatch_configure: SELECT TRANS_NUMBER.nextval FROM dual^J *^J
ERROR at line 1:^JORA-02289: sequence does not exist: Syntaxfehler
[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.
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