Table of Contents Previous Next


10 Appendix : 10.1 Certified and Supported Database Servers and Configurations

Oracle 10g Release 2 version 10.2.0.1.0 has been explicitly certified. Newer minor versions in the 10.2 line are supported as well.
Oracle 11g Release 2 version 11.2.0.2.0 has been explicitly certified. Newer minor versions in the 11.2 line are supported as well.
SQL Server 2005 version 9.00.1399.06 has been explicitly certified. Newer minor versions in the 9.00 line are supported as well.
SQL Server 2008 version 10.50.1617.0 has been explicitly certified. Newer minor versions in the 10.50 line are supported as well.
Depending upon the database products you are using with xDB Replication Server (Oracle, SQL Server, PostgreSQL, or Postgres Plus Advanced Server) along with the compatibility configuration mode if you are using Advanced Server, certain combinations of a source database server and a target database server are not permitted for a publication and its associated subscription in a single-master replication system.
Postgres Plus Advanced Server supports two compatibility configuration modes of operation, which are the following:
Oracle compatible configuration mode. Operations are performed using Oracle syntax and semantics for data types, functions, database object creation, and so forth. This mode is useful when your applications are migrated from Oracle, or you want your applications built in an Oracle compatible fashion.
PostgreSQL compatible configuration mode. Operations are performed using native PostgreSQL syntax and semantics. This mode is useful when your applications are migrated from PostgreSQL, or you want your applications built in a PostgreSQL compatible fashion.
For more information on features supported in Oracle compatible configuration mode, see the Database Compatibility for Oracle Developer’s Guide located at:
Note 1: Support of single-master replication systems where Oracle is the subscription (that is, the target) database has been deprecated and may be removed in a future release. It is recommended to avoid creation of a single-master replication system where Oracle is the subscription database.
Note 2: Support of single-master replication systems where SQL Server is the subscription (that is, the target) database has been deprecated and may be removed in a future release. It is recommended to avoid creation of a single-master replication system where SQL Server is the subscription database.
For multi-master replication systems, each master node acts as both a source for all master nodes and a target for all master nodes. Thus, the permitted database servers comprising a particular multi-master replication system or cluster is determined by the overall composition of the cluster, which is initially established when selecting the database type of the master definition node (see Step 3 in Section 6.2.2).
PostgreSQL compatible cluster. All master nodes must consist of PostgreSQL database servers or Postgres Plus Advanced Servers installed in PostgreSQL compatible configuration mode.
Advanced Server Oracle compatible cluster. All master nodes must consist of Postgres Plus Advanced Servers installed in Oracle compatible configuration mode.

10 Appendix : 10.1 Certified and Supported Database Servers and Configurations

Table of Contents Previous Next