Configuring ExpressConnect for Oracle

Configure ExpressConnect for Oracle to set up connections between Oracle and Replication Server.

Copy the Oracle server's tnsnames.ora file to the RS_installation_directory\REP-15_5\connector\oraoci\network\admin directory.
Determine the Oracle user ID and password used to connect from Replication Server. See Oracle replicate database permissions in the Replication Server 15.7.1 Heterogeneous Replication Guide.
Restart Replication Server.
Use isql to create a connection to Replication Server using the alias name defined in the Oracle tnsnames.ora file, user ID, and password combination. For example:
```
create connection to
<tnsnames_alias>.<ora_rdb_name>
using profile rs_oracle_to_oracle;eco
set username <userid>
set password <password>
set batch to 'off'
```
where:
- tnsnames_alias is the case-sensitive name identifying the replicate Oracle database in the tnsnames.ora file. For example:
```
<tnsnames_alias> =
   (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = hostname)(PORT = 1521))
      (CONNECT_DATA =
          (SERVER = DEDICATED)
          (SERVICE_NAME = orcl)
      )
   )
```
- ora_rdb_name can be any name which best describes the replicate Oracle database, for example, orcl11g.
If you are not using one of the Replication Server connection profiles for ECO, set dsi_proc_as_rpc to on in the create connection command. For example:
```
create connection to <tnsnames_alias>.<ora_rdb_name>
set error class <error_class> 
set function string class <function_class> 
set username <userid>
set password <password>

set batch to 'off'
set dsi_proc_as_rpc to 'on' 
```
If you are using one of the ECO connection profiles, dsi_proc_as_rpc is enabled by default.
See Replication Server Reference Manual for more information on the create connection command.