OraFAQ Forum: Client Tools » SQL Developer error : IO Error : The Network Adapter could not establish the connection

Home » Other » Client Tools » SQL Developer error : IO Error : The Network Adapter could not establish the connection

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

SQL Developer error : IO Error : The Network Adapter could not establish the connection [message #547583]

Wed, 14 March 2012 22:05

tedlaraghu
Messages: 56
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

Report message to a moderator

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

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

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?

Report message to a moderator

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

tedlaraghu
Messages: 56
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.

Report message to a moderator

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

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

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

Report message to a moderator

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

tedlaraghu
Messages: 56
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...

Report message to a moderator

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

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

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?

Report message to a moderator

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

tedlaraghu
Messages: 56
Registered: December 2011

Member

How can I check that.

Report message to a moderator

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

tedlaraghu
Messages: 56
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"

Report message to a moderator

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

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

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?

Report message to a moderator

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

tedlaraghu
Messages: 56
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.

Report message to a moderator

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

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

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

Report message to a moderator

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

tedlaraghu
Messages: 56
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

Report message to a moderator

Previous Topic:	SQL tracker problem monitoring w3wp.exe
Next Topic:	Searching by Row problem

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Jan 30 11:35:17 CST 2025