AppD Archive

Unable to connect to Oracle RAC

CommunityUser
Splunk Employee
Splunk Employee

Hi,

I want to monitor Oracle RAC DB.  PFB the connection string we are using for connecting to Oracle RAC database :

jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=scan-uatrac)(PORT=1599)(CONNECT_DATA=(SERVICE_NAME=RXPG)))

The error I am getting is as follows NL exception in logs for this connection.

Kindly let me know if I am missing something.

Stacktrace as below

java.sql.SQLRecoverableException: IO Error: NL Exception was generated

        at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:673)

        at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:715)

        at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:385)

        at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:30)

        at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:564)

        at java.sql.DriverManager.getConnection(DriverManager.java:571)

        at java.sql.DriverManager.getConnection(DriverManager.java:187)

        at com.singularity.ee.agent.dbagent.collector.db.relational.DriverManager.getConnection(DriverManager.java:35)

        at com.singularity.ee.agent.dbagent.collector.db.relational.oracle.OracleCollector.initConnection(OracleCollector.java:65)

        at com.singularity.ee.agent.dbagent.collector.db.relational.ARelationalDBCollector.verifyCollector(ARelationalDBCollector.java:70)

        at com.singularity.ee.agent.dbagent.collector.db.ADBCollector.run(ADBCollector.java:135)

        at com.singularity.ee.util.javaspecific.scheduler.AgentScheduledExecutorServiceImpl$SafeRunnable.run(AgentScheduledExecutorServiceImpl.java:107)

        at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471)

        at com.singularity.ee.util.javaspecific.scheduler.ADFutureTask$Sync.innerRunAndReset(ADFutureTask.java:335)

        at com.singularity.ee.util.javaspecific.scheduler.ADFutureTask.runAndReset(ADFutureTask.java:152)

        at com.singularity.ee.util.javaspecific.scheduler.ADScheduledThreadPoolExecutor$ADScheduledFutureTask.access$101(ADScheduledThreadPoolExecutor.java:119)

        at com.singularity.ee.util.javaspecific.scheduler.ADScheduledThreadPoolExecutor$ADScheduledFutureTask.runPeriodic(ADScheduledThreadPoolExecutor.java:206)

        at com.singularity.ee.util.javaspecific.scheduler.ADScheduledThreadPoolExecutor$ADScheduledFutureTask.run(ADScheduledThreadPoolExecutor.java:236)

        at com.singularity.ee.util.javaspecific.scheduler.ADThreadPoolExecutor$Worker.runTask(ADThreadPoolExecutor.java:694)

        at com.singularity.ee.util.javaspecific.scheduler.ADThreadPoolExecutor$Worker.run(ADThreadPoolExecutor.java:726)

        at java.lang.Thread.run(Thread.java:745)

0 Karma

Arun_Dasetty
Super Champion

Hi Prasad,

Apologies for delay in response, Can you check if the suggestions at below forum links helps here:

https://community.oracle.com/thread/3546472?start=0&tstart=0

http://www.wikiguga.com/topic/488d2636f6ac8dee9916d85a5f66298c

https://community.igniterealtime.org/thread/52276

0 Karma
Get Updates on the Splunk Community!

See just what you’ve been missing | Observability tracks at Splunk University

Looking to sharpen your observability skills so you can better understand how to collect and analyze data from ...

Weezer at .conf25? Say it ain’t so!

Hello Splunkers, The countdown to .conf25 is on-and we've just turned up the volume! We're thrilled to ...

How SC4S Makes Suricata Logs Ingestion Simple

Network security monitoring has become increasingly critical for organizations of all sizes. Splunk has ...