[Solved] IO Error The Network Adapter could not establish the connection

Problem:

An error was encountered performing the requested operation:IO Error: The Network Adapter coule not establish the connection Vendor code 17002.

Sql error

 

Solution:

Ensure oracle or mysql server is running, if it is not running then start the server by the below command,
lsnrctl start (to start the sql in other system).
Now you can connect without any issues.

 

Hope this helps…..!! If you have any other solutions kindly post in the commands section.

 

2,207 total views, 6 views today

4 comments

  • Marshall Anako

    The Network Adapter could not establish the connection. I still have the error for some reason after i went through your steps

  • Marshall Anako

    the same error still show could not establish connection.

  • Amrita

    In my case, the listener is getting connected..
    $ ./lsnrctl status

    LSNRCTL for Linux: Version 12.1.0.1.0 – Production on 17-JUN-2015 14:50:32

    Copyright (c) 1991, 2013, Oracle. All rights reserved.

    Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1523)))
    STATUS of the LISTENER
    ————————
    Alias LISTENER
    Version TNSLSNR for Linux: Version 12.1.0.1.0 – Production
    Start Date 17-JUN-2015 13:25:56
    Uptime 0 days 1 hr. 24 min. 36 sec
    Trace Level off
    Security ON: Local OS Authentication
    SNMP OFF
    Listener Parameter File /home/Appladmin/app1/Appladmin/product/12.1.0/dbhome_1/network/admin/listener.ora
    Listener Log File /home/Appladmin/app1/Appladmin/diag/tnslsnr/hotsname/listener/alert/log.xml
    Listening Endpoints Summary…
    (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1523)))
    (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=xxx.xx.xxx.xx)(PORT=1523)))
    (DESCRIPTION=(ADDRESS=(PROTOCOL=tcps)(HOST=hostname)(PORT=5501))(Security=(my_wallet_directory=/home/Appladmin/app1/Appladmin/product/12.1.0/dbhome_1/admin/orcle/xdb_wallet))(Presentation=HTTP)(Session=RAW))
    Services Summary…
    Service “orcle” has 2 instance(s).
    Instance “orcle”, status UNKNOWN, has 1 handler(s) for this service…
    Instance “orcle”, status READY, has 1 handler(s) for this service…
    Service “orcleXDB” has 1 instance(s).
    Instance “orcle”, status READY, has 1 handler(s) for this service…
    Service “pdborcl” has 1 instance(s).
    Instance “orcle”, status READY, has 1 handler(s) for this service…
    The command completed successfully

    Still facing the same error..

Leave a Reply

Your email address will not be published. Required fields are marked *