1. Install SharePlex Product Directory (PRODDIR) and Variable Directory (VARDIR) on a shared drive.
2. Set Static Virtual IP (VIP) for SharePlex. VIP needs to be able to resolve to the active node upon failover.
Unix: export SP_SYS_HOST_NAME=VIP
Windows: set SP_SYS_HOST_NAME= VIP in registry under
\HKEY_LOCAL_MACHINE\SOFTWARE\Quest Software\Shareplex\
3. Add license key for each RAC node which SharePlex expected to failover to.
4. Create the same tns_alias name for SharePlex to connect to db on each node. Load balance should be off and Failover should be on.
Eg.
SPLEX =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = RAC1)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = RAC2)(PORT = 1521))
)
(LOAD_BALANCE = OFF)
(FAILOVER = ON)
(CONNECT_DATA =
(SERVICE_NAME = ORCL)
))
5. Add tns_alias to oratab file on each RAC node that SharePlex expected to failover to.
6. Run ora_setup with the above tns_alias.
Pre 8.6:
system/password@tnsalias
splex/password@tnsalias
8.6 and up: @tnsalias is no longer required when entering password.
7. Use this tns alias in datasource:o.SID for config file.
Eg: datasource:o.tnsalias
8. Create a startup script for SharePlex.
9. Create cluster script for SharePlex to handle failover.