Problem :
This is after tddevlopmentcop1
became inactive , without properly terminating/stopping GG groups .
Below is the error we get when we start the extract ( example RGNL01) .
Control RSG’s were created on tddevcop1 and now this system is not accessible for VAM
and tddevcop2 doesn’t get recognized .
We may need RSG’s to be reset.
2015-06-23 22:56:08 ERROR OGG-00146 VAM
function VAMInitialize returned unexpected result: error 600 - VAM Client
Report <VAMInitialize: Error response return
ed from RSG 0 for data signon (Data connection to this Vproc is
invalid.)>.
Remedy :
You need to bypass access right and execute below commands :
1. This
update break relationship between replication group and its members
a. For
all tables
update dbc.tvm
set TblStatus ='D',tblrole=null, RSGroupID =null
where TblStatus is not null
b. For
particular table/member
update dbc.tvm
set TblStatus ='D',tblrole=null, RSGroupID =null
where tvmname = 'N_FIN_DEPT_TO_PIN_LINK' and databaseid in ( sel databaseid from
dbc.databases2 where databasename = 'ENGGDB_DDR');
2. To
drop such groups you need to execute below statements
DELETE from DBC.RepGroup ;
DELETE from
DBC.RepGroupTables ;
DELETE from
DBC.RepRulesetTbl ;
DELETE from
DBC.RepCaptureRulesTbl ;
3. Now
you can test by creating new group and adding member into it.
create replication group test1;
alter replication group test1 drop
sysdba.statsinfo;
help replication group test1;
sel * from dbc.repgroup;
drop replication group test1
