ODAC Net Option and Oracle Connection Manager
Posted: Mon 31 Jan 2005 17:11
Hello!
We use ODAC 5.5 and Oracle Server 9.2 (Windows 2000, Linux)
It's well known, that string like "192.168.0.1:1521:SDPV1" should be used in Connect String.
The problem is that we must connect to Oracle Server through Oracle Connection Manager using Net Option, but we don't know how to do it.
A Connection Description in TNSNAMES.ORA looks like:
SDPV1.TRANS =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.10)(PORT = 1630))
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.169.0.1)(PORT = 1521))
(SOURCE_ROUTE = YES)
)
(CONNECT_DATA =
(SERVICE_NAME = SDPV1.TRANS)
)
)
Could you tell me what should be written in Connect String in this case.
Best regards,
Boris
We use ODAC 5.5 and Oracle Server 9.2 (Windows 2000, Linux)
It's well known, that string like "192.168.0.1:1521:SDPV1" should be used in Connect String.
The problem is that we must connect to Oracle Server through Oracle Connection Manager using Net Option, but we don't know how to do it.
A Connection Description in TNSNAMES.ORA looks like:
SDPV1.TRANS =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.10)(PORT = 1630))
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.169.0.1)(PORT = 1521))
(SOURCE_ROUTE = YES)
)
(CONNECT_DATA =
(SERVICE_NAME = SDPV1.TRANS)
)
)
Could you tell me what should be written in Connect String in this case.
Best regards,
Boris