Oracle Communications Eagle : CHG-GTA / DLT-GTA Commands Causes Database To Go Inconsistent

Asset ID:	1-72-2352384.1
Update Date:	2018-01-24
Keywords:

Solution Type Problem Resolution Sure

Solution 2352384.1 : Oracle Communications Eagle : CHG-GTA / DLT-GTA Commands Causes Database To Go Inconsistent

Applies to:

Oracle Communications EAGLE (Software) - Version EAGLE 44.0.2 to EAGLE 46.3 [Release EAGLE 44.0 to EAGLE 46.0]
Tekelec

Symptoms

chg-gta / dlt-gta command causes the database to go inconsistent. Database repair fixes the database in-consistence.

> rept-stat-db

Command Accepted - Processing

<Site Name> 17-10-11 05:25:30 EST EAGLE 46.3.0.0.2-68.28.0
rept-stat-db
Command entered at terminal #13.
;

<Site Name> 17-10-11 05:25:30 EST EAGLE 46.3.0.0.2-68.28.0
DATABASE STATUS: >> OK <<
           TDM 1114 ( STDBY)       TDM 1116 ( ACTV )
              C LEVEL TIME LAST BACKUP    C LEVEL TIME LAST BACKUP
- -------- ---------------------- - -------- ----------------------
FD BKUP   Y 1 -           -                 Y     1      -            -
FD CRNT Y 406820                           Y     406820
              MCAP 1113                         MCAP 1115
- -------- - --------
RD BKUP - - - - - - - -
USB BKP - - - - - - - -

;

- Here is Rtrv-gta output

> rtrv-gta:gttsn=<>:gta=<>

Command Accepted - Processing

<Site Name> 17-10-11 05:26:44 EST EAGLE 46.3.0.0.2-68.28.0
rtrv-gta:gttsn=<>:gta=<>
Command entered at terminal #13.
;

<Site Name> 17-10-11 05:26:44 EST EAGLE 46.3.0.0.2-68.28.0

GTTSN NETDOM SETTYPE NPSN NDGT
<> itu CDGTA ----- 1,5,6,7,8,9,10,11,12,14

GTA table is (62617 of 269999) 23% full.

;

<Site Name> 17-10-11 05:26:44 EST EAGLE 46.3.0.0.2-68.28.0

START GTA END GTA XLAT RI ITU PC
<> <> dpc gt <>
MRNSET=15 SSN=--- CCGT=no
GTMODID=--------- TESTMODE=off
LOOPSET = none FALLBACK=sysdflt
OPTSN=<> CGSELID=----- CDSELID=----- OPCSN=---------
ACTSN=--------- PPMEASREQD= no
CGPCACTION=dflt

Command Retrieved 1 Entries

- chg-gta causes the database to go inconsistent

> chg-gta:gttsn=<>:gta=<>:optsn=none

Command Accepted - Processing

<Site Name> 17-10-11 05:27:08 EST EAGLE 46.3.0.0.2-68.28.0
chg-gta:gttsn=<>:gta=<>:optsn=none
Command entered at terminal #13.
;

<Site Name> 17-10-11 05:27:09 EST EAGLE 46.3.0.0.2-68.28.0
CHG-GTA: MASP B - Failed during active object change.
;

<Site Name> 17-10-11 05:27:09 EST EAGLE 46.3.0.0.2-68.28.0
CHG-GTA: MASP B - Command Aborted: Database maintenance is required
;

<Site Name> 17-10-11 05:27:09 EST EAGLE 46.3.0.0.2-68.28.0
* 5020.0034 * CARD 1115 OAMHC Card database is inconsistent
;
> rept-stat-db

Command Accepted - Processing

<Site Name> 17-10-11 05:28:27 EST EAGLE 46.3.0.0.2-68.28.0
rept-stat-db:display=all
Command entered at terminal #13.
;

<Site Name> 17-10-11 05:28:28 EST EAGLE 46.3.0.0.2-68.28.0
DATABASE STATUS: >> NOT OK (DMS) <<
       TDM 1114 ( STDBY) TDM 1116 ( ACTV )
       C LEVEL TIME LAST BACKUP C LEVEL TIME LAST BACKUP
- -------- ---------------------- - -------- ----------------------
FD BKUP Y 1    -     -          Y 1 -     -
FD CRNT Y 406820                N 406820 INCOHERENT
     MCAP 1113                 MCAP 1115
