This section contains the requirements for an Oracle database as a source when capturing from an Oracle database and replicating to supported target databases.
For information regarding supported source and target operating systems with specific database versions, see the Compatibility Matrix for Supported Operating Systems and Target Platforms section.
SharePlex supports the Standard and Enterprise Editions of Oracle 12cR1, 12cR2, 18c, 19c, 21c, and 23ai*.
Notes:
|
Steps to update the CLIENT_STATISTICS_LEVEL Database Parameter
To see the current value of CLIENT_STATISTICS_LEVEL, use the following command:
SQL> SHOW PARAMETER CLIENT_STATISTICS_LEVEL;
If the current value is set to TYPICAL, update it to OFF using the following command:
SQL> ALTER SYSTEM SET CLIENT_STATISTICS_LEVEL = 'OFF' SCOPE=SPFILE;
To apply the change, restart the database by executing the following commands:
SQL> SHUTDOWN IMMEDIATE;
SQL> STARTUP;
*Conditions of Support for Oracle 23ai:
Oracle 23ai is supported on DBCS, ExaCS/CC, and Oracle On-premises Exadata platforms.
On Oracle 23ai, the Copy/Append command is not supported with encrypted tablespaces.
In 23ai, when creating a table with an XMLType column, it is created with a default storage type of TRANSPORTABLE BINARY XML. To enable SharePlex support, change the XMLType column’s storage type to BINARY XML.
For CDB or PDB users with a 23ai database using the 23ai Oracle client, when SP_OCT_OLOG_USE_OCI is set to 1 on either local or remote Capture, provide the following grants to the SharePlex user from CDB$ROOT:
CDB container user:
GRANT SELECT, UPDATE ON sys.dir$ to <shareplex database user name> container=ALL;
GRANT SELECT, UPDATE ON sys.obj$ to <shareplex database user name> container=ALL;
PDB container user:
GRANT SELECT, UPDATE ON sys.dir$ to <shareplex database user name> container=CURRENT;
GRANT SELECT, UPDATE ON sys.obj$ to <shareplex database user name> container=CURRENT;
Oracle Cloud Infrastructure:
Enterprise Standard Edition
Enterprise Edition High Performance
Enterprise Edition Extreme Performance
Amazon Web Services:
Microsoft Azure:
Azure Virtual Machine (IaaS)
Oracle Exadata: Issues on Oracle Exadata will be tested against Oracle Exadata Cloud Service for reproduction purposes.
Oracle Database Cloud Service (DBCS): SharePlex only supports Transparent Data Encryption (TDE) feature on DBCS EE-HP, DBCS EE-EP, and ExaCS/CC.
Amazon RDS for Oracle: Please see Supported Oracle Source and Target Versions for additional clarification on version compatibility.
This is a list of commonly used Oracle features which SharePlex does not replicate and are not listed elsewhere in this document. Since both Oracle and SharePlex continually change and improve, this list of exclusions cannot be considered complete. Unless an item is stated here as being supported, assume that SharePlex does not replicate it.
| Object/operation/feature | Not supported |
|---|---|
| Oracle operations | Operations that do not appear in the redo logs. This includes any DML or DDL not in the redo logs, and also PL/SQL packages which do not write results to the redo logs, for example, dbms_shared_pool.keep and related packages. |
|
dbms_scheduler.create_job |
This object is not supported. |
| Flashback |
SharePlex does not support the Oracle Flashback Table feature. If the SP_REPLICATE_ALL_DDL parameter is enabled (value of 1), SharePlex may try to replicate the flashback DDL, which will return an error. To perform Flashback Table on a table that is in replication, use the following procedures
|
| Special characters |
|
Notes about open target data type support
Replication of LOB operations generated by dbms_lob are not supported when replicating to non-Oracle targets.
SharePlex does not support the replication of data from Oracle to open targets for the below Extended Data Types:
The following table shows whether specific SharePlex features are supported for replication from Oracle to open targets.
| SharePlex feature | Supported open targets |
|---|---|
| reconcile command (target instantiation) | All |
| Compare/Compare Using and repair/repair using commands* | PostgreSQL |
| copy/copy using and append/append using commands | Not supported |
| Hash horizontally partitioned replication | All |
| Column-based horizontally partitioned replication | All |
| Vertically partitioned replication | All |
| Column mapping | All |
| Key definition | All |
| Build configuration with scripts | Not supported |
| Named queues | All |
| Commit Reduction (feature of Post Enhanced Performance) | All |
| Dependency Checking (feature of Post Enhanced Performance) | Not supported |
| Transformation | Not supported |
| Conflict resolution |
PostgreSQL |
| Peer-to-peer replication (bi-directional) | PostgreSQL |
| Consolidated replication (many to one) | All |
| Broadcast replication (one to many) | All |
| High availability replication (active/passive bi-directional) | PostgreSQL |
| Change tracking target (CDC) | Not supported |
| Data encryption | All |
| Data compression | All |
| SSH | All |
| auth_hosts file | All |
| Monitoring scripts | All |
| SNMP monitoring | All |
| Continue posting on error (SP_OPX_CONT_ON_ERR) | All |
| Suspend on out of sync errors (SP_OPX_OUT_OF_SYNC_SUSPEND) | All |
| Reduced key (SP_OPX_REDUCED_KEY) | All |
| Logical Transaction Rollback on out-of-sync transactions | Not supported |
| HSM: Oracle database wallet key store on external storage using sp_hsm utility | All |
* The Compare and Repair commands for Oracle to PostgreSQL replication are certified for use with Oracle 18c, 19c, 21c, and 23ai.
This chapter contains the requirements when capturing OLTP compressed data from an Oracle source database and replicating it to a supported target database.
The following operating systems are supported for capture from a supported Oracle database and replication to a supported target database.
SharePlex supports only the 64-bit version of the listed operating systems.
For OLTP, SharePlex supports the following operating systems only:
SuSE SLES 12.x and 15.x
Windows Server 2019, 2022, and 2025
SharePlex supports the Standard and Enterprise Editions of Oracle 12cR1, 12cR2, 18c, 19c, and 21c for replicating the OLTP compressed data.
SharePlex supports DML operations on tables and sequences, with some conditions. DML can be replicated from an Oracle source to an Oracle or an open target.
Note: Replication to targets with a different character set is supported, with limitations. When posting to open target databases, XML files and JMS, SharePlex supports only UNICODE and US7ASCII on the target, but conversion can be performed by an Oracle client installed on the target system. Parquet supports only the UTF-8 character set. For full details, see the Preinstallation Checklist in the SharePlex Installation and Setup Guide.
SharePlex supports the following DML operations on tables:
Direct-path loads (SQL*Loader) (INSERT AND FULL ROLLBACK).
Note: Replication of partial rollbacks of DLOADs is not supported.
The target table must support the column types that are being replicated from the source Oracle table.
SharePlex supports the following table types for DML operations:
|
Supported table type* |
Conditions of Support |
|---|---|
|
Regular Oracle tables |
None |
|
Index-organized tables |
SharePlex does not support:
|
|
Partitioned tables |
None |
|
Views |
None |
|
Materialized views |
SharePlex does not support replication from a materialized view to a materialized view. SharePlex can replicate the underlying table of a materialized view to a regular target table. |
SharePlex does not support the following table types:
*SharePlex does not support the following for any table type:
SharePlex supports DML operations on secured or compressed objects as described in the following table. See "Conditions of support" following this table for additional information.
| Secured/Compressed Object | Can be replicated to: |
|---|---|
| DML on tables encrypted by Oracle Obfuscation Toolkit | All target types |
|
DML on tables with Transparent Data Encryption (TDE)1 |
All target types |
|
DML on Oracle Label Security (OLS)2 |
All target types |
|
DML on compressed objects: Basic, Advanced Row (OLTP) Compression, HCC3 |
All target types |
|
Direct Load (DLOAD) on compressed objects: Basic, Advanced Row (OLTP) Compression, HCC3 |
All target types |
1. TDE
SharePlex supports Tablespace Encryption and Column Encryption, both source and target.
The SharePlex copy/append command does not support TDE.
TDE is not supported for sources on RDS.
SharePlex only supports the AES and DES encryption algorithms.
2. OLS
By default, SharePlex cannot process rows that are protected by OLS (Oracle Label Security) because users granted DBA privileges (like SharePlex) do not have enough privileges to access those rows. However, if privilege is granted from the OLSSYS user, SharePlex can support OLS. SharePlex was tested under the following OLS configuration:
Note: If the OLS policy data label column is defined as hidden, the data in that column cannot be replicated by SharePlex.
Important: Shareplex does not support OLS policy configuration changes on tables during active replication. Users need to apply these configurations before activating the configuration.
3. Compression
For HCC compression: SharePlex does not support query low compression. Supported types of compression are query high, archive low and archive high.
For Advanced Row (OLTP) Compression: Under certain conditions, Oracle does not provide enough information in the redo log for SharePlex to replicate a DML operation on a OLTP compressed object. Testing of OLTP compressed objects is advised.
SharePlex provides default and optional DDL support.
|
Notes: ALTER TABLE to ADD COLUMN and ALTER TABLE to DROP COLUMN are supported on Basic, Advanced Row (OLTP) Compression, and HCC compressed Oracle objects for replication to all Oracle and open targets. |
SharePlex does not support:
SharePlex provides limited DDL support for replication from Oracle to open targets. The involved objects must be listed in the active configuration file explicitly or with a wildcard. There is no optional DDL support for replication from Oracle to cross platforms.
The default Oracle to open target configuration is represented by the following parameter setting:
SP_OCT_REPLICATE_DDL=3
See "Table Notes" following this table for additional information.
| Supported object | Supported Operation |
|---|---|
| Table and IOT | Truncate1 |
| Alter table add column2 | |
| Alter table drop column |
Table Notes:
|
SharePlex supports replication from Oracle to Azure Event Hubs, according to the details below.
For information regarding supported source and target operating systems with specific database versions, see the Compatibility Matrix for Supported Operating Systems and Target Platforms section. To view compatibility across operating systems for remote replication, see Compatibility Across Operating Systems (Remote Collection and Posting).
Supported platform as a service: Azure Event Hubs
Limitation: SharePlex displays incorrect column names for schemas when the column name exceeds 30 characters on the source, in JSON and XML formats, during replication from Oracle to Azure Event Hubs.
SharePlex supports DML operations on tables and sequences, with some conditions. DML can be replicated from an Oracle source to an Azure Event Hubs target. For additional information, see Supported Operations and Objects for DML Replication.
SharePlex supports DDL operations on tables and sequences, with some conditions. DDL can be replicated from an Oracle source to an Azure Event Hubs target. For additional information, see Oracle to open target DDL support.
SharePlex supports replication from Oracle to Parquet file, according to the details below.
For information regarding supported source and target operating systems with specific database versions, see the Compatibility Matrix for Supported Operating Systems and Target Platforms section. To view compatibility across operating systems for remote replication, see Compatibility Across Operating Systems (Remote Collection and Posting).
File (format record=parquet)
|
Note: Parquet supports only the UTF-8 character set. |
| Oracle | Parquet Logical Type | Parquet Physical Type |
|---|---|---|
| CHAR | STRING | BYTE_ARRAY with UTF-8 encoding |
| VARCHAR / VARCHAR2 | STRING | BYTE_ARRAY with UTF-8 encoding |
| NUMBER(p) | DECIMAL(p) | FIXED_LEN_BYTE_ARRAY |
| NUMBER(p, s) | DECIMAL(p, s) | FIXED_LEN_BYTE_ARRAY |
| NUMBER | DECIMAL(38, 18) | FIXED_LEN_BYTE_ARRAY |
| BINARY_FLOAT / BINARY_DOUBLE | DOUBLE | DOUBLE |
| DATE | TIMESTAMP (milliseconds / seconds) | INT64 |
| TIMESTAMP([0-3]/[4-6]/[7-9]) | TIMESTAMP (milliseconds / microsecond/ nanosecond) | INT64 |
| TIMESTAMP with TZ | TIMESTAMP (milliseconds / microsecond/ nanosecond) | INT64 |
| TIMESTAMP with LTZ | TIMESTAMP (milliseconds / microsecond/ nanosecond) | INT64 |
| CLOB / NCLOB | STRING | BYTE_ARRAY with UTF-8 encoding |
| LONG / LONGVARCHAR | STRING | BYTE_ARRAY with UTF-8 encoding |
| BLOB | BINARY | BYTE_ARRAY |
| RAW / LONGRAW | BINARY | BYTE_ARRAY |
SharePlex supports DML operations on tables and sequences, with some conditions. DML can be replicated from an Oracle source to a Parquet target.
SharePlex does not support DDL operations and objects when replicating data from an Oracle source to a Parquet target.
SharePlex supports replication from Oracle to File Output, according to the details below.
For information regarding supported source and target operating systems with specific database versions, see the Compatibility Matrix for Supported Operating Systems and Target Platforms section.
* Note: The Parquet file type is supported only on Linux platforms.
Limitation: SharePlex displays incorrect column names for schemas when the column name exceeds 30 characters on the source, in JSON and XML formats, during replication from Oracle to File Output.
This mapping applies to all targets that receive messages as XML:
| Oracle | XML |
|---|---|
| BINARY_DOUBLE | decimal |
| BINARY_FLOAT | decimal |
| BLOB | base64Binary |
| CHAR | string |
| CLOB | string |
| DATE | dateTime |
| INTERVAL DAY TO SECOND | dayTimeDuration |
| INTERVAL YEAR TO MONTH | yearMonthDuration |
| LONG | string |
| NCHAR | string |
| NCLOB | string |
| NUMBER | decimal |
| NVARCHAR2 | string |
| RAW | base64Binary |
| ROWID | string |
| TIMESTAMP | dateTime |
| TIMESTAMP WITH LOCAL TIME ZONE | dateTimeStamp |
| TIMESTAMP WITH TIME ZONE | dateTimeStamp |
| VARCHAR2 | string |
| VARRAY | Post maps the data types in the source VARRAY to the appropriate XML data types. Only certain data types in a VARRAY are supported. See the conditions of support. |
Only the following data types in a VARRAY are supported by SharePlex when replicating to XML output:
See Conditions of support for the above-mentioned supported data types.
This mapping applies to all targets that receive messages as JSON:
| Oracle | JSON |
|---|---|
| BINARY_DOUBLE | Number |
| BINARY_FLOAT | Number |
| BLOB | String containing base64 encoded data |
| CHAR | String |
| CLOB | String |
| DATE | String containing date |
| INTERVAL DAY TO SECOND | String containing interval |
| INTERVAL YEAR TO MONTH | String containing interval |
| LONG | String |
| NCHAR | String |
| NCLOB | String |
| NUMBER | Number |
| NVARCHAR2 | String |
| RAW | String containing hex encoded data |
| ROWID | String |
| TIMESTAMP | String containing timestamp |
| TIMESTAMP WITH LOCAL TIME ZONE | String containing timestamp |
| TIMESTAMP WITH TIME ZONE | String containing timestamp |
| VARCHAR2 | String |
Conditions of support: See Conditions of support for the above-mentioned supported data types.
| Oracle | Parquet Logical Type | Parquet Physical Type |
|---|---|---|
| CHAR | STRING | BYTE_ARRAY with UTF-8 encoding |
| VARCHAR / VARCHAR2 | STRING | BYTE_ARRAY with UTF-8 encoding |
| NUMBER(p) | DECIMAL(p) | FIXED_LEN_BYTE_ARRAY |
| NUMBER(ps) | DECIMAL(p, s) | FIXED_LEN_BYTE_ARRAY |
| NUMBER | DECIMAL(38, 18) | FIXED_LEN_BYTE_ARRAY |
| BINARY_FLOAT / BINARY_DOUBLE | DOUBLE | DOUBLE |
| DATE | TIMESTAMP (milliseconds / seconds) | INT64 |
| TIMESTAMP([0-3]/[4-6]/[7-9]) | TIMESTAMP (milliseconds / microsecond/ nanosecond) | INT64 |
| TIMESTAMP with TZ | TIMESTAMP (milliseconds / microsecond/ nanosecond) | INT64 |
| TIMESTAMP with LTZ | TIMESTAMP (milliseconds / microsecond/ nanosecond) | INT64 |
| CLOB / NCLOB | STRING | BYTE_ARRAY with UTF-8 encoding |
| LONG / LONGVARCHAR | STRING | BYTE_ARRAY with UTF-8 encoding |
| BLOB | BINARY | BYTE_ARRAY |
| RAW / LONGRAW | BINARY | BYTE_ARRAY |
SharePlex supports DML operations on tables and sequences, with some conditions. DML can be replicated from an Oracle source to a File Output target. For additional information, see Supported Operations and Objects for DML Replication.
SharePlex supports DDL operations on tables and sequences, with some conditions. DDL can be replicated from an Oracle source to a File Output target. SharePlex does not support DDL replication from Oracle to a Parquet file. For additional information, see Oracle to open target DDL support.
© ALL RIGHTS RESERVED. Termini di utilizzo Privacy Cookie Preference Center
