Shareplex Setup/Configuration for Oracle Replication

Introduction

Steps to configure Shareplex for Oracle Replication.

Posted by Hemanth Sathavalli

Prerequisites for Shareplex Setup on Oracle database :

1. Create tablespace splex with 2GB space with autoextend-on in both source & Target    databases.
2. Ensure Archive log is enabled in Source and target databases.
3.   Enable supplemental Logging at Database Level in the Source database :

<  ALTER DATABASE ADD SUPPLEMENTAL LOG DATA > – This enables Minimal Database Level Logging

Note : Supplemental logging places additional column data into the redo log file whenever an UPDATE operation is performed. At the least, minimal database-level supplemental logging must be enabled for any Change Data Capture in the source database.

Source Setup :

1. Change Directory to <shareplex proddir>/bin

cd /u03/db/shareplex__01/proddir

2. Ensure to set source database env
3. Run ./ora_setup

1. When prompted asking ,Will the SharePlex install be using a BEQUEATH connection?, Enter n
2. When prompted asking , Are you configuring SharePlex for an AWS RDS Database?, Enter n
3.  When Prompted to enter Enter the TNS alias for which SharePlex should be installed , Enter the Tns name entry of source database
4. When prompted to enter DBA user for source database , enter system user
5. When prompted to enter password for DBA Account , Enter system user password
6. When prompted asking , Would you like to create a new SharePlex user ? , Ensure it is Y and press enter
7.  When prompted to enter username for new shareplex user , enter splex/<shareplex password>
8.  When prompted asking Do you want to enable replication of tables with TDE?, ensure n and press enter
9. When prompted to enter the default tablespace, enter splex
10. When prompted to enter the temporary tablespace , enter temp
11. When prompted to enter the index tablespace , enter splex
12.  When prompted asking Will the current setup for sid: [<source SID>] be used as source (including cases as source for failover or master-master setups)? , Ensure it is Y and press enter
13.  When prompted asking, Do you wish to connect to ASM using BEQUEATH connection?  , Ensure it is Y and press enter

n  . When prompted to enter the asm SID , ensure asm sid is correct, else enter the correct sid

Source Setup stage completed. 

Target Setup :

1. Change Directory to <shareplex proddrr>/bin

cd  /u03/db/shareplex__01/proddir

2. Ensure to source the target database .env
3. Run ./ora_setup

1. When prompted asking ,Will the SharePlex install be using a BEQUEATH connection?, Enter n
2. When prompted asking , Are you configuring SharePlex for an AWS RDS Database?, Enter n
3. When Prompted to enter Enter the TNS alias for which SharePlex should be installed , Enter the Tns name entry of target database
4. When prompted to enter DBA user for source database , enter system user
5. When prompted to enter password for DBA Account , Enter system user password
6. When prompted asking , Would you like to create a new SharePlex user ? , Ensure it is Y and press enter
7. When prompted to enter username for new shareplex user , enter splex/<shareplex password>
8. When prompted asking Do you want to enable replication of tables with TDE?, ensure n and press enter
9. When prompted to enter the default tablespace, enter splex
10. When prompted to enter the temporary tablespace , enter SPLEX_TEMP
11. When prompted to enter the index tablespace , enter splex
12. When prompted asking Will the current setup for sid: [<target SID>] be used as source (including cases as source for failover or master-master setups)? , enter n and Hit enter

Target Setup stage completed

4. Disable the Check & Referential Constraints in the Target Database.
5. Disable the Triggers in the Target Database

Shareplex Startup and shutdown :

Steps to start the shareplex service 

1. Start screen session
2. Change Directory to <shareplex proddrr>/bin

cd /u03/db/shareplex/proddir

3. Ensure to set source database env or target database env
4. Run ./sp_cop -u2100 &

Steps to stop the shareplex service

1. Start screen session
2. Change Directory to <shareplex proddrr>/bin

cd /u03/db/shareplex/proddir

3. Ensure to set source database env or target database env
4. Run ./sp_ctrl
5. Enter shutdown command in sp_ctrl prompt : sp_ctrl > shutdown