-
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
-
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.
-
Thanks for the reply.
I'm not quite sure if I follow. Can you please elaborate on "setting within the database" ...please
thanks
Jay
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|