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 interfaces 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 interfaces 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.
Set dsi_proc_as_rpc on if you use ExpressConnect for Oracle. ECO only supports stored procedure replication using remote procedure calls (RPC). By default, Replication Server sets dsi_proc_as_rpc on if you use one of the Oracle ECO connection profiles when you create the connection to the Oracle database from Replication Server. See Replication Server Options 15.5 > Installation and Configuration Guide ExpressConnect for Oracle 15.5 > Configuring ExpressConnect for Oracle.
Set dsi_proc_as_rpc off if you use ECDA Option for Oracle. ECDA does not support RPC for stored procedure replication.