- -------- - --------
RD BKUP - - - - - - - -
USB BKP - - - - - - - -

- Database repair fixes the issue

> chg-db:action=repair

Command Accepted - Processing

<Site Name> 17-10-11 05:35:04 EST EAGLE 46.3.0.0.2-68.28.0
chg-db:action=repair
Command entered at terminal #13.
;

<Site Name> 17-10-11 05:35:04 EST EAGLE 46.3.0.0.2-68.28.0
REPAIR: MASP A - Repair starts on standby MASP.
;

<Site Name> 17-10-11 05:36:56 EST EAGLE 46.3.0.0.2-68.28.0
REPAIR: MASP A - Repair from fixed disk complete.
;

<Site Name> 17-10-11 05:36:56 EST EAGLE 46.3.0.0.2-68.28.0
** 0013.0013 ** CARD 1115 OAMHC Card is isolated from the system
ASSY SN: <>
;

<Site Name> 17-10-11 05:36:57 EST EAGLE 46.3.0.0.2-68.28.0
** 0014.0539 ** ENET 1115,A Ethernet Interface Down
;

> rept-stat-db

Command Accepted - Processing

<Site Name> 17-10-11 05:39:08 EST EAGLE 46.3.0.0.2-68.28.0
rept-stat-db
Command entered at terminal #13.
;

<Site Name> 17-10-11 05:39:08 EST EAGLE 46.3.0.0.2-68.28.0
DATABASE STATUS: >> OK <<
       TDM 1114 ( ACTV ) TDM 1116 ( STDBY)
       C LEVEL TIME LAST BACKUP C LEVEL TIME LAST BACKUP
- -------- ---------------------- - -------- ----------------------
FD BKUP Y 1    -    -           Y   1    -     -
FD CRNT Y 406820                Y 406820
     MCAP 1113                 MCAP 1115
- -------- - --------
RD BKUP - - - - - - - -
USB BKP - - - - - - - -

;

Cause

Bug 19110738 - [204917]Chg-GTT/GTA does not increment the MRNSET count.

Solution

Contact Oracle Support for a workaround to fix the issue.

Here is the workaround that was applied at Tata to fix the database.

Rept-stat-trbl:display=timestamp
Chg-trm:trm=xx:all=yes
rtrv-mrn:on=refcnt
rtrv-mrn:on=refcnt:pcn=<>:mrnset=15
rtrv-gta:gttsn=<>:mrnset=15
ent-mrn:mrnset=15:pcn=<>:pcn1=<>:rc1=10
rtrv-mrn:on=refcnt:pcn=<>:mrnset=15
rept-stat-db
rtrv-gta:gttsn=<>:mrnset=15
send-msg:loc=<standby MASP>:ds=1:da=h'1d:f=h'80:oa=h'30 --> Execute the send-msg on standby MASP and wait for completion message i.e. "Re-calculation of MAP and MRN ref count has completed on 1115".
send-msg:loc=<Active MASP>:ds=1:da=h'1d:f=h'80:oa=h'30 --> Execute the send-msg on active MASP and wait for completion message i.e. "Re-calculation of MAP and MRN ref count has completed on 1113".
rtrv-gta:gttsn=<>:mrnset=15
rtrv-mrn:on=refcnt:pcn=<>:mrnset=15
chg-gta:gttsn=<>:gta=<>:optsn=none
rtrv-gta:gttsn=<>:mrnset=15
chg-gta:gttsn=<>:gta=<>:optsn=none
rtrv-gta:gttsn=<>:mrnset=15
rept-stat-db

References

<BUG:19110738> - [204917]CHG-GTT/GTA DOES NOT INCREMENT THE MRNSET COUNT.
<BUG:19107248> - [204917]CHG-GTT/GTA DOES NOT INCREMENT THE MRNSET COUNT.
<BUG:19107249> - [204917]CHG-GTT/GTA DOES NOT INCREMENT THE MRNSET COUNT.
<BUG:19107250> - [204917]CHG-GTT/GTA DOES NOT INCREMENT THE MRNSET COUNT.
<NOTE:1227943.1> - How to Edit Output from Oracle Tools and Utilities to Remove Sensitive Content
<BUG:19085792> - [204917]CHG-GTT/GTA DOES NOT INCREMENT THE MRNSET COUNT.

Attachments

This solution has no attachment