These instructions help you set up SharePlex to replicate to a target cloud database directly from the source server. All of the SharePlex processes will run on this server. In a high-volume transactional environment, this may generate unacceptable overhead on the production system. In that case, you should use an intermediary server.
See also:
Post to PaaS cloud from an intermediary server
Overview of SharePlex setup on cloud databases
All steps are performed on the source server:
Complete the SharePlex pre-installation checklist.
Install SharePlex. See Install SharePlex on Linux/Unix for Oracle Database.
Run ora_setup to establish connection information for the source Oracle database. See Database Setup for Oracle.
Add an entry in the local tnsnames.ora file that points to the target cloud database. This enables you to query the target database from the source server.
Run ora_setup to establish connection information for the target cloud database. Run the utility as the master user that was created when the service was created. This user has the required DBA privileges.
IMPORTANT:
|
Specify the following in the routing map of the SharePlex configuration file:
The name of the source host to specify the target system.
The ORACLE_SID of the target cloud database.
In the following example, source1 is the source system and orcldb1 is the tns_alias of the target cloud database.
datasource:o.orcldbprim | ||
#source tables | target tables | routing map |
splex.demo_src | splex.demo_dest | source1@r.orcldb1 |
For more information, see Configure SharePlex to replicate data in the SharePlex Administration Guide.
All the below steps are performed on the source server:
Complete the SharePlex preinstallation checklist.
Install SharePlex. See:
Run the appropriate database setup utility for the source database. See:
IMPORTANT:
|
Install the appropriate ODBC client of the target cloud database.
Run the appropriate database setup utility for the target cloud database. See Database Setup Utilities.
Specify the following in the routing map of the SharePlex configuration file:
the name of the source server as the target host.
the name of the cloud database as the target database
For more information about how to specify configuration components, see Configure SharePlex to replicate data in the SharePlex Administration Guide.
These instructions help you set up SharePlex to replicate to a target cloud database from an intermediary server that runs the SharePlex Import and Post components.
See also:
Post to PaaS cloud from the source server.
Overview of SharePlex setup on cloud databases.
Complete the SharePlex preinstallation checklist.
On the source server, install SharePlex for the source database. See: Install SharePlex on Linux/Unix for Oracle Database.
On the source server, run ora_setup to establish connection information for the source database. See Database Setup for Oracle.
IMPORTANT:
|
On the intermediary server, install the Oracle binaries. Do not create an Oracle instance.
On the intermediary server, add an entry in the oratab file that points to the local Oracle home, and create a dummy entry for the ORACLE_SID. Make certain to specify N so that the startup scripts do not attempt to start the dummy instance.
orcldb:/u01/app/oracle/product/12.1.0/dbhome_1:N
On the intermediary server, add an entry in the tnsnames.ora file that points to the target cloud database.
On the intermediary server, install SharePlex for the target cloud database. When prompted for the ORACLE_SID, specify the tns_alias that you created for the target cloud database. See: Install SharePlex on Linux/Unix for Oracle Database.
On the intermediary server, run ora_setup to establish connection information for the target cloud database. Run it as the master user that was created when the cloud service was created. This user has the required DBA privileges to establish connection information for the target database.
IMPORTANT:
|
Specify the following in the routing map of the SharePlex configuration file:
the name of the intermediary server as the target host.
the ORACLE_SID of the target cloud database.
In the following example, intermediary1 is the intermediary server and orcldb1 is the tns_alias of the target cloud database.
datasource:o.orcldbprim | ||
#source tables | target tables | routing map |
splex.demo_src | splex.demo_dest | intermediary1@o.orcldb1 |
For more information, see Configure SharePlex to replicate data in the SharePlex Administration Guide.
Complete the SharePlex preinstallation checklist.
On the source server, install SharePlex for the source database. See: Install SharePlex on Linux/Unix for Oracle Database.
On the source server, run the appropriate database setup utility for the source database. See: Database Setup for Oracle.
IMPORTANT:
|
On the intermediary server, install the appropriate ODBC client of the target cloud database.
On the intermediary server, install SharePlex for the target cloud database. See: Install SharePlex on Linux/Unix for Oracle Database.
On the intermediary server, run the appropriate database setup utility for the target cloud database. See Database Setup Utilities.
IMPORTANT:
|
Specify the following in the routing map of the SharePlex configuration file:
the name of the intermediary server as the target host.
the name of the cloud database as the target database.
In the following example using a MySQL target, intermediary3 is the intermediary system and sptest3 is the target cloud database.
datasource:o.orcldbprim | ||
#source tables | target tables | routing map |
HR.EMP | "sptest3"."emp" | intermediary3@r.sptest3 |
For more information, see Configure SharePlex to replicate data in the SharePlex Administration Guide.
SharePlex can capture from an Oracle database that is running on a system other than the system where SharePlex is running.
This support covers Oracle databases running on Linux. This support applies only when SharePlex and the remote capture database are running on the same operating system type (i.e., if SharePlex is on Linux, the remote database must be on Linux).
SharePlex does not support remote capture from Oracle on RAC unless the database is running on ASM.
Notes:
|
To set up SharePlex for remote capture:
Run Oracle Setup on the SharePlex system according to the directions in Database setup for Oracle.
© ALL RIGHTS RESERVED. Feedback Nutzungsbedingungen Datenschutz Cookie Preference Center