How does one route data through the Connection Manager?
Submitted by admin on Sun, 2004-08-08 12:28.
Code a TNSNAMES.ORA entry with two addresses. The first address specifies the address CM is listening on (coded in CMAN.ORA). The second is the address the traffic must be routed to. You also need to specify SOURCE_ROUTE=YES.
ED23_cman =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS=(PROTOCOL=TCP)(HOST=141.145.83.4)(PORT=1610))
(ADDRESS=(PROTOCOL=TCP)(HOST=hostname.domain.com)(PORT=1923))
)
(CONNECT_DATA =
(SERVICE_NAME = orcl)
)
(SOURCE_ROUTE = YES)
)»
- Login to post comments

