My Oracle Support Banner

Why is the Error 17009 On Create Replication Scheme when the replication scheme indicates individual hosts? (Doc ID 1493836.1)

Last updated on AUGUST 23, 2021

Applies to:

Oracle TimesTen In-Memory Database - Version 11.2.2.3.0 and later
Information in this document applies to any platform.

Goal

NOTE: The data used below are not actual PRODUCTION or Customer Data.  They are being used ONLY to demonstrate the problem discussed in this note.

To explain why error 17009 is returned with the following repscheme:

create replication t.r1
element e1 table t.store primary iap_nd1 on "  ora1 "
subscriber iap_nd2 on "  ora2 "
subscriber iap_te1 on " ttest1 "
subscriber iap_te2 on " ttest2 "
subscriber nd4_primary on "  ora3 "
element e2 table t.store primary iap_nd2 on "  ora2 "
subscriber iap_nd1 on "  ora1 "
subscriber iap_te1 on " ttest1 "
subscriber iap_te2 on " ttest2 "
subscriber nd4_primary on "  ora3 "
element e3 table t.store propagator nd4_primary on "  ora3 "
subscriber icp_nd1 on "  ora6 "
subscriber icp_nd2 on "  ora7 "
subscriber tel_primary on "   ora5 "
element e4 table t.store primary iap_te1 on " ttest1 "
subscriber iap_te2 on " ttest2 "
subscriber tel_primary on "   ora5 "
subscriber iap_nd1 on "  ora1 "
subscriber iap_nd2 on "  ora2 "
element e5 table t.store primary iap_te2 on " ttest2 "
subscriber iap_te1 on " ttest1 "
subscriber tel_primary on "   ora5 "
subscriber iap_nd1 on "  ora1 "
subscriber iap_nd2 on "  ora2 "
element e6 table t.store propagator tel_primary on "   ora5 "
subscriber icp_te1 on " ttest3 "
subscriber icp_te2 on " ttest4 "
subscriber nd4_primary on "  ora3 "
store iap_nd1 on "  ora1 " port 53389
store iap_nd2 on "  ora2 " port 53389
store icp_nd1 on "  ora6 " port 53389
store icp_nd2 on "  ora7 " port 53389
store nd4_primary on "  ora3 " port 53389
store tel_primary on "   ora5 "  port 53389
store iap_te1 on " ttest1 " port 53389
store iap_te2 on " ttest2 " port 53389
store icp_te1 on " ttest3 " port 53389
store icp_te2 on " ttest4 " port 53389;

17009: Stores IAP_ND1 and IAP_ND2 on host   ORA1  would be using the same replication port (53389).  These stores are not necessarily in the same replication scheme.
The command failed.

 

Solution

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Goal
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.