Bulk Data Movement Guide

10.4.0
- 10.5.6
- 10.5.5
- 10.5.4
- 10.5.3
- 10.5.2
- 10.5.1
- 10.5
- 10.4.1
- 10.4.0 HotFix 1

Back Next

Setting Up and Testing Connectivity to a Remote Oracle Source or Target

If the Oracle data source or target is on a remote system, PowerExchange and PowerCenter must be able to communicate with the PowerExchange Listener on that remote system unless you are using SQL*Net.

To set up and test connectivity to a remote Oracle source or target:

On the system or systems where the PowerExchange Navigator, PowerCenter Client, and PowerCenter Integration Service run, use the ping
command to test network access to the remote system.

Add the NODE statement to the dbmover.cfg file on each PowerExchange and PowerCenter system to identify the remote PowerExchange Listener and its port:

NODE=(node_name,TCPIP,ipaddress_or_hostname,port_number)

To determine the port number, consult with the person in your organization who installed the PowerExchange Listener on the remote system.

Run the DTLREXE ping utility on the local PowerExchange system to test connectivity to the remote PowerExchange Listener that you defined in the NODE statement.

Rename Saved Search

Table of Contents

Bulk Data Movement Guide

Bulk Data Movement Guide

Setting Up and Testing Connectivity to a Remote Oracle Source or Target

Setting Up and Testing Connectivity to a Remote Oracle Source or Target