Can I connect to Oracle RAC with DB Connect?And how?

[wifan_splunk]

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?

[rzhang_splunk · Accepted solution]

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

1. set your Host to host-scan-1.com
2. Choose database type to Oracle Service (using ojdbc6.jar)
3. Set default database to my-oracle.com, actually this is your service name
4. 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

[wifan_splunk]

It works, thanks.