Shareplex for Oracle - Host down or unknown - use SP_SYS_HOST_NAME (4246527)

Shareplex for Oracle - Host down or unknown - use SP_SYS_HOST_NAME

Shareplex for Oracle all versions: The export process cannot connect to the target host - Error in event_log "Host down or unknown"

Shareplex uses "hostname" to resolve to the ipaddress of the primary network card of the source system. It then uses "nslookup" to resolve the host to ipaddress, and ipaddress to host.

It will use the "primary" network card to communicate to the target system unless the SP_SYS_HOST_NAME is set to tell shareplex to communicate through a "secondary" card.

In order to use SP_SYS_HOST_NAME, you must set this parameter prior to starting sp_cop. This can be accomplished by exporting the variable, or by setting the variable in sp_ctrl> then stopping and starting sp_cop again.

Example: The primary network card is pebbles and the ipaddress is 192.1.2.3 - These values are set in the /etc/host file and/or DNS
server.
You want to communicate using the secondary network card called bambam with an ip of 192.1.2.2.
These values must also have entries in the /etc/host file or on a DNS server.

Prior to starting sp_cop you would export the following...
export SP_SYS_HOST_NAME=bambam
start sp_cop
you will now be communicating using the secondary network card with the hostname of bambam

NOTE:
SP_SYS_HOST_NAME is typically used in a clustering environment when using a floating ipaddress for failover.