Delphix Products

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

    Posted 08-12-2015 06:45:00 PM
    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>



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

    Posted 08-14-2015 09:30:00 AM
    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


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

    Posted 08-14-2015 10:09:00 AM
    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


  • 4.  RE: Cannot get Connection from Datasource: java.sql.SQLRecoverableException: IO Error: The Network Adapter could not establish
    Best Answer

    Posted 08-14-2015 12:47:00 PM
    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.