SharePlex for Database Replication

1. SSH to the instance and login as 'ec2-user' using the key specified at launch.

2. Add SharePlex License key by executing the following command: /home/ec2-user/shareplex/proddir/install/splex_add_key

3. Updating the database connection entries in TNS and ODBC file

a. For Oracle Database - Configure TNS for source and target databases: cat > $TNS_ADMIN/tnsnames.ora rds = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = ${DB_SOURCE_HOST}) (PORT = 1521)) (CONNECT_DATA = (SERVICE_NAME=${DB_SOURCE_SID}) ) )

rdstarget = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = ${DB_TARGET_HOST}) (PORT = 1521)) (CONNECT_DATA = (SERVICE_NAME=${DB_TARGET_SID})))

${DB_SOURCE_HOST} and ${DB_TARGET_HOST} are the source and target hostnames, and ${DB_SOURCE_SID} and ${DB_TARGET_SID} are the Oracle SIDs for those hosts.

b. Update odbc.ini and confirm the entries in odbcinst.ini odbc.ini --> [DSN] Driver=<DriverName as per odbcinst.ini> Description=PostgreSQL Trace=No Servername=<ServerName/IPAddress> Port=5432 UserName=<Username> Password=<Password> Database=<DatabaseName>

4. Execute the ora_setup command for source and target databases for Oracle Database ora_setup is mostly the same as a normal SQLNet SharePlex installation except for a few questions: Answer "no" to the following question: Will the SharePlex install be using a BEQUEATH connection? (Entering 'n' implies a SQLnet connection) [y] : n Answer "yes" to the RDS question if a source/target is an Amazon RDS database: Are you configuring a AWS RDS Database? (Entering 'n' implies non-RDS database) [n] : y

5. Execute the pg_setup command for source and target database for PostgreSQL Database pg_setup uses odbc.ini details to connect with postgreSQL database and perform the setup. Detailed steps are available in technical documents

More details available here: https://support.quest.com/shareplex/technical-documents