Wiki Admin

Oracle Requirements - DSS 6 | Data Source Solutions Documentation

Export as HTML Export as PDF Export as DOCX
Edit

Documentation: Oracle Requirements - DSS 6 | Data Source Solutions Documentation

Oracle Requirements

This section describes the requirements, access privileges, and other features of Data Source Solutions DSS when using Oracle for replication.

Supported Platforms

  • Learn about the Oracle versions compatible with DSS on our Platform Support Matrix page (6.1.0, 6.1.5, 6.2.0, and 6.2.5).

Supported Capabilities

  • Discover what DSS offers for Oracle on our Capabilities for Oracle page (6.1.0, 6.1.5, 6.2.0, and 6.2.5).

Data Management

Data Source Solutions provides additional solutions for replicating data from Oracle. For more information, see section Oracle in Databases.

Oracle client library version 21 is supported since version 6.1.0/19.

Connecting to Oracle Database or ASM Instance

This section describes how DSS connects to an Oracle Database or ASM instance. DSS uses Oracle’s native TNS connection libraries to establish the connection and supports two connection types: Local connections and TNS connections.

Local connections

A local connection uses the bequeath protocol to establish a direct connection, which bypasses the listener and provides higher performance. It uses an Oracle SID to identify the Oracle Database or ASM instance. To use this connection type, DSS must run on the same machine as the Oracle Database or ASM instance, and you must set ORACLE_HOME to the Oracle home for that instance.

In the DSS UI, to use this method, select the Local connect to database option and enter the SID in the SID field. For CLI and REST API configurations, use the Oracle_SID location property.

TNS connections

A TNS connection uses the Oracle listener to establish the connection. You can use this connection type regardless of whether DSS runs on the same machine as the Oracle instance or on a remote machine. This connection type supports all TNS features, including mTLS. DSS supports the following methods for establishing a TNS connection:

  • Connection string
    Connect using a simple host-based connection string in the form HOST[:PORT]/SERVICE_NAME.

  • TNS alias
    Connect using a TNS alias that resolves to the Oracle Database or ASM instance. To use this method, you must include TNSNAMES in NAMES.DIRECTORY_PATH in the sqlnet.ora file used for the connection.

  • EZCONNECT
    Connect using the EZCONNECT naming method, with a connection identifier in the form ``HOST[:PORT]/SERVICE_NAME_or_SID. To use this method, you must include EZCONNECTinNAMES.DIRECTORY_PATHin thesqlnet.ora` file used for the connection. For more information about EZCONNECT, see Oracle’s Configuring the Easy Connect Naming Method documentation.

In the DSS UI, to use this method, select the Oracle TNS option and enter either a TNS alias or a connect string in the Oracle TNS field. For CLI and REST API configurations, use the Oracle_TNS location property.

Oracle Database Client

DSS requires the full Oracle Database Client to be installed on the machine from which it connects to the Oracle database, except when DSS is installed on the Oracle database server machine. For detailed instructions on downloading and installing the Oracle Database Client, refer to Oracle’s documentation for Linux (also see OS Requirements) and Windows.

The requirement to install the Oracle Database Client depends on how the DSS Hub connects to the Oracle database.

  • Connects directly without DSS Agent:

    • When the DSS Hub installed on the Oracle database server connects directly to the Oracle database, you don’t need to install the Oracle Database Client, assuming the full Oracle Database Client was pre-installed with Oracle.
    • When the DSS Hub installed on a separate machine (not the Oracle database server) connects directly to the Oracle database, you must install the full Oracle Database Client on the machine hosting the DSS Hub.

  • Connects via DSS Agent:

    • When the DSS Hub connects to the Oracle database through an DSS Agent installed on the Oracle database server, you don’t need to install the Oracle Database Client, assuming the full Oracle Database Client was pre-installed with Oracle.
    • When the DSS Hub connects to the Oracle database through an DSS Agent installed on a separate machine (not the Oracle database server), you must install the full Oracle Database Client on the machine hosting the DSS Agent.

When installing the client, ensure that you install only the full Oracle Database Client, as the Instant Client is insufficient for DSS operations. The full Oracle Database Client includes all necessary libraries and tools for advanced features such as replication and monitoring, whereas the Oracle Instant Client is lightweight and may lack the critical libraries required for these features.

Supported Editions

DSS supports the following Oracle editions:

  • Enterprise edition
  • Standard edition

DSS log-based capture is not supported on Oracle 18c Express Edition because the supplemental logging settings cannot be modified in this edition.

Related Articles