All Apps and Add-ons

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

wifan_splunk
Splunk Employee
Splunk Employee

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?

Tags (1)
1 Solution

rzhang_splunk
Splunk Employee
Splunk Employee

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)
     )
 )

alt text

Hope this would help

View solution in original post

rzhang_splunk
Splunk Employee
Splunk Employee

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)
     )
 )

alt text

Hope this would help

wifan_splunk
Splunk Employee
Splunk Employee

It works, thanks.

0 Karma
Get Updates on the Splunk Community!

Index This | I am a number, but when you add ‘G’ to me, I go away. What number am I?

March 2024 Edition Hayyy Splunk Education Enthusiasts and the Eternally Curious!  We’re back with another ...

What’s New in Splunk App for PCI Compliance 5.3.1?

The Splunk App for PCI Compliance allows customers to extend the power of their existing Splunk solution with ...

Extending Observability Content to Splunk Cloud

Register to join us !   In this Extending Observability Content to Splunk Cloud Tech Talk, you'll see how to ...