Creating a PowerExchange Capture Registration and Extraction Map for an Oracle Source

Creating a PowerExchange Capture Registration and Extraction Map for an Oracle Source

Adding a NODE Statement to the DBMOVER Configuration File on the Navigator System

Adding a NODE Statement to the DBMOVER Configuration File on the Navigator System

In the dbmover.cfg file on the PowerExchange Navigator system, add a NODE statement that points to the PowerExchange Listener on the Oracle source system. The PowerExchange Navigator requires this information to get metadata or change data from the Oracle source when you create a capture registration or perform a database row test.
This topic focuses on only the required parameters for the NODE statement.
NODE Statement
Syntax:
NODE=({
node_name
|
node1
} ,TCPIP ,
host_name
,{
port_number
|
2480
} )
Parameter descriptions:
node_name
|
node1
A unique, user-defined name for the set of connection information in the NODE statement that points to the remote PowerExchange Listener on the Oracle system.
When you create a registration group and perform a database row test, you must enter this node name in the
Location
field so that the PowerExchange Navigator can communicate with the remote PowerExchange Listener to retrieve metadata or change data for the Oracle source. This node name does not need to match the name of the PowerExchange Listener process in the LISTENER statement in the DBMOVER file on the source system.
Default value is node1.
This scenario uses a node name of pwx961.
TCPIP
The communications protocol. The only valid value is
TCPIP
.
host_name
The TCP/IP host name or IP address for the PowerExchange Listener process that listens on the port specified in the
port_number
parameter.
This scenario uses a host name of ora11A.
{
port_number
|
2480
}
The number of the TCP/IP port on which the PowerExchange Listener process that runs on the system specified in
host_name
listens. Valid values are 1 through 65535. Default is 2480.
This scenario uses a port number of 2695.
Example statement:
NODE=(pwx961,TCPIP,ora11A,2695)
For more information about the NODE statement, including its optional parameters, see the
PowerExchange Reference Manual
.

0 COMMENTS

We’d like to hear from you!