{"id":8335,"date":"2016-06-16T15:14:50","date_gmt":"2016-06-16T13:14:50","guid":{"rendered":"https:\/\/www.dbi-services.com\/blog\/discovering-shareplex-for-oracle\/"},"modified":"2023-06-08T15:10:26","modified_gmt":"2023-06-08T13:10:26","slug":"discovering-shareplex-for-oracle","status":"publish","type":"post","link":"https:\/\/www.dbi-services.com\/blog\/discovering-shareplex-for-oracle\/","title":{"rendered":"Discovering SharePlex for Oracle"},"content":{"rendered":"

By Mouhamadou Diaw<\/strong><\/p>\n

Nowadays, replicating data is very important. Many tools exist in the market (Goldengate, Dbvisit \u2026).\u00a0In this article we talk about a Dell Product tool that can be used for data replication: SharePlex<\/span>.\u00a0The goal is to show how it is easy to setup a SharePlex environment for replicating data.
\nAfter installing the software we will replicate scott schema to a target database into a new schema named scott_str1<\/p>\n

\"stream1\"<\/a><\/p>\n

We present below\u00a0the environment we use<\/p>\n\n\n\n\n\n
Server<\/td>\nDatabase<\/td>\nOracle Version<\/td>\n<\/td>\n<\/tr>\n
atlas<\/td>\nSPLEXDB<\/td>\n12.1.0.2<\/td>\nSource<\/td>\n<\/tr>\n
atlasrep<\/td>\nSPLEXSTR1<\/td>\n11.2.0.4<\/td>\nTarget<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

1- Installation on both source and target<\/b><\/h4>\n

The first step is to install the SharePlex software, the downlod page is\u00a0\u00a0https:\/\/www.quest.com\/products\/shareplex\/<\/a>.
\nFor the intallation we need two directories on both source and target servers:<\/p>\n

Product directory<\/b><\/span>: stores programs and libraries
\nVariable-data directory<\/b><\/span>: stores queues, log files and other components files<\/p>\n

Note: For some steps we will only show outputs for the source <\/i><\/p>\n

\n
\n\n\n\n
\n
1<\/div>\n
2<\/div>\n<\/td>\n
\n
\n
[oracle@atlas app]$ <\/code>mkdir<\/code> -p <\/code>\/u01\/app\/shareplex\/splex_864_12_bin<\/code><\/div>\n
[oracle@atlas app]$ <\/code>mkdir<\/code> -p <\/code>\/u01\/app\/shareplex\/splex_864_12_var<\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n

Now\u00a0Let’s unzip the downloded file and after execute the .tpm <\/span> resulting file on both source and target<\/p>\n

\n
\n\n\n\n
\n
1<\/div>\n
2<\/div>\n
3<\/div>\n
4<\/div>\n
5<\/div>\n
6<\/div>\n
7<\/div>\n
8<\/div>\n
9<\/div>\n
10<\/div>\n
11<\/div>\n
12<\/div>\n
13<\/div>\n
14<\/div>\n
15<\/div>\n
16<\/div>\n
17<\/div>\n
18<\/div>\n
19<\/div>\n
20<\/div>\n
21<\/div>\n
22<\/div>\n
23<\/div>\n
24<\/div>\n
25<\/div>\n
26<\/div>\n
27<\/div>\n
28<\/div>\n
29<\/div>\n
30<\/div>\n
31<\/div>\n
32<\/div>\n
33<\/div>\n
34<\/div>\n
35<\/div>\n
36<\/div>\n
37<\/div>\n
38<\/div>\n
39<\/div>\n
40<\/div>\n
41<\/div>\n
42<\/div>\n
43<\/div>\n
44<\/div>\n
45<\/div>\n
46<\/div>\n
47<\/div>\n
48<\/div>\n
49<\/div>\n
50<\/div>\n
51<\/div>\n<\/td>\n
\n
\n
[oracle@atlas shareplex]$ <\/code>tar<\/code> xvf shareplex-8.6.4-b66-oracle120-rh-40-amd64-m64.<\/code>tar<\/code><\/div>\n
SharePlex-8.6.4-b66-oracle120-rh-40-amd64-m64.tpm<\/code><\/div>\n
[oracle@atlas shareplex]$ .<\/code>\/SharePlex-8<\/code>.6.4-b66-oracle120-rh-40-amd64-m64.tpm<\/code><\/div>\n
Unpacking ..................................................................<\/code><\/div>\n
\u00a0\u00a0<\/code>............................<\/code><\/div>\n
SharePlex installation program:<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0<\/code>SharePlex Version: 8.6.4<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0<\/code>Build platform: rh-40-amd64<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0<\/code>Target platform: lin-amd64<\/code><\/div>\n
<\/div>\n
Please enter the product directory location?<\/code>\/u01\/app\/shareplex\/splex_864_12_bin<\/code><\/div>\n
Please enter the variable data directory location?<\/code>\/u01\/app\/shareplex\/splex_864_12_var<\/code><\/div>\n
Please specify the SharePlex Admin group (<\/code>select<\/code> a number):<\/code><\/div>\n
1. [oinstall]<\/code><\/div>\n
2. osdba<\/code><\/div>\n
3. osasm<\/code><\/div>\n
4. dba<\/code><\/div>\n
5. osoper<\/code><\/div>\n
6. vboxsf<\/code><\/div>\n
7. oracle<\/code><\/div>\n
?\u00a0 1<\/code><\/div>\n
Please wait <\/code>while<\/code> the installer obtains Oracle information ..<\/code><\/div>\n
Please enter the ORACLE_SID that corresponds to this installation? [SPLEXDB]<\/code><\/div>\n
Please enter the ORACLE_HOME directory that corresponds to this ORACLE_SID? [<\/code>\/u01\/app\/oracle\/product\/12<\/code>.1.0.2<\/code>\/dbhome_1<\/code>]<\/code><\/div>\n
Please enter the TCP<\/code>\/IP<\/code> port number <\/code>for<\/code> SharePlex communications? [2100]<\/code><\/div>\n
<\/div>\n
Preparing to <\/code>install<\/code> SharePlex <\/code>for<\/code> Oracle <\/code>v<\/code>.8.6.4:<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0<\/code>User:\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 oracle<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0<\/code>Admin Group:\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 oinstall<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0<\/code>Product Directory:\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/code>\/u01\/app\/shareplex\/splex_864_12_bin<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0<\/code>Variable Data Directory:\u00a0 <\/code>\/u01\/app\/shareplex\/splex_864_12_var<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0<\/code>ORACLE_SID:\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 SPLEXDB<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0<\/code>ORACLE_HOME:\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/code>\/u01\/app\/oracle\/product\/12<\/code>.1.0.2<\/code>\/dbhome_1<\/code><\/div>\n
<\/div>\n
Proceed with installation? [<\/code>yes<\/code>]<\/code><\/div>\n
Please enter the License key? ENGMFYD3X0P2SV88Y6PLHF0DVJXJAB5SY4<\/code><\/div>\n
Please enter the customer name associated with this license key? DBI<\/code><\/div>\n
<\/div>\n
SharePlex <\/code>v<\/code>. 8.6.4 license validation successful:<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0<\/code>Customer Name:\u00a0\u00a0\u00a0\u00a0\u00a0 XXXXX<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0<\/code>License Key:\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 XXXXXXXXXXXXXXXXXXXXXXXXX<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0<\/code>Product Name:\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 SharePlex <\/code>for<\/code> Oracle - RAC<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0<\/code>License Key Type:\u00a0\u00a0 <\/code>\"Trial Key\"<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0<\/code>Expires:\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 at Midnight of Jul 04, 2016<\/code><\/div>\n
<\/div>\n
NOTE: You can upgrade this license key or add license keys <\/code>for<\/code> additional machines<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code>by executing utility <\/code>\/u01\/app\/shareplex\/splex_864_12_bin\/install\/splex_add_key<\/code>.<\/code><\/div>\n
<\/div>\n
Installation log saved to: <\/code>\/home\/oracle\/<\/code>.shareplex<\/code>\/INSTALL-SharePlex-8<\/code>.6.4-1606091325.log<\/code><\/div>\n
SharePlex <\/code>for<\/code> Oracle <\/code>v<\/code>.8.6.4 installation successful.<\/code><\/div>\n
[oracle@atlas shareplex]$<\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n

Wow SharePlex installation is finished.<\/p>\n

\u00a02- Database preparation<\/b><\/h4>\n

The initial load on the target must me done. Datapump may help for this. Just export data from the source and import it on the target.<\/p>\n

Minimal supplemental logging must be set before you activate the SharePlex replication configuration.\u00a0In addition, SharePlex recommends that both primary key and unique key supplemental logging be set.\u00a0In this article we will only activate minimal supplemental logging.<\/p>\n

\n
\n\n\n\n
\n
1<\/div>\n
2<\/div>\n
3<\/div>\n
4<\/div>\n
5<\/div>\n
6<\/div>\n
7<\/div>\n
8<\/div>\n
9<\/div>\n
10<\/div>\n
11<\/div>\n
12<\/div>\n
13<\/div>\n
14<\/div>\n
15<\/div>\n<\/td>\n
\n
\n
SQL> <\/code>select<\/code> name,supplemental_log_data_min from <\/code>v<\/code>$database;<\/code><\/div>\n
<\/div>\n
NAME\u00a0\u00a0\u00a0\u00a0\u00a0 SUPPLEME<\/code><\/div>\n
--------- --------<\/code><\/div>\n
SPLEXDB\u00a0\u00a0 NO<\/code><\/div>\n
<\/div>\n
SQL> ALTER DATABASE ADD SUPPLEMENTAL LOG DATA;<\/code><\/div>\n
<\/div>\n
Database altered.<\/code><\/div>\n
<\/div>\n
SQL> <\/code>select<\/code> name,supplemental_log_data_min from <\/code>v<\/code>$database;<\/code><\/div>\n
<\/div>\n
NAME\u00a0\u00a0\u00a0\u00a0\u00a0 SUPPLEME<\/code><\/div>\n
--------- --------<\/code><\/div>\n
SPLEXDB\u00a0\u00a0 YES<\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n

SharePlex will create a user \u00a0in the database so it is recommended to create dedicated tablespaces for this user<\/p>\n

3- \u00a0Define a new variable-data directory on both source and target<\/b><\/h4>\n

When configuring a replication configuration, it is recommended to use different variable-data directory other than the one mentioned during the installation<\/span>. The main reason is that by doing that we will have one working directory for each replication. What we need is just to create a new directory and to copy the contents of the default variable-data directory in the new one. Remark the naming for the new var directory \u00a0(dbname_shareplexverion_oracleversion_port). Of course feel free for your naming.\u00a0But it is useful to adopt a naming that can help for identifying the replication as we can have many configurations in the same server<\/p>\n

\n
\n\n\n\n
\n
1<\/div>\n
2<\/div>\n
3<\/div>\n<\/td>\n
\n
\n
[oracle@atlas splex_864_12_var]$ <\/code>pwd<\/code><\/div>\n
\/u01\/app\/shareplex\/splex_864_12_var<\/code><\/div>\n
[oracle@atlas splex_864_12_var]$ <\/code>cp<\/code> -R * <\/code>\/u01\/app\/shareplex\/vardir\/splexdb_864_12_2103<\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n

4- Configure SharePlex on both source and target<\/b><\/h4>\n

To configure SharePlex we have to run the ora_setup file. Before launching the ora_setup file, we \u00a0set some variables. Just note that we can use a different port than the one we specified in the installation process The only requirement is that ports should have same value on both source and target <\/span><\/p>\n

\n
\n\n\n\n
\n
1<\/div>\n
2<\/div>\n
3<\/div>\n
4<\/div>\n
5<\/div>\n
6<\/div>\n
7<\/div>\n<\/td>\n
\n
\n
[oracle@atlas bin]$ <\/code>env<\/code> | <\/code>grep<\/code>\u00a0 SP_<\/code><\/div>\n
SP_SYS_HOST_NAME=atlas.localdomain<\/code><\/div>\n
SP_COP_UPORT=2103<\/code><\/div>\n
SP_COP_TPORT=2103<\/code><\/div>\n
SP_SYS_VARDIR=<\/code>\/u01\/app\/shareplex\/vardir\/splexdb_864_12_2103<\/code><\/div>\n
SP_HOME=<\/code>\/u01\/app\/shareplex\/splex_864_12_bin\/<\/code><\/div>\n
[oracle@atlas bin]$<\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n
\n
\n\n\n\n
\n
1<\/div>\n
2<\/div>\n
3<\/div>\n
4<\/div>\n
5<\/div>\n
6<\/div>\n
7<\/div>\n
8<\/div>\n
9<\/div>\n
10<\/div>\n
11<\/div>\n
12<\/div>\n
13<\/div>\n
14<\/div>\n
15<\/div>\n
16<\/div>\n
17<\/div>\n
18<\/div>\n
19<\/div>\n
20<\/div>\n
21<\/div>\n
22<\/div>\n
23<\/div>\n
24<\/div>\n
25<\/div>\n
26<\/div>\n
27<\/div>\n
28<\/div>\n
29<\/div>\n
30<\/div>\n
31<\/div>\n
32<\/div>\n
33<\/div>\n
34<\/div>\n
35<\/div>\n
36<\/div>\n
37<\/div>\n
38<\/div>\n
39<\/div>\n
40<\/div>\n
41<\/div>\n
42<\/div>\n
43<\/div>\n
44<\/div>\n
45<\/div>\n
46<\/div>\n
47<\/div>\n
48<\/div>\n
49<\/div>\n
50<\/div>\n
51<\/div>\n
52<\/div>\n
53<\/div>\n
54<\/div>\n
55<\/div>\n
56<\/div>\n
57<\/div>\n
58<\/div>\n
59<\/div>\n
60<\/div>\n
61<\/div>\n
62<\/div>\n
63<\/div>\n
64<\/div>\n
65<\/div>\n
66<\/div>\n
67<\/div>\n
68<\/div>\n
69<\/div>\n
70<\/div>\n
71<\/div>\n
72<\/div>\n
73<\/div>\n
74<\/div>\n
75<\/div>\n<\/td>\n
\n
\n
[oracle@atlas ~]$ <\/code>cd<\/code> $SP_HOME<\/code><\/div>\n
[oracle@atlas splex_864_12_bin]$ <\/code>pwd<\/code><\/div>\n
\/u01\/app\/shareplex\/splex_864_12_bin<\/code><\/div>\n
[oracle@atlas splex_864_12_bin]$<\/code><\/div>\n
<\/div>\n
<\/div>\n
[oracle@atlas bin]$ .<\/code>\/ora_setup<\/code><\/div>\n
<\/div>\n
Welcome to the Oracle SharePlex setup process <\/code>for<\/code> port 2103.<\/code><\/div>\n
This process creates tables and user accounts needed to run<\/code><\/div>\n
Oracle SharePlex replication.<\/code><\/div>\n
....<\/code><\/div>\n
....<\/code><\/div>\n
Enter the Oracle SID <\/code>for<\/code> which<\/code> SharePlex should be installed [SPLEXDB] :<\/code><\/div>\n
<\/div>\n
In order to create the SharePlex tables and user account, we must<\/code><\/div>\n
connect to the database as a DBA user<\/code><\/div>\n
<\/div>\n
Enter a DBA user <\/code>for<\/code> SPLEXDB\u00a0 : system<\/code><\/div>\n
<\/div>\n
Enter password <\/code>for<\/code> the DBA account, <\/code>which<\/code> will not <\/code>echo<\/code> :<\/code><\/div>\n
<\/div>\n
connecting--This may take a few seconds.<\/code><\/div>\n
<\/div>\n
validating user name and password. . . This may take a few seconds.<\/code><\/div>\n
SharePlex objects will need to be created under a special<\/code><\/div>\n
account.\u00a0 You can pick an existing user or create a new one.<\/code><\/div>\n
Would you like to create a new SharePlex user ? [y] :<\/code><\/div>\n
Enter username <\/code>for<\/code> new user [splex<\/code>\/splex<\/code>] : splex_864_12_2103<\/code><\/div>\n
<\/div>\n
Enter password <\/code>for<\/code> new user :<\/code><\/div>\n
<\/div>\n
Re-enter password <\/code>for<\/code> new user :<\/code><\/div>\n
<\/div>\n
Warning:\u00a0 This user is now being granted unlimited tablespace.<\/code><\/div>\n
This privilege will remain <\/code>in<\/code> effect <\/code>until<\/code> it is explicitly changed.<\/code><\/div>\n
Granting <\/code>select<\/code> on sys.user$ to splex_864_12_2103<\/code><\/div>\n
<\/div>\n
Do you want to <\/code>enable<\/code> replication of tables with TDE? [n] :<\/code><\/div>\n
<\/div>\n
To <\/code>enable<\/code> replication of tables with TDE <\/code>in<\/code> the future, please rerun ora_setup.<\/code><\/div>\n
<\/div>\n
Setup will now <\/code>install<\/code> SharePlex objects.<\/code><\/div>\n
<\/div>\n
These are the existing tablespaces.<\/code><\/div>\n
<\/div>\n
SYSTEM SYSAUX UNDOTBS1 TEMP USERS EXAMPLE SHAREPLEX_DATA SHAREPLEX_INDX<\/code><\/div>\n
SHAREPLEX_TEMP<\/code><\/div>\n
<\/div>\n
Enter the default tablespace <\/code>for<\/code> use by SharePlex [USERS] : SHAREPLEX_DATA<\/code><\/div>\n
<\/div>\n
Enter the temporary tablespace <\/code>for<\/code> use by SharePlex [TEMP] : SHAREPLEX_TEMP<\/code><\/div>\n
Enter the index tablespace <\/code>for<\/code> use by SharePlex [ ] : SHAREPLEX_INDX<\/code><\/div>\n
<\/div>\n
Creating SharePlex objects [Installation <\/code>type<\/code>: Fresh]. . .<\/code><\/div>\n
<\/div>\n
Creating SharePlex Oracle-timezone-region map . . . Done.<\/code><\/div>\n
<\/div>\n
Creating Conflict Resolution Package . . . Done.<\/code><\/div>\n
<\/div>\n
Creating SharePlex Dataequator package . . .<\/code><\/div>\n
<\/div>\n
Loading Compare Package from <\/code>\"\/u01\/app\/shareplex\/splex_864_12_bin\/util\/sp_deq_pkg.plb\"<\/code>...Done.<\/code><\/div>\n
<\/div>\n
Loading Compare Varray Package from <\/code>\"\/u01\/app\/shareplex\/splex_864_12_bin\/util\/sp_deq_v_pkg.plb\"<\/code>...Done.<\/code><\/div>\n
<\/div>\n
Will the current setup <\/code>for<\/code> sid: [SPLEXDB] be used as <\/code>source<\/code> (including cases as <\/code>source<\/code> for<\/code> failover or master-master setups)?\u00a0 [y] :<\/code><\/div>\n
<\/div>\n
Setup of SharePlex objects successful . . .<\/code><\/div>\n
<\/div>\n
Changing SharePlex connection database . . .<\/code><\/div>\n
<\/div>\n
Setup completed successfully<\/code><\/div>\n
<\/div>\n
[oracle@atlas bin]$<\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n

Run also ora_setup on the target. We only show variables on target<\/p>\n

\n
\n\n\n\n
\n
1<\/div>\n
2<\/div>\n
3<\/div>\n
4<\/div>\n
5<\/div>\n
6<\/div>\n<\/td>\n
\n
\n
[oracle@atlasrep ~]$ <\/code>env<\/code> | <\/code>grep<\/code> SP_<\/code><\/div>\n
SP_SYS_HOST_NAME=atlasrep.localdomain<\/code><\/div>\n
SP_COP_UPORT=2103<\/code><\/div>\n
SP_COP_TPORT=2103<\/code><\/div>\n
SP_SYS_VARDIR=<\/code>\/u01\/app\/shareplex\/vardir\/splexstr1_864_11_2103<\/code><\/div>\n
SP_HOME=<\/code>\/u01\/app\/shareplex\/splex_864_11_bin\/<\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n

5- Starting SharePlex processes on both source and target<\/b><\/h4>\n

Now we are ready to start SharePlex processes. The $SP_HOME\/bin\/sp_cop executable is used. Just remark the option \u2013u followed by a naming variable. Not mandatory but can help for alerting setup or for locating our processes.<\/p>\n

Starting on the source\u00a0side<\/p>\n

\n
\n\n\n\n
\n
1<\/div>\n
2<\/div>\n
3<\/div>\n
4<\/div>\n
5<\/div>\n
6<\/div>\n
7<\/div>\n
8<\/div>\n
9<\/div>\n
10<\/div>\n
11<\/div>\n
12<\/div>\n
13<\/div>\n
14<\/div>\n
15<\/div>\n<\/td>\n
\n
\n
[oracle@atlas ~]$ <\/code>echo<\/code> $NAME_FOR_ALERTING<\/code><\/div>\n
ATLAS_SPLEXDB_TO_ATLASREP_2103<\/code><\/div>\n
[oracle@atlas ~]$\u00a0 $SP_HOME<\/code>\/bin\/sp_cop<\/code> -u $NAME_FOR_ALERTING &<\/code><\/div>\n
[1] 22174<\/code><\/div>\n
[oracle@atlas ~]$<\/code><\/div>\n
<\/div>\n
*******************************************************<\/code><\/div>\n
* SharePlex <\/code>for<\/code> Oracle Startup<\/code><\/div>\n
* Copyright 2016 Dell, Inc.<\/code><\/div>\n
* ALL RIGHTS RESERVED.<\/code><\/div>\n
* Protected by U.S. Patents: 7,461,103 and 7,065,538<\/code><\/div>\n
* Version: 8.6.4.66-m64-oracle120<\/code><\/div>\n
* VarDir : <\/code>\/u01\/app\/shareplex\/vardir\/splexdb_864_12_2103<\/code><\/div>\n
* Port\u00a0\u00a0 : 2103<\/code><\/div>\n
*******************************************************<\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n
\n
\n\n\n\n
\n
1<\/div>\n
2<\/div>\n
3<\/div>\n<\/td>\n
\n
\n
[oracle@atlas ~]$ <\/code>ps<\/code> -ef | <\/code>grep<\/code> sp_cop<\/code><\/div>\n
<\/div>\n
oracle 22174 3983 0 15:37 pts<\/code>\/2<\/code> 00:00:00 <\/code>\/u01\/app\/shareplex\/splex_864_12_bin\/<\/code>.app-modules<\/code>\/sp_cop<\/code> -u ATLAS_SPLEXDB_TO_ATLASREP_2103<\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n

Starting on the target side<\/p>\n

\n
\n\n\n\n
\n
1<\/div>\n
2<\/div>\n
3<\/div>\n
4<\/div>\n
5<\/div>\n
6<\/div>\n
7<\/div>\n
8<\/div>\n
9<\/div>\n
10<\/div>\n
11<\/div>\n
12<\/div>\n
13<\/div>\n
14<\/div>\n
15<\/div>\n<\/td>\n
\n
\n
[oracle@atlasrep ~]$ <\/code>echo<\/code> $NAME_FOR_ALERTING<\/code><\/div>\n
FROM_ATLAS_SPLEXDB_2103<\/code><\/div>\n
[oracle@atlasrep ~]$\u00a0 $SP_HOME<\/code>\/bin\/sp_cop<\/code> -u $NAME_FOR_ALERTING &<\/code><\/div>\n
[1] 14933<\/code><\/div>\n
[oracle@atlasrep ~]$<\/code><\/div>\n
<\/div>\n
*******************************************************<\/code><\/div>\n
* SharePlex <\/code>for<\/code> Oracle Startup<\/code><\/div>\n
* Copyright 2016 Dell, Inc.<\/code><\/div>\n
* ALL RIGHTS RESERVED.<\/code><\/div>\n
* Protected by U.S. Patents: 7,461,103 and 7,065,538<\/code><\/div>\n
* Version: 8.6.4.66-m64-oracle110<\/code><\/div>\n
* VarDir : <\/code>\/u01\/app\/shareplex\/vardir\/splexstr1_864_11_2103<\/code><\/div>\n
* Port\u00a0\u00a0 : 2103<\/code><\/div>\n
*******************************************************<\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n
\n
\n\n\n\n
\n
1<\/div>\n
2<\/div>\n<\/td>\n
\n
\n
[oracle@atlasrep ~]$ <\/code>ps<\/code> -ef | <\/code>grep<\/code> sp_cop<\/code><\/div>\n
oracle\u00a0\u00a0 14933\u00a0 2439\u00a0 3 15:52 pts<\/code>\/0<\/code>\u00a0\u00a0\u00a0 00:00:00 <\/code>\/u01\/app\/shareplex\/splex_864_11_bin\/<\/code>.app-modules<\/code>\/sp_cop<\/code> -u FROM_ATLAS_SPLEXDB_2103<\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n

6- Configuring Replication<\/b><\/h4>\n

To configure data replication, we need to create a configuration file on the source. There is already a template (ORA_config) \u00a0for the configuration in the $SP_SYS_VARDIR\/config<\/span> directory.<\/p>\n

\n
\n\n\n\n
\n
1<\/div>\n
2<\/div>\n
3<\/div>\n
4<\/div>\n
5<\/div>\n
6<\/div>\n
7<\/div>\n<\/td>\n
\n
\n
[oracle@atlas config]$ <\/code>cat<\/code> ORA_config<\/code><\/div>\n
<\/div>\n
datasource:o.SOURCE_SID<\/code><\/div>\n
<\/div>\n
#source tables\u00a0\u00a0\u00a0\u00a0\u00a0 target tables\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 routing map<\/code><\/div>\n
<\/div>\n
splex.demo_src\u00a0\u00a0\u00a0\u00a0\u00a0 splex.demo_dest\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 target_system@o.target_sid<\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n

We just have to create a configuration file based on this template. Below our config file<\/p>\n

\n
\n\n\n\n
\n
1<\/div>\n
2<\/div>\n
3<\/div>\n
4<\/div>\n
5<\/div>\n
6<\/div>\n
7<\/div>\n<\/td>\n
\n
\n
[oracle@atlas config]$ <\/code>cat<\/code> str1_config_atlasrep.cnf<\/code><\/div>\n
datasource:o.SPLEXDB<\/code><\/div>\n
<\/div>\n
#source tables\u00a0\u00a0\u00a0\u00a0\u00a0 target tables\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 routing map<\/code><\/div>\n
expand<\/code> scott.%\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 scott_str1.%\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 atlasrep.localdomain@o.SPLEXSTR1<\/code><\/div>\n
<\/div>\n
[oracle@atlas config]$<\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n

When using\u00a0wildcarded names in the configuration file, the keyword expand<\/span> is mandatory.\u00a0Without this required keyword, the wildcard characters are assumed to be part of an explicit object name, and no wildcard expansion is performed.
\nOnce the configuration created we verify it and then activate it. Activating the configuration file will start the replication. The sp_ctrl utility is used to manage SharePlex<\/p>\n

\n
\n\n\n\n
\n
1<\/div>\n<\/td>\n
\n
\n
$SP_HOME<\/code>\/bin\/sp_ctrl<\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n

We can display the list of our configuration files<\/p>\n

\n
\n\n\n\n
\n
1<\/div>\n
2<\/div>\n
3<\/div>\n
4<\/div>\n
5<\/div>\n
6<\/div>\n
7<\/div>\n
8<\/div>\n
9<\/div>\n<\/td>\n
\n
\n
sp_ctrl (atlasrep:2103)> list config<\/code><\/div>\n
<\/div>\n
File\u00a0\u00a0 Name\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 State\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Datasource<\/code><\/div>\n
--------------------------------------------------\u00a0 ----------\u00a0 ---------------<\/code><\/div>\n
str_config_atlas.cnf\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Inactive\u00a0\u00a0\u00a0 o.SPLEXSTR1<\/code><\/div>\n
Last Modified At: 13-Jun-16 16:52\u00a0\u00a0\u00a0 Size: 159<\/code><\/div>\n
<\/div>\n
ORA_config\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Inactive\u00a0\u00a0\u00a0 o.SOURCE_SID<\/code><\/div>\n
Last Modified At: 09-Jun-16 13:33\u00a0\u00a0\u00a0 Size: 151<\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n

Let’s verify the configuration file syntax<\/p>\n

\n
\n\n\n\n
\n
1<\/div>\n
2<\/div>\n
3<\/div>\n
4<\/div>\n<\/td>\n
\n
\n
sp_ctrl (atlasrep:2103)> verify config str_config_atlas.cnf<\/code><\/div>\n
<\/div>\n
\u00a0\u00a0<\/code>Config str_config_atlas.cnf is valid<\/code><\/div>\n
\u00a0\u00a0<\/code>View detailed config <\/code>in<\/code> \/u01\/app\/shareplex\/vardir\/splexstr1_864_11_2103\/temp\/str_config_atlas<\/code>.cnf<\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n

The last step is to activate the config file<\/p>\n

\n
\n\n\n\n
\n
1<\/div>\n<\/td>\n
\n
\n
sp_ctrl (atlas:2103)> activate config str1_config_atlasrep.cnf<\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n

We can validate the replication by checking the running processes with the command show.
\nFrom the Source: Capture, Read and Export processes should be running <\/span><\/p>\n

\n
\n\n\n\n
\n
1<\/div>\n
2<\/div>\n
3<\/div>\n
4<\/div>\n
5<\/div>\n
6<\/div>\n
7<\/div>\n<\/td>\n
\n
\n
sp_ctrl (atlas:2103)> show<\/code><\/div>\n
<\/div>\n
Process\u00a0\u00a0\u00a0 Source\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Target\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 State\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 PID<\/code><\/div>\n
---------- ------------------------------------ ---------------------- -------------------- ------<\/code><\/div>\n
Capture\u00a0\u00a0\u00a0 o.SPLEXDB\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Running\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 24650<\/code><\/div>\n
Read\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 o.SPLEXDB\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Running\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 24656<\/code><\/div>\n
Export\u00a0\u00a0\u00a0\u00a0 atlas\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 atlasrep\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Running\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 24671<\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n

From the Target : Import and Post processes should be running<\/span><\/p>\n

\n
\n\n\n\n
\n
1<\/div>\n
2<\/div>\n
3<\/div>\n
4<\/div>\n
5<\/div>\n
6<\/div>\n<\/td>\n
\n
\n
sp_ctrl (atlasrep:2103)> show<\/code><\/div>\n
<\/div>\n
Process\u00a0\u00a0\u00a0 Source\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Target\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 State\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 PID<\/code><\/div>\n
---------- ------------------------------------ ---------------------- -------------------- ------<\/code><\/div>\n
Import\u00a0\u00a0\u00a0\u00a0 atlas\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 atlasrep\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Running\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 16143<\/code><\/div>\n
Post\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 o.SPLEXDB-atlas\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 o.SPLEXSTR1\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Running\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 16144<\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n

Now we can see that if we insert new rows in the source, they are replicated in the target<\/p>\n

\n
\n\n\n\n
\n
1<\/div>\n
2<\/div>\n
3<\/div>\n
4<\/div>\n
5<\/div>\n
6<\/div>\n
7<\/div>\n
8<\/div>\n
9<\/div>\n
10<\/div>\n
11<\/div>\n
12<\/div>\n
13<\/div>\n
14<\/div>\n
15<\/div>\n
16<\/div>\n
17<\/div>\n
18<\/div>\n
19<\/div>\n
20<\/div>\n<\/td>\n
\n
\n
SQL> show parameter instance_name<\/code><\/div>\n
<\/div>\n
NAME\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 TYPE\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 VALUE<\/code><\/div>\n
------------------------------------ ----------- ------------------------------<\/code><\/div>\n
instance_name\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 string\u00a0\u00a0\u00a0\u00a0\u00a0 SPLEXDB<\/code><\/div>\n
SQL> conn scott<\/code>\/tiger<\/code><\/div>\n
Connected.<\/code><\/div>\n
SQL> insert into dept values (60,<\/code>'IT'<\/code>,<\/code>'GENEVA'<\/code>);<\/code><\/div>\n
<\/div>\n
1 row created.<\/code><\/div>\n
<\/div>\n
SQL> insert into dept values (70,<\/code>'SECURITY'<\/code>,<\/code>'DAKAR'<\/code>);<\/code><\/div>\n
<\/div>\n
1 row created.<\/code><\/div>\n
<\/div>\n
SQL> commit;<\/code><\/div>\n
<\/div>\n
Commit complete.<\/code><\/div>\n
<\/div>\n
SQL><\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n
\n
\n\n\n\n
\n
1<\/div>\n
2<\/div>\n
3<\/div>\n
4<\/div>\n
5<\/div>\n
6<\/div>\n
7<\/div>\n
8<\/div>\n
9<\/div>\n
10<\/div>\n
11<\/div>\n
12<\/div>\n
13<\/div>\n
14<\/div>\n
15<\/div>\n
16<\/div>\n
17<\/div>\n
18<\/div>\n
19<\/div>\n<\/td>\n
\n
\n
SQL> show parameter instance_name<\/code><\/div>\n
<\/div>\n
NAME\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 TYPE\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 VALUE<\/code><\/div>\n
------------------------------------ ----------- ------------------------------<\/code><\/div>\n
instance_name\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 string\u00a0\u00a0\u00a0\u00a0\u00a0 SPLEXSTR1<\/code><\/div>\n
SQL> conn scott_str1<\/code>\/tiger<\/code><\/div>\n
Connected.<\/code><\/div>\n
SQL> <\/code>select<\/code> * from dept;<\/code><\/div>\n
<\/div>\n
\u00a0\u00a0\u00a0\u00a0<\/code>DEPTNO DNAME\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 LOC<\/code><\/div>\n
---------- -------------- -------------<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code>10 ACCOUNTING\u00a0\u00a0\u00a0\u00a0 NEW YORK<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code>20 RESEARCH\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 DALLAS<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code>30 SALES\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 CHICAGO<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code>40 OPERATIONS\u00a0\u00a0\u00a0\u00a0 BOSTON<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code>60 IT\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 GENEVA<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code>70 SECURITY\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 DAKAR<\/code><\/div>\n
<\/div>\n
6 rows selected.<\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n

Conclusion :<\/p>\n

In this article we shown how easy it is to setup data replication with SharePlex.<\/p>\n

Ref: Dell Official documentation<\/p>\n","protected":false},"excerpt":{"rendered":"

By Mouhamadou Diaw Nowadays, replicating data is very important. Many tools exist in the market (Goldengate, Dbvisit \u2026).\u00a0In this article we talk about a Dell Product tool that can be used for data replication: SharePlex.\u00a0The goal is to show how it is easy to setup a SharePlex environment for replicating data. After installing the software […]<\/p>\n","protected":false},"author":27,"featured_media":8337,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[229],"tags":[],"type_dbi":[],"class_list":["post-8335","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-database-administration-monitoring"],"acf":[],"yoast_head":"\nDiscovering SharePlex for Oracle - dbi Blog<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.dbi-services.com\/blog\/discovering-shareplex-for-oracle\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Discovering SharePlex for Oracle\" \/>\n<meta property=\"og:description\" content=\"By Mouhamadou Diaw Nowadays, replicating data is very important. Many tools exist in the market (Goldengate, Dbvisit \u2026).\u00a0In this article we talk about a Dell Product tool that can be used for data replication: SharePlex.\u00a0The goal is to show how it is easy to setup a SharePlex environment for replicating data. After installing the software […]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dbi-services.com\/blog\/discovering-shareplex-for-oracle\/\" \/>\n<meta property=\"og:site_name\" content=\"dbi Blog\" \/>\n<meta property=\"article:published_time\" content=\"2016-06-16T13:14:50+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-06-08T13:10:26+00:00\" \/>\n<meta property=\"og:image\" content=\"http:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/stream11-1.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"490\" \/>\n\t<meta property=\"og:image:height\" content=\"191\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Oracle Team\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Oracle Team\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"9 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/discovering-shareplex-for-oracle\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/discovering-shareplex-for-oracle\/\"},\"author\":{\"name\":\"Oracle Team\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee\"},\"headline\":\"Discovering SharePlex for Oracle\",\"datePublished\":\"2016-06-16T13:14:50+00:00\",\"dateModified\":\"2023-06-08T13:10:26+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/discovering-shareplex-for-oracle\/\"},\"wordCount\":734,\"commentCount\":0,\"image\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/discovering-shareplex-for-oracle\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/stream11-1.jpg\",\"articleSection\":[\"Database Administration & Monitoring\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/discovering-shareplex-for-oracle\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/discovering-shareplex-for-oracle\/\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/discovering-shareplex-for-oracle\/\",\"name\":\"Discovering SharePlex for Oracle - dbi Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/discovering-shareplex-for-oracle\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/discovering-shareplex-for-oracle\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/stream11-1.jpg\",\"datePublished\":\"2016-06-16T13:14:50+00:00\",\"dateModified\":\"2023-06-08T13:10:26+00:00\",\"author\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/discovering-shareplex-for-oracle\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/discovering-shareplex-for-oracle\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/discovering-shareplex-for-oracle\/#primaryimage\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/stream11-1.jpg\",\"contentUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/stream11-1.jpg\",\"width\":490,\"height\":191},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/discovering-shareplex-for-oracle\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\/\/www.dbi-services.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Discovering SharePlex for Oracle\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#website\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/\",\"name\":\"dbi Blog\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.dbi-services.com\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee\",\"name\":\"Oracle Team\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/secure.gravatar.com\/avatar\/f711f7cd2c9b09bf2627133755b569fb5be0694810cfd33033bdd095fedba86d?s=96&d=mm&r=g\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/f711f7cd2c9b09bf2627133755b569fb5be0694810cfd33033bdd095fedba86d?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/f711f7cd2c9b09bf2627133755b569fb5be0694810cfd33033bdd095fedba86d?s=96&d=mm&r=g\",\"caption\":\"Oracle Team\"},\"url\":\"https:\/\/www.dbi-services.com\/blog\/author\/oracle-team\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Discovering SharePlex for Oracle - dbi Blog","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.dbi-services.com\/blog\/discovering-shareplex-for-oracle\/","og_locale":"en_US","og_type":"article","og_title":"Discovering SharePlex for Oracle","og_description":"By Mouhamadou Diaw Nowadays, replicating data is very important. Many tools exist in the market (Goldengate, Dbvisit \u2026).\u00a0In this article we talk about a Dell Product tool that can be used for data replication: SharePlex.\u00a0The goal is to show how it is easy to setup a SharePlex environment for replicating data. After installing the software […]","og_url":"https:\/\/www.dbi-services.com\/blog\/discovering-shareplex-for-oracle\/","og_site_name":"dbi Blog","article_published_time":"2016-06-16T13:14:50+00:00","article_modified_time":"2023-06-08T13:10:26+00:00","og_image":[{"width":490,"height":191,"url":"http:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/stream11-1.jpg","type":"image\/jpeg"}],"author":"Oracle Team","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Oracle Team","Est. reading time":"9 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.dbi-services.com\/blog\/discovering-shareplex-for-oracle\/#article","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/discovering-shareplex-for-oracle\/"},"author":{"name":"Oracle Team","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee"},"headline":"Discovering SharePlex for Oracle","datePublished":"2016-06-16T13:14:50+00:00","dateModified":"2023-06-08T13:10:26+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/discovering-shareplex-for-oracle\/"},"wordCount":734,"commentCount":0,"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/discovering-shareplex-for-oracle\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/stream11-1.jpg","articleSection":["Database Administration & Monitoring"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.dbi-services.com\/blog\/discovering-shareplex-for-oracle\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dbi-services.com\/blog\/discovering-shareplex-for-oracle\/","url":"https:\/\/www.dbi-services.com\/blog\/discovering-shareplex-for-oracle\/","name":"Discovering SharePlex for Oracle - dbi Blog","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/discovering-shareplex-for-oracle\/#primaryimage"},"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/discovering-shareplex-for-oracle\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/stream11-1.jpg","datePublished":"2016-06-16T13:14:50+00:00","dateModified":"2023-06-08T13:10:26+00:00","author":{"@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee"},"breadcrumb":{"@id":"https:\/\/www.dbi-services.com\/blog\/discovering-shareplex-for-oracle\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dbi-services.com\/blog\/discovering-shareplex-for-oracle\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dbi-services.com\/blog\/discovering-shareplex-for-oracle\/#primaryimage","url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/stream11-1.jpg","contentUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/stream11-1.jpg","width":490,"height":191},{"@type":"BreadcrumbList","@id":"https:\/\/www.dbi-services.com\/blog\/discovering-shareplex-for-oracle\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/www.dbi-services.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Discovering SharePlex for Oracle"}]},{"@type":"WebSite","@id":"https:\/\/www.dbi-services.com\/blog\/#website","url":"https:\/\/www.dbi-services.com\/blog\/","name":"dbi Blog","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.dbi-services.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee","name":"Oracle Team","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/f711f7cd2c9b09bf2627133755b569fb5be0694810cfd33033bdd095fedba86d?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/f711f7cd2c9b09bf2627133755b569fb5be0694810cfd33033bdd095fedba86d?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/f711f7cd2c9b09bf2627133755b569fb5be0694810cfd33033bdd095fedba86d?s=96&d=mm&r=g","caption":"Oracle Team"},"url":"https:\/\/www.dbi-services.com\/blog\/author\/oracle-team\/"}]}},"_links":{"self":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/8335","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/users\/27"}],"replies":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/comments?post=8335"}],"version-history":[{"count":1,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/8335\/revisions"}],"predecessor-version":[{"id":25675,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/8335\/revisions\/25675"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media\/8337"}],"wp:attachment":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media?parent=8335"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/categories?post=8335"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/tags?post=8335"},{"taxonomy":"type","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/type_dbi?post=8335"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}