Configuring ExpressConnect for Oracle

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

  1. Copy the Oracle server's tnsnames.ora file to the RS_installation_directory\ REP-15_5\connector\oraoci\network\admin directory.
  2. Determine the Oracle user ID and password used to connect from Replication Server. See “Oracle replicate database permissions” in the Replication Server 15.5 Heterogeneous Replication Guide.
  3. Restart Replication Server.
  4. Using isql create a connection to Replication Server using the Oracle alias name, user ID, and password combination. For example:
    create connection to
<tns_alias_name>.<ora_sid_name>
using profile rs_oracle_to_oracle;eco
set username <userid>
set password <password>
set dsi_dataserver_make to 'ora'
set dsi_connector_type to 'oci'
set batch to 'off'

    where:
    • tns_alias_name is the alias name for the replicate Oracle database defined in the tnsnames.ora file.
    • ora_sid_name is the Oracle SID for the replicate database that is paired with the above tns_alias_name in the tnsnames.ora file. The default value is ORCL.
    If you are not creating the connection 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 <tns_alias_name>.<ora_sid_name>
set error class <error_class> 
set function string class <function_class> 
set username <userid>
set password <password>
set dsi_dataserver_make to 'ora'
set dsi_dataserver_type to 'oci'
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.