Return
-
Title
Compare config fails when using upper and lower case SID combination for Source and Target -
Description
Replication works fine but Compare config OR compare with complete Target routing information fails when using the upper and lower case SID combination on Source and Target.This only happens when using the same SID name on both sides with different case.Example:sp_ctrl (XXXXX:8497)> view config 4.confdatasource:o.ora11gr2#source tables target tables routing mapscott.test_interval_part scott.test_interval_part Target_server@o.ORA11GR2scott.test1 scott.test1 10.112.23.154@o.ORA11GR2sp_ctrl (XXXXX:8497)> compare using 4.confCannot compare "SCOTT"."TEST_INTERVAL_PART"Invalid specification scott.test_interval_part scott.test_interval_part Target_server@o.ORA11GR2Table "SCOTT"."TEST_INTERVAL_PART" is in replication, but not to target specifiedSpecify correct target or use the force option to compareCannot compare "SCOTT"."TEST1"Invalid specification scott.test1 scott.test1 Target_server_IP@o.ORA11GR2Table "SCOTT"."TEST1" is in replication, but not to target specifiedSpecify correct target or use the force option to compareChanging the Target routing to lower case SID works.sp_ctrl (XXXXX:8497)> view config 5.confdatasource:o.ora11gr2#source tables target tables routing mapscott.test_interval_part scott.test_interval_part Target_server@o.ora11gr2scott.test1 scott.test1 Target_server_IP@o.ora11gr2sp_ctrl (XXXXX:8497)> compare using 5.confcomparing 2 of 2 objectscompare started; job id 6sp_ctrl (XXXXX:8497)>
Sign In Required
You need to be signed in and under a current maintenance contract to view premium knowledge articles.