Home » SQL & PL/SQL » Client Tools » SQL Developer error : IO Error : The Network Adapter could not establish the connection
SQL Developer error : IO Error : The Network Adapter could not establish the connection [message #547583] Wed, 14 March 2012 22:05 Go to next message
tedlaraghu
Messages: 51
Registered: December 2011
Member
Hi all,

I am getting the following error when trying to connect from sql developer, I can connect through command prompt and sqlplus to scott schema.

Error :
-------
An error was encountered performing the requested operation.
IO Error : The Network Adapter could not establish the connection

Vendor code 17002

Login details used in sqldeveloper
----------------------------------
Host name : 192.168.2.2
Port : 1521
service name : orcl


from SQL PLUS
---------------
select * from v$instance;

INSTANCE_NUMBER INSTANCE_NAME
--------------- ----------------
HOST_NAME
----------------------------------------------------------------
VERSION STARTUP_T STATUS PAR THREAD# ARCHIVE LOG_SWITCH_WAIT
----------------- --------- ------------ --- ---------- ------- ---------------
LOGINS SHU DATABASE_STATUS INSTANCE_ROLE ACTIVE_ST BLO
---------- --- ----------------- ------------------ --------- ---
1 orcl
HOME-12A1C66C81
10.2.0.1.0 15-MAR-12 OPEN NO 1 STOPPED
ALLOWED NO ACTIVE PRIMARY_INSTANCE NORMAL NO

tnsnames.ora
-------------
# tnsnames.ora Network Configuration File: C:\oracle\product\10.2.0\db_1\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.

ORCL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.2.2)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)

EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)

Please help me in finding the issue.

Thanks
Raghu
Re: SQL Developer error : IO Error : The Network Adapter could not establish the connection [message #547586 is a reply to message #547583] Wed, 14 March 2012 22:54 Go to previous messageGo to next message
BlackSwan
Messages: 21941
Registered: January 2009
Senior Member
>An error was encountered performing the requested operation.
>IO Error : The Network Adapter could not establish the connection

Oracle errors have numbers like ORA-01555 & message.
If above is all you get then you have OS/Networking mis-configuration.

Windows OS? Which version & Edition?

when was last time SQL*Net worked without error?
What changed since then?
Re: SQL Developer error : IO Error : The Network Adapter could not establish the connection [message #547668 is a reply to message #547586] Thu, 15 March 2012 11:33 Go to previous messageGo to next message
tedlaraghu
Messages: 51
Registered: December 2011
Member
Windows version is Microsoft Windows XP Professional Version 2002 Service Pack 2

This is the first time trying to connect to sql developer.

Re: SQL Developer error : IO Error : The Network Adapter could not establish the connection [message #547669 is a reply to message #547668] Thu, 15 March 2012 11:45 Go to previous messageGo to next message
BlackSwan
Messages: 21941
Registered: January 2009
Senior Member
Is OS Service for listener running?

open Command Window on DB Server & issue following OS commands

lsnrctl start
lsnrctl status
lsnrctl service

COPY commands & results then PASTE all back here
Re: SQL Developer error : IO Error : The Network Adapter could not establish the connection [message #547670 is a reply to message #547669] Thu, 15 March 2012 12:00 Go to previous messageGo to next message
tedlaraghu
Messages: 51
Registered: December 2011
Member

C:\Documents and Settings\admin>lsnrctl service

LSNRCTL for 32-bit Windows: Version 10.2.0.1.0 - Production on 15-MAR-2012 22:25:24

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

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1)))
TNS-12541: TNS:no listener
TNS-12560: TNS:protocol adapter error
TNS-00511: No listener
32-bit Windows Error: 2: No such file or directory
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.2.2)(PORT=1521)))
TNS-12560: TNS:protocol adapter error
TNS-00538: Message 538 not found; product=NETWORK; facility=TNS

32-bit Windows Error: 65: Unknown error



C:\Documents and Settings\admin>lsnrctl status

LSNRCTL for 32-bit Windows: Version 10.2.0.1.0 - Production on 15-MAR-2012 22:21
:02

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

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1)))
TNS-12541: TNS:no listener
TNS-12560: TNS:protocol adapter error
TNS-00511: No listener
32-bit Windows Error: 2: No such file or directory
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.2.2)(PORT=1521))
)
TNS-12560: TNS:protocol adapter error
TNS-00538: Message 538 not found; product=NETWORK; facility=TNS

