Configuring ExpressConnect for Oracle

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

Prerequisites

Make sure that you have installed the Oracle Instant Client libraries before proceeding.

Task

Copy the Oracle server 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.
Using isql 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 creating the connection using one of the Replication Server connection profiles for ExpressConnect for Oracle, 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 ExpressConnect for Oracle connection profiles, dsi_proc_as_rpc is enabled by default.
See Replication Server Reference Manual for more information on the create connection command. For more information about configuring ExpressConnect for Oracle, see the ExpressConnect for Oracle Configuration Guide.