Oralce 11202 - dataguard - StaticConnectIdentifier
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Oralce 11202 - dataguard - StaticConnectIdentifier

  1. #1
    Join Date
    Feb 2001
    Posts
    128

    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

  2. #2
    Join Date
    Nov 2000
    Location
    Pittsburgh, PA
    Posts
    3,974
    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

  3. #3
    Join Date
    Feb 2001
    Posts
    128
    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
  •  



Click Here to Expand Forum to Full Width