SharePlex 8.6.6 - Reference Guide

Chat now with support

Get Live Help
Complete Registration

Sign In

Request Pricing

Contact Sales

About this guide Conventions used in this guide SharePlex commands

SharePlex commands at a glance Overview of SharePlex security groups Alphabetical reference for SharePlex commands

abort config abort service activate config analyze config append status authlevel cancel clear history clear status compare / compare using compare status connection copy/append copy config copy status create config create encryption key deactivate config disable jobs / enable jobs edit edit config exit expand flush help host hostinfo job status list config list param lstatus orainfo port purge config qstatus quit reconcile redo remove config remove log rename config repair / repair using repair status report reset encryption key reset param set encryption key set log set param show show activate show capture show config show encryption key show export show import show log show post show read show sql show statusdb show scn show sync shutdown start startup status stop target trace capture trace post trace read truncate log usage verify config version view config view log options

SharePlex parameters

Descriptions of user-configurable parameters

Configuration Parameters Capture Parameters SQL Server Capture Parameters Read Parameters Export Parameters Import Parameters Post Parameters Open Target Post Parameters Queue parameters sp_cop Parameters Log Parameters SNMP Parameters System Parameters Compare Command Parameters Sync Parameters Analyze Config Command Parameters

Deprecated Parameters

SharePlex utilities Appendix B: SharePlex environment variables

Database specifications in a configuration file

A database specification is required in the following components of the configuration file:

the datasource (source data store) specification
routing map (target data store and location) specification

Database	Database type notation*	Database Identifiers
Oracle source or target	o.	Depending on the Oracle database configuration, use one of the following. This is the string that SharePlex will use to connect to the database. The Oracle SID of a regular (non-CDB) Oracle database, as in o.ora12. The tns_alias of a pluggable database (PDB) in an Oracle container database (CDB), as in o.pdb1. The global tns_alias of an Oracle RAC cluster, as in o.rac1. SharePlex connects to an Oracle RAC instance through this tns_alias, which is mapped locally on each node to the Oracle SID of the local Oracle instance. For more information about creating this alias, see Configure SharePlex in a Cluster in the SharePlex Installation Guide.
Open Target targets	r.	Use to specify the name of an Open Target (non-Oracle) target database, as in r.mydb. Important! Use the actual database name. Do not use the ODBC datasource name (DNS) or database instance name. If the database name is case-sensitive, specify it that way. For more information about configuring SharePlex to replicate to a specific Open Target target, see Configure replication to Open Target targets.
Oracle change-history target	c.	Use in a routing map to specify the Oracle SID, tns_alias, or global RAC tns_alias of an Oracle change history database, as in c.ORA12CH. In this configuration, SharePlex applies all source transactions as INSERTs to the target tables, to maintain a history of every operation performed. For more information, see Configure replication to maintain a change history target.

Database

Database type notation*

Database Identifiers

Oracle source or target

Depending on the Oracle database configuration, use one of the following. This is the string that SharePlex will use to connect to the database.

The Oracle SID of a regular (non-CDB) Oracle database, as in o.ora12.
The tns_alias of a pluggable database (PDB) in an Oracle container database (CDB), as in o.pdb1.
The global tns_alias of an Oracle RAC cluster, as in o.rac1. SharePlex connects to an Oracle RAC instance through this tns_alias, which is mapped locally on each node to the Oracle SID of the local Oracle instance. For more information about creating this alias, see Configure SharePlex in a Cluster in the SharePlex Installation Guide.

Open Target targets

Use to specify the name of an Open Target (non-Oracle) target database, as in r.mydb. Important! Use the actual database name. Do not use the ODBC datasource name (DNS) or database instance name. If the database name is case-sensitive, specify it that way.

For more information about configuring SharePlex to replicate to a specific Open Target target, see Configure replication to Open Target targets.

Oracle change-history target

Use in a routing map to specify the Oracle SID, tns_alias, or global RAC tns_alias of an Oracle change history database, as in c.ORA12CH. In this configuration, SharePlex applies all source transactions as INSERTs to the target tables, to maintain a history of every operation performed.

For more information, see Configure replication to maintain a change history target.

* Note: The dot is required.

Please select your product:

To serve you better, please complete the Purpose of your Chat:

Recommended Solutions for Your Problem

SharePlex 8.6.6 - Reference Guide

Database specifications in a configuration file