Replication Server connects to an Oracle replicate database 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 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.