Skip to main content
Docs
Feature Requests Onboarding Trust Center Status Page

Community

Allow an option to configure ORACLE SCAN ADDRESS to use multiple values

Answered
Chakrapani Rao User

Which database system?:  Oracle: Currently, we can configure only one DNS information. If you can enhance to have option to configure with role based, it will be great.

Example: of multiple DNS connection string. 

(DESCRIPTION_LIST=
   (LOAD_BALANCE=off)
   (FAILOVER=on)
   (DESCRIPTION=
     (CONNECT_TIMEOUT=5)(TRANSPORT_CONNECT_TIMEOUT=3)(RETRY_COUNT=3)
     (ADDRESS_LIST=
       (LOAD_BALANCE=on)
       (ADDRESS=(PROTOCOL=TCP)(HOST=jiradb0p_wrn-cn.edc.nam.gm.com)(PORT=1521)))
     (CONNECT_DATA=(SERVICE_NAME=jiradb0p_srv.edc.nam.gm.com)))
   (DESCRIPTION=
     (CONNECT_TIMEOUT=5)(TRANSPORT_CONNECT_TIMEOUT=3)(RETRY_COUNT=3)
     (ADDRESS_LIST=
       (LOAD_BALANCE=on)
       (ADDRESS=(PROTOCOL=TCP)(HOST=jiradb0p_mil-cn.edc.nam.gm.com)(PORT=1521)))
     (CONNECT_DATA=(SERVICE_NAME=jiradb0p_srv.edc.nam.gm.com)))
  )

 

Additional details:

Please sign in to leave a comment.

Comments

1 comment

Date Votes
  • Edwin Fivetranner

    Hi Chakrapani,

    Thanks for sharing the example.

    If I understand correctly, you’d like HVR Oracle to support Oracle connection configurations with multiple DNS/host entries, such as DESCRIPTION_LIST, so that role-based failover and multi-site connectivity can be configured.

    We’ll discuss this with our engineering team and evaluate whether this can be supported more effectively. I’ll get back to you if I have more information.

    Best regards,
    Edwin