OGG-02538 Cannot unregister REPLICAT REPIR because of the following SQL error: OCI Error ORA-00942: table or view does not exist (status = 942)

Unregistering an INTEGRATED REPLICAT from an unsupported Oracle database (11.2.0.3)

OGG-02538  Cannot unregister REPLICAT REPIR because of the following SQL error: OCI Error ORA-00942: table or view does not exist (status = 942).

Database Version: 11.2.0.3
Golden gate Version: 12.2

In this blog we are going to see how to manually remove an integrated replicat after configure on unsupported Oracle Database release 11.2.0.3.

GGSCI> delete REPTMP

2019-04-20 11:47:36  ERROR   OGG-02538  Cannot unregister REPLICAT REPIR because of the following SQL error:

OCI Error ORA-00942: table or view does not exist (status = 942).

There is two option to delete replicat from unsupported oracle database release.

1. Try to delete replicat using force option:

GGSCI> delete  replicat REPTMP !

If may be we are getting the same error message then we need to move second option.

2. Execute dba_xstream_inbound and dba_apply packages:

Connect database using sysdba and run below two select queries.

 select * from dba_xstream_inbound;
 select * From dba_apply;

If above two queries are return any values then need to  execute below two mentioned packages.

This two packages will remove the entries from above two tables.

exec dbms_xstream_adm.drop_inbound(‘<your inbound server name>’);

exec dbms_apply_adm.drop_apply(‘<your apply name>’);

Then we can delete registered replicat without any error.

  • April 25, 2019 | 32 views
  • Comments