PHEXPP - Maintaining connectivity during server maintenance

PHEXPP is currently configured for failover on new connections from PHEXPP1 to PHEXPP2. However, existing connections may experience a loss of connectivity if the server they are connected to becomes unavailable. To avoid service interruptions during planned PHEXPP1 maintenance, applications should be temporarily configured to connect to PHEXPP2 first, with PHEXPP1 as the second entry, and then changed back once maintenance is complete. The following describes the connection settings which can be used to connect to PHEXPP2 first.

Connection information for PHEXPP2:
PHEXPP =
  (DESCRIPTION =
    (FAILOVER=on)
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = phexpp2.db.doit.wisc.edu)(PORT = 1596))
      (ADDRESS = (PROTOCOL = TCP)(HOST = phexpp1.db.doit.wisc.edu)(PORT = 1596))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = phexpp.doit.wisc.edu)
    )

Once server maintenance on PHEXPP1 is complete, your application's configuration should be reverted back to the normal settings.

Default connection settings:
PHEXPP =
  (DESCRIPTION =
    (FAILOVER=on)
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = phexpp1.db.doit.wisc.edu)(PORT = 1596))
      (ADDRESS = (PROTOCOL = TCP)(HOST = phexpp2.db.doit.wisc.edu)(PORT = 1596))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = phexpp.doit.wisc.edu)
    )

Please contact mst-servicedelivery@lists.wisc.edu with any questions or concerns.

See Also:




Keywords:PHEXPP PHEXPP1 PHEXPP2 PHEXPORT   Doc ID:60684
Owner:Jordan D.Group:Middleware
Created:2016-02-11 11:45 CDTUpdated:2016-05-23 10:11 CDT
Sites:Middleware
Feedback:  0   0