Compare/repair does not work. it returns with "0 object compare/repair" and "BAD ROUTE" in compare log (4342434)

Compare/repair does not work. it returns with "0 object compare/repair" and "BAD ROUTE" in compare log

Running compare/repair for any tables returns right away with 0 object compare/repair.

From the compare log, there are entries like:

desvr    2015-02-02 06:23:51.615932 47218 4048541536 BAD ROUTE
desvr    2015-02-02 06:23:51.615948 47218 4048541536 002: Input line: "TIAACREF_PROD"."LABEL_HISTORY" "TIAACREF_REPORTING"."LABEL_HISTORY" xxx.xxx.xxx.xxx@o.targetdb
desvr    2015-02-02 06:23:51.615948 47218 4048541536 002: Job ID  : 213
desvr    2015-02-02 06:23:51.615948 47218 4048541536 002: Source Data : db162088
desvr    2015-02-02 06:23:51.615948 47218 4048541536 002: Parse error message : Unable to verify object

Instead of table_owner.table_name, it will generate: NO_TABLE_COMPARED

The combination of using IP address in the currrent config file and no reverse DNS or no entry in the hosts file.

SInce the ip address is used as target system, compare/repair will using IP address as the default route. However, compare/repair needs to convert the IP address to the hostname which can be done with reverse DNS or /etc/hosts.

If DNS was not configured with reverse lookup and no entry for target system in the /etc/hosts, compare/repair will fail to resolve the IP address to server name.

1. running compare/repair with target's hostname

2. adding target hostname into /etc/hosts

3. reconfiguring DNS to allow reverse lookup.