Oralce 11202 - dataguard - StaticConnectIdentifier
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
I could be that the settings within the database are different from that withing
dgmgrl. You can try going into dgmgrl and checking to see what the configuration is.
You can even delete and recreate the dataguard configuration.
this space intentionally left blank
Thanks for the reply.
I'm not quite sure if I follow. Can you please elaborate on "setting within the database" ...please
Click Here to Expand Forum to Full Width