Replication Server can connect to an Oracle replicate database using ECDA Option for Oracle or ExpressConnect for Oracle (ECO).
A Replication Server database connection name is made up of two parts; a data server name (server_name) and a database name (db_name). The server_name is the name of the ECDA Option for Oracle database gateway server, and the db_name is the name of the Oracle SID for the replicate database.
The replicate Replication Server looks for an interface file entry for the database gateway server_name specified in the Replication Server database connection. The replicate Replication Server logs in to the replicate data server using the user_name and password specified in the database connection.
Make an entry in the Replication Server interface file to identify the host and port where the ECDA Option for Oracle database gateway server is listening. The interface file entry name must match the server_name portion of the Replication Server database connection.
A Replication Server database connection name is made up of two parts; a data server name (server_name) and a database name (db_name). The server_name is the name of the desired service (Oracle instance) in the tnsnames.ora file. The db_name is the name given to the Oracle database at the time of its installation and configuration (Oracle SID). By default, this is usually “ORCL.”
ExpressConnect for Oracle looks for an entry in the tnsnames.ora file to match the server_name specified in the Replication Server database connection. The replicate Replication Server logs in to the replicate data server using the user_name and password specified in the database connection.There is no interfaces file entry required for the Oracle data server for replication using ExpressConnect for Oracle.
