XMLWordPrintable

    Details

    • Type: Task
    • Status: Open
    • Priority: Normal
    • Resolution: Unresolved
    • Affects Version/s: 4.13.2
    • Fix Version/s: None
    • Component/s: Database, High Availability
    • Environment:

      Red Hat Enterprise Linux Server release 7.1
      Linux mtl-artif01d 3.10.0-229.42.2.el7.x86_64 #1 SMP Thu Oct 20 15:00:24 EDT 2016 x86_64 x86_64 x86_64 GNU/Linux

      Description

      The following is current information of our Artifactory DB in /etc/opt/jfrog/artifactory/storage.properties:
      type=oracle
      driver=oracle.jdbc.OracleDriver
      url=jdbc:oracle:thin:@artifs1:1521:artifs4a
      username=artifactory
      password=xxxxx
      where:
      artifp1a: Primary DB name
      artifp1: VIP where primary DB resided

      I would like to add a secondary DB so that when the primary DB failed, the secondary DB will be automatically switched over, therefore I like to make a modification in storage.properties as below. Could you help to verify if this change is correct:
      url=jdbc:oracle:thin:@(DESCRIPTION=
      (CONNECT_TIMEOUT=10)
      (FAILOVER=on)
      (TRANSPORT_CONNECT_TIMEOUT=1)
      (ADDRESS_LIST=
      (LOAD_BALANCE=off)
      (ADDRESS=
      (COMMUNITY=TCPCOM.cn.ca)
      (PROTOCOL=TCP)
      (HOST=ARTIFP1.cn.ca)
      (PORT=1521)
      )
      (ADDRESS=
      (COMMUNITY=TCPCOM.cn.ca)
      (PROTOCOL=TCP)
      (HOST=ARTIFP2.cn.ca)
      (PORT=1521)
      )
      )
      (CONNECT_DATA=
      (SERVICE_NAME=ARTIFP_PRIMARY)
      )
      )

      Additional information: The following is the file listing of tnsname.ora
      ARTIFP.cn.ca=
      (DESCRIPTION=
      (CONNECT_TIMEOUT=10)
      (FAILOVER=on)
      (TRANSPORT_CONNECT_TIMEOUT=1)
      (ADDRESS_LIST=
      (LOAD_BALANCE=off)
      (ADDRESS=
      (COMMUNITY=TCPCOM.cn.ca)
      (PROTOCOL=TCP)
      (HOST=ARTIFP1.cn.ca)
      (PORT=1521)
      )
      (ADDRESS=
      (COMMUNITY=TCPCOM.cn.ca)
      (PROTOCOL=TCP)
      (HOST=ARTIFP2.cn.ca)
      (PORT=1521)
      )
      )
      (CONNECT_DATA=
      (SERVICE_NAME=ARTIFP_PRIMARY)
      )
      )

      Many thanks ahead,/Ha

        Attachments

          Activity

            People

            Assignee:
            Unassigned
            Reporter:
            ha.nguyen Ha Nguyen
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Dates

              Created:
              Updated: