Oralce 11202 - dataguard - StaticConnectIdentifier
Hi,
I've configured standby dataguard on a 11202 database version. The logs are being shipped and applied. The configuration looks good. However, I have one question that might be an issue during a Switchover.
The Listener/tnsnames ports are 1566 for both primary and standby.
But when I do show database verobse for both primary and standby , the value for the PORT in StaticConnectIdentifier is 1521.
Should I change it using set property commands in dgmgrl to 1566?
StaticConnectIdentifier = '(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=hostname1)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=ORCL_DG MGRL)(INSTANCE_NAME=ORCL)(SERVER=DEDICATED)))'
StaticConnectIdentifier = '(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=hostname2)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=STBY_DG MGRL)(INSTANCE_NAME=ORCL)(SERVER=DEDICATED)))'
Appreciate your help
Jay