32-bit Windows Error: 65: Unknown error



C:\Documents and Settings\admin>lsnrctl start

LSNRCTL for 32-bit Windows: Version 10.2.0.1.0 - Production on 15-MAR-2012 22:28:26

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

Starting tnslsnr: please wait...

TNSLSNR for 32-bit Windows: Version 10.2.0.1.0 - Production
System parameter file is C:\oracle\product\10.2.0\db_1\network\admin\listener.ora
Log messages written to C:\oracle\product\10.2.0\db_1\network\log\listener.log
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC1ipc)))
Error listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.2.2)(PORT=1521)))
TNS-12545: Connect failed because target host or object does not exist
TNS-12560: TNS:protocol adapter error
TNS-00515: Connect failed because target host or object does not exist
32-bit Windows Error: 49: Unknown error

Listener failed to start. See the error message(s) above...




Re: SQL Developer error : IO Error : The Network Adapter could not establish the connection [message #547671 is a reply to message #547670] Thu, 15 March 2012 12:06 Go to previous messageGo to next message
BlackSwan
Messages: 21941
Registered: January 2009
Senior Member
Is OS Service for listener running?
Is OS Service for listener running?
Is OS Service for listener running?
Is OS Service for listener running?
Re: SQL Developer error : IO Error : The Network Adapter could not establish the connection [message #547672 is a reply to message #547671] Thu, 15 March 2012 12:07 Go to previous messageGo to next message
tedlaraghu
Messages: 51
Registered: December 2011
Member
How can I check that.
Re: SQL Developer error : IO Error : The Network Adapter could not establish the connection [message #547673 is a reply to message #547672] Thu, 15 March 2012 12:18 Go to previous messageGo to next message
tedlaraghu
Messages: 51
Registered: December 2011
Member
In services.msc,
OracleOraDb10g_home1TNSListener has not started,
when I try to start it fails with error message
"The OracleOraDb10g_home1TNSListener service on Local computer started and then stopped. Some services stop automatically
if they no work to do, for example, the performance Logs and alerts service"
Re: SQL Developer error : IO Error : The Network Adapter could not establish the connection [message #547674 is a reply to message #547673] Thu, 15 March 2012 12:20 Go to previous messageGo to next message
BlackSwan
Messages: 21941
Registered: January 2009
Senior Member
It appears that you have OS/Networking mis-configuration.
Oracle is victim; not culprit.
root cause & solution are external to Oracle.

when was last time SQL*Net worked without error?
what changed since then?
Re: SQL Developer error : IO Error : The Network Adapter could not establish the connection [message #547675 is a reply to message #547674] Thu, 15 March 2012 12:23 Go to previous messageGo to next message
tedlaraghu
Messages: 51
Registered: December 2011
Member
I don't remember when SQL*Net worked last time, will uninstalling oracle and removing all entries of oracle from regedit help.
Re: SQL Developer error : IO Error : The Network Adapter could not establish the connection [message #547676 is a reply to message #547675] Thu, 15 March 2012 12:26 Go to previous messageGo to next message
BlackSwan
Messages: 21941
Registered: January 2009
Senior Member
>I don't remember when SQL*Net worked last time,
>will uninstalling oracle and removing all entries of oracle from regedit help.
I doubt uninstall will change your reality.

http://www.lmgtfy.com/?q=oracle+windows+listener+service
Re: SQL Developer error : IO Error : The Network Adapter could not establish the connection [message #547812 is a reply to message #547676] Fri, 16 March 2012 22:02 Go to previous message
tedlaraghu
Messages: 51
Registered: December 2011
Member
Earlier I had only Administrator account in my laptop, I have uninstalled oracle, deleting the oracle folders and oracle entries from regedit.

I have added one more account and in that account I have installed oracle and sql developer again.

Now I can connect to oracle from sqldeveloper.

Thanks
Raghu
Previous Topic: SQL tracker problem monitoring w3wp.exe
Next Topic: Searching by Row problem
Goto Forum:
  


Current Time: Thu Apr 17 22:42:34 CDT 2014

Total time taken to generate the page: 0.13439 seconds