Cannot get Connection from Datasource: java.sql.SQLRecoverableException: IO Error: The Network Adapter could not establish

  • 0
  • 1
  • Question
  • Updated 3 years ago
  • Answered
  • (Edited)
Discovery of 2 Node rac 11Gr2 has successfully done .Under enviroment cluster nodes+ jdbc connect string seems also ok.

2 NODE RAC has scan name which can be resolved via DNS server and delphix engine also has this dns and able to resolve properly.

While I am trying to add dsource  it generates error below:

Cannot get Connection from Datasource: java.sql.SQLRecoverableException: IO Error: The Network Adapter could not establish.

However manually testing the connection is successful as below:

Used TNSNAMES adapter to resolve the aliasAttempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)
(HOST = racnode-cluster-scan)(PORT = 1521))) (CONNECT_DATA = (SERVICE_NAME = rac
db.idevelopment.info)))
OK (100 msec)

C:\WINDOWS\system32>sqlplus delphix/delphix@RACDB

SQL*Plus: Release 11.2.0.1.0 Production on Wed Aug 12 15:28:03 2015

Copyright (c) 1982, 2010, Oracle.  All rights reserved.


Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management,
OLAP,
Data Mining and Real Application Testing options

SQL>

Photo of cico

cico

  • 180 Points 100 badge 2x thumb

Posted 3 years ago

  • 0
  • 1
Photo of Sandro Latini

Sandro Latini, Employee

  • 350 Points 250 badge 2x thumb
Hi Cico,
Could you please check the following settings and see if anything will help you to solve this issue?

- TNS Lister instance is down in the DB server 
- Privileges are not granted for your credentials
- Port 1521 port is not visible/available to you from the Delphix Engine
- Host name is not the same in both listener.ora and tnsnames.ora files

Regards
Sandro
Photo of Adam Bowen

Adam Bowen, Official Rep

  • 17,420 Points 10k badge 2x thumb
Hey Cico. Was anything else going on on your engine? Can you try again? If that still fails, can you attach the error log?
  1. Help
  2. Support Logs
  3. Download
  4. Extract the tgz
  5. log->mgmt_log->error.log
Photo of cico

cico

  • 180 Points 100 badge 2x thumb
Hi Adam,

DNS order under Delphix Engine was causing the timeout initially.Once after changing the dns order first dns response was able to resolve the connectivity issues.I have not make any changes under Cluster Database as configuration was fine.So I can confirm that Sandro's items were not the case for this issue.