Prerequisites

Review the prerequisites before you begin setting up replication for Oracle.

Make sure:
  • You have an understanding of SAP replication and are familiar with Oracle data servers.

  • You have valid licenses for Replication Server and Replication Server Options.

  • Oracle database is installed and configured to serve as the source (primary) database from which Replication Agent replicates transactions and as the target (replicate) database to which Replication Server with ExpressConnect for Oracle replicates transactions.

  • Install the correct Oracle JDBC thin driver.

    Primary Database Install
    Oracle 12c Oracle JDBC thin driver ojdbc7.jar
    Oracle 11g Release 2 Oracle JDBC thin driver 11.2 for JDK 1.6
    Note: Install the xstreams.jar for Oracle XStream JDBC driver in the CLASSPATH environment variable.
    Oracle 10g or 11g Release 1 Oracle JDBC thin driver for Oracle 10g or 11g and for JDK 1.4 and 1.5
  • TCP/IP connectivity is available.

  • Any operating system patches required for Java have been installed.

  • The Replication Agent has direct access to the primary Oracle online and archived redo logs.

Do not use Replication Server reserved words for object names or connection names. A complete list of reserved words is in the Replication Server Reference Manual.

Related tasks
Setting Up an Oracle XStream JDBC Driver