I have Oracle RAC server in our lab.
Here is my connection info:
SCAN name: host-scan-1.com, host-scan-2.com
Service name: my-oracle.com
I can connect to the server by running: $ORACLE_HOME/bin/sqlplus host-scan-1.com:1521/my-oracle.com
SO, can I connect to the RAC server with DB Connect 2.2.0? And how?
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
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
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
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
It works, thanks.