Yes, DB Connect 2.2.0 works for following two scenario:
Scenario1: If you are using Oracle Single Scan(Single Client Access Name), then you should set your connection as
set your Host to host-scan-1.com
Choose database type to Oracle Service (using ojdbc6.jar)
Set default database to my-oracle.com, actually this is your service name
Port is 1521
Then you can connect to the host-scan-1.com
Scenarios2:
If you are using multiple SCAN, san host-scan-1.com and host-scan2.com. You need to specify the URL by your self in JDBC URL Format, see below screenshot. For example:
jdbc:oracle:thin:@(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP) (HOST = host-scan-1) (PORT = 1521))
(ADDRESS = (PROTOCOL = TCP) (HOST = host-scan-2) (PORT = 1521))
(ADDRESS = (PROTOCOL = TCP) (HOST = host-scan-3) (PORT = 1521))
(CONNECT_DATA =
(SERVICE_NAME = myoracle.servicename)
(CONNECT_TIMEOUT=5)(RETRY_COUNT=2)
)
)
Hope this would help
... View more