OGG-15122 No viable tables matched specification

Sometimes You can get ” OGG-15122 No viable tables matched specification” in Goldengate during add trandata operation.

 

OGG-15122 No viable tables matched specification

Details of error are as follows.

GGSCI (msdbadm02 as [email protected]) 2> add trandata MSDBA.TEST_TABLE;

2021-02-10 15:12:54 ERROR OGG-15122 No viable tables matched specification MSDBA.TEST_TABLE;


GGSCI (msdbadm02 as [email protected]) 10>

No viable tables matched specification during Add Trandata operation

If you get this error on Add trandata operation, then check if the related table exists on source or not, you may specify the wrong table name or remove the Semicolon ( ; ) from the add trandata clause as follows.
GGSCI (msdbadm02 as [email protected]) 10> add trandata MSDBA.TEST_TABLE

2021-02-10 15:14:30 WARNING OGG-06439 No unique key is defined for table REP_GOING_SMS_BTK. All viable columns will be used to represent the key, but may not guarantee uniqueness. KEYCOLS may be used to define the key.

2021-02-10 15:14:30 INFO OGG-15130 No key found for table MSDBA.TEST_TABLE. All viable columns will be logged.

2021-02-10 15:14:30 INFO OGG-15132 Logging of supplemental redo data enabled for table MSDBA.TEST_TABLE.

2021-02-10 15:14:30 INFO OGG-15133 TRANDATA for scheduling columns has been added on table MSDBA.TEST_TABLE.

2021-02-10 15:14:31 INFO OGG-15135 TRANDATA for instantiation CSN has been added on table MSDBA.TEST_TABLE.


GGSCI (msdbadm02 as [email protected]) 11>

 

 

Using Semicolon ( ; ) is the main cause of this error in this case. When I don’t use the Semicolon at the end of Add Trandata, problem has been solved.

 

Select any table to Goldengate User

Or If your case is not like in the first case, then check priviliges of Goldengate user.

 

Goldengate user should be created as follows, if any priviliges are missing then you should grant it.

 

Mostly select any table permission is not granted, if this permission is missing, then give this grant as follows.

 

GRANT SELECT ANY TABLE TO GGS_ADMIN19C;



--- Goldengate User creation and its permission

CREATE USER GGS_ADMIN19C
IDENTIFIED BY gg_123
DEFAULT TABLESPACE TSGOLDENGATE
TEMPORARY TABLESPACE TEMP
PROFILE DEFAULT
ACCOUNT UNLOCK;
-- 3 Roles for GOLDENGATE 
GRANT RESOURCE TO GGS_ADMIN19C;
GRANT CONNECT TO GGS_ADMIN19C;
GRANT SELECT_CATALOG_ROLE TO GGS_ADMIN19C;
ALTER USER GGS_ADMIN19CDEFAULT ROLE ALL;
-- 10 System Privileges for GOLDENGATE 
GRANT CREATE SESSION TO GGS_ADMIN19C;
GRANT ALTER SESSION TO GGS_ADMIN19C;
GRANT SELECT ANY DICTIONARY TO GGS_ADMIN19C;
GRANT FLASHBACK ANY TABLE TO GGS_ADMIN19C;
GRANT SELECT ANY TABLE TO GGS_ADMIN19C;
GRANT UNLIMITED TABLESPACE TO GGS_ADMIN19C;
-- 1 Tablespace Quota for GOLDENGATE 
ALTER USER GGS_ADMIN19C QUOTA UNLIMITED ON TSGOLDENGATE;
-- 2 Object Privileges for GOLDENGATE 
GRANT EXECUTE ON SYS.DBMS_FLASHBACK TO GGS_ADMIN19C;
GRANT FLASHBACK ON SYS.USER_SOURCE TO GGS_ADMIN19C;

 

 

Do you want to learn Oracle Goldengate from scratch, then read the following Goldengate Tutorial articles.

Oracle Goldengate Tutorials for Beginners

 2,905 views last month,  2 views today

About Mehmet Salih Deveci

I am Founder of SysDBASoft IT and IT Tutorial and Certified Expert about Oracle & SQL Server database, Goldengate, Exadata Machine, Oracle Database Appliance administrator with 10+years experience.I have OCA, OCP, OCE RAC Expert Certificates I have worked 100+ Banking, Insurance, Finance, Telco and etc. clients as a Consultant, Insource or Outsource.I have done 200+ Operations in this clients such as Exadata Installation & PoC & Migration & Upgrade, Oracle & SQL Server Database Upgrade, Oracle RAC Installation, SQL Server AlwaysOn Installation, Database Migration, Disaster Recovery, Backup Restore, Performance Tuning, Periodic Healthchecks.I have done 2000+ Table replication with Goldengate or SQL Server Replication tool for DWH Databases in many clients.If you need Oracle DBA, SQL Server DBA, APPS DBA,  Exadata, Goldengate, EBS Consultancy and Training you can send my email adress [email protected].-                                                                                                                                                                                                                                                 -Oracle DBA, SQL Server DBA, APPS DBA,  Exadata, Goldengate, EBS ve linux Danışmanlık ve Eğitim için  [email protected] a mail atabilirsiniz.

Leave a Reply

IT Tutorial