Errors "Capture: Unexpected Oracle error: ORA-00904: "CDB_CON_ID": invalid identifier" and "Code 904: ORA-00904: "FLAG": invalid identifier" after upgrade (4330958)

Errors "Capture: Unexpected Oracle error: ORA-00904: "CDB_CON_ID": invalid identifier" and "Code 904: ORA-00904: "FLAG": invalid identifier" after upgrade

The following errors are observed when Shareplex is upgraded from an older version to 8.6.3:

Notice   2016-06-03 20:06:19.490895 14522 1 Capture: ORA-00904: "CDB_CON_ID": invalid identifier   (capturing from name1) [module osp]

Error    2016-06-03 20:06:19.491100 14522 1 Capture: Unexpected Oracle error: ORA-00904: "CDB_CON_ID": invalid identifier  in ../src/ocap/sp_ocap.c:830  (capturing from name1) [module osp]

Info     2016-06-03 20:06:19.511554 14191 1 Capture exited with code=1, pid = 14522  (capturing from name1)

Notice   2016-06-03 20:06:19.986742 14524 1 Reader: Oracle Available  (from name1) [module ord]

Notice   2016-06-03 20:06:20.043595 14524 1 Reader: _get_routes_by_actid_async(../src/lib/odb/odb_funcs.c,1192):ErrorBlockFreeStmtHp OCI_ERROR, Code 904: ORA-00904: "FLAG": invalid identifier   (from name1) [module sys]

The SharePlex internal tables shareplex_actid and shareplex_routes have one additional columns each in 8.6.3 which were missing.

The ora_setup was not run after SharePlex upgrade. This resulted in shareplex_actid missing the column CDB_CON_ID and  shareplex_routes missing the column  FLAG causing Capture and Read to show the above errors.

Shutdown SharePlex, run ora_setup so that the internal tables are updated and restart SharePlex.

Here is the DESC of the internal tables in question in the SharePlex 8.6.3: SQL> desc shareplex_actid; Name Null? Type ----------------------------------------- -------- ---------------------------- ACTID NUMBER SEQNO NUMBER OFFSET NUMBER INSTANCE_NAME VARCHAR2(16) HOST_NAME VARCHAR2(64) AB_FLAG NUMBER QUE_SEQ_NO_1 NUMBER QUE_SEQ_NO_2 NUMBER ACTIVATION_FLAG NUMBER LOG_START_OFFSET NUMBER PITR_START_SCN NUMBER PITR_COMPLETE_SCN NUMBER CDB_CON_ID NUMBER SQL> desc shareplex_routes; Name Null? Type ----------------------------------------- -------- ---------------------------- SOURCE_NAME VARCHAR2(128) TARGET_NAME VARCHAR2(128) EXCLUSIONS VARCHAR2(2048) IP_ADDRESS NUMBER ACTIVATION_ID NUMBER ROUTING_NUMBER NUMBER FLAG NUMBER