Oracle as Primary Data Server

Learn about the primary database issues and considerations specific to the Oracle data server in a Sybase replication system.

• Replication Agent for Oracle
  As a primary data server, Oracle interacts with Replication Agent. The Replication Agent identifies and transfers information about data-changing operations or transactions from an Oracle primary data server to a primary Replication Server.
• Oracle System Management
  The Replication Agent provides a number of commands that return metadata information about the primary database (such as database names, table names, procedure names, and column names).
• Replication Intrusions and Impacts in Oracle
  The performance and operation of Oracle primary data servers may be affected if a Sybase replication system is incorporated.
• Oracle Primary Database Permissions
  The Replication Agent requires an Oracle login ID that has permission to access data and create new objects in the primary database.
• Primary Data Server Connectivity
  Replication Agent requires a JDBC driver to connect to an Oracle primary database.
• Replication Server and RSSD Connectivity
  Replication Agent uses TCP/IP and the Sybase JDBC driver (jConnect for JDBC, which is included in Replication Agent installation) to communicate with other Sybase servers. The Replication Agent does not rely on the Sybase interfaces file for connectivity information.
• Replication Agent Objects
  Replication Agent creates objects in the primary database to assist with replication tasks.
• Oracle Primary Database Configuration
  Learn about the additional issues specific to heterogeneous replication.
• Oracle Primary Datatype Translation
  Datatype translation and mapping provides a complete list of datatype mapping for Oracle datatypes.
• Automatic Storage Management
  Replication Agent for Oracle supports the use of the Oracle Automatic Storage Management (ASM) feature for online and archive redo logs.
• Real Application Clusters
  Replication Agent provides support for Oracle 10g and 11g Real Application Cluster (RAC) environments.