Discussions
Categories
- 196.8K All Categories
- 2.2K Data
- 238 Big Data Appliance
- 1.9K Data Science
- 450.3K Databases
- 221.7K General Database Discussions
- 3.8K Java and JavaScript in the Database
- 31 Multilingual Engine
- 550 MySQL Community Space
- 478 NoSQL Database
- 7.9K Oracle Database Express Edition (XE)
- 3K ORDS, SODA & JSON in the Database
- 544 SQLcl
- 4K SQL Developer Data Modeler
- 187K SQL & PL/SQL
- 21.3K SQL Developer
- 295.8K Development
- 17 Developer Projects
- 138 Programming Languages
- 292.5K Development Tools
- 107 DevOps
- 3.1K QA/Testing
- 646K Java
- 28 Java Learning Subscription
- 37K Database Connectivity
- 155 Java Community Process
- 105 Java 25
- 22.1K Java APIs
- 138.1K Java Development Tools
- 165.3K Java EE (Java Enterprise Edition)
- 18 Java Essentials
- 160 Java 8 Questions
- 86K Java Programming
- 80 Java Puzzle Ball
- 65.1K New To Java
- 1.7K Training / Learning / Certification
- 13.8K Java HotSpot Virtual Machine
- 94.3K Java SE
- 13.8K Java Security
- 204 Java User Groups
- 24 JavaScript - Nashorn
- Programs
- 437 LiveLabs
- 38 Workshops
- 10.2K Software
- 6.7K Berkeley DB Family
- 3.5K JHeadstart
- 5.7K Other Languages
- 2.3K Chinese
- 171 Deutsche Oracle Community
- 1.1K Español
- 1.9K Japanese
- 232 Portuguese
IO Error Establishing connection Network Adapter Could not

neeshu
Member Posts: 18
I am now getting 12514 error please read the bottom of the page if you wish to help thanks
Hi,
I have downloaded sql developer 3.1.07 and jdk 7u4 i am running oracle 10g on red hat linux
The sql plus works fine but when i tried to connect with sql developer software it gave me an error saying
Status: Failure - Test Failed: Io exception: The Network Adapter could not establish the connection
i tried pinging the localhost it was fine
but when i tried pinging
tnsping localhost <-- no listner
tnsping orcl <-- no listner
i got above errors
how should i approach the problem please help me i am new to oracle
*********************************************************************
One of the solutions said that you need to copy everything from listener.ora but i it didn't work am i doing things right
sid -->PLSExtProc
host--> localhost.localdomain
**********************************************************************
# listener.ora Network Configuration File: /u01/app/oracle/product/10.2.0/db_1/network/admin/listener.ora
# Generated by Oracle configuration tools.
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = /u01/app/oracle/product/10.2.0/db_1)
(PROGRAM = extproc)
)
)
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost.localdomain)(PORT = 1521))
)
)
Edited by: 891355 on May 17, 2012 6:47 AM
Edited by: neeshu on May 19, 2012 11:28 AM
Hi,
I have downloaded sql developer 3.1.07 and jdk 7u4 i am running oracle 10g on red hat linux
The sql plus works fine but when i tried to connect with sql developer software it gave me an error saying
Status: Failure - Test Failed: Io exception: The Network Adapter could not establish the connection
i tried pinging the localhost it was fine
but when i tried pinging
tnsping localhost <-- no listner
tnsping orcl <-- no listner
i got above errors
how should i approach the problem please help me i am new to oracle
*********************************************************************
One of the solutions said that you need to copy everything from listener.ora but i it didn't work am i doing things right
sid -->PLSExtProc
host--> localhost.localdomain
**********************************************************************
# listener.ora Network Configuration File: /u01/app/oracle/product/10.2.0/db_1/network/admin/listener.ora
# Generated by Oracle configuration tools.
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = /u01/app/oracle/product/10.2.0/db_1)
(PROGRAM = extproc)
)
)
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost.localdomain)(PORT = 1521))
)
)
Edited by: 891355 on May 17, 2012 6:47 AM
Edited by: neeshu on May 19, 2012 11:28 AM
Tagged:
Best Answer
-
Providing both database and listner are running you should be able to connect through sql developer, specifying localhost.localdomain, 1521 and orcl in the connection properties.
You can set up the listener and database to start on boot. This is well documented in the manuals and around the web. Try googling "autostart oracle database linux" and "autostart listener linux"
Answers
-
It likely that SQL*PLus is using a direct connection to ORACLE_SID and isn't using a listener. To use JDBC connections through SQL Developer you need a listener.
As the oracle user on the database server, trylsnrctl status
If that shows that a listener isn't running, trylsnrctl start
-
hi,
i have install sql developer in window 7 and tried to create database but its show error as Status : Failure -Test failed: IO Error: The Network Adapter could not establish the connection
please help me out.
Thanks & Regards,
Jeevan -
Thanks a lot Jim I will try that and let you know if it worked or not
-
I ran the status which gave an error saying no listener then i ran the start lsnrctl command and it worked after which when I tried connecting with SQLDeveloper
I was given an error saying
Status : Failure -Test failed: Listener refused the connection with the following error:
ORA-12505, TNS:listener does not currently know of SID given in connect descriptor -
Hi,
Now that your listener is running, executing lsnrctl status will show you all available services. From your earlier post I would guess ORCL may not be there, but possibly XE ? Hopefully you will see a familiar service in the list. If not, since this is the SQL Developer forum, let's try investigating this problem with the SQL Developer tool itself.
Right click on the connection of interest in the Navigator tree and select Properties. I assume the Connection Type is Basic. If you switch to a Connection Type of TNS, the Network Alias drop-down should display the available TNS names of the services your listener knows about. The list of names should be similar to what lsnrctl status displays.
If you are unable to connect using any of these TNS Aliases, make sure you don't have multiple tnsnames.ora* files. SQL Developer's tendency to read all such files can cause confusion. If this is the case remove the extra files or, if they are in multiple directories, at least use Tools|Preferences|Database|Advanced|Tnsnames Directory to limit the search to a single directory. If none of this works, then perhaps your tnsnames is not configured correctly and you need to use something like the Net Configuration Assistant to correct it.
Hope this helps,
Gary -
Thanks Gary I tried the lsnrctl status command and it gave me the listener as PLSExtProc
Then when i tried logging in with the tns connection type there were 3 tns name servers ==> Book orcl and PLSExtProc
I went to the tnsnames.ora and removed the code of book and the other name server with just orcl left and left the backup on desktop
but this time, sql developer showed me 2 instances of orcl and the other two book and plsextproc as well
I am getting 12514 error should i post the tnsname.ora file here
I tried setting the tools>database>preferences to admin folder but it picked up multiple instances of the tnsnames now I have 6 tns names ==> 2 book 2 orcl and 2 prlsext
Here is tnsnames.ora file contents
# tnsnames.ora Network Configuration File: /u01/app/oracle/product/10.2.0/db_1/network/admin/tnsnames.ora
# Generated by Oracle configuration tools.
BOOK =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost.localdomain)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = book)
)
)
ORCL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost.localdomain)(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 thank you
Edited by: neeshu on May 19, 2012 11:25 AM -
It may be that your databaase service isn't running, and is therefore not registered with the listener.
In a command window, trysqlplus "/ as sysdba" SQL> startup exit
Edited by: Jim Smith on May 20, 2012 1:12 PM -
hi jim i am able to connect to database using sqlplus startup works fine and so does shut down do you think the problem has something to do with red hat
-
Start up the database, then wait a minute of so, and then try 'lsnrctl status', and post the output here.
Once the database is up, it should resgister itself as a service with the listener and you should be able to see what you should be trying to connect to.
Note that on Linux, SIDs are case sensitive,so ORCL isn't the same as orcl. Services should be case INsensitive. -
This is the error i got
LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 20-MAY-2012 18:29:14
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
Linux Error: 111: Connection refused
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost.localdomain)(PORT=1521)))
TNS-12541: TNS:no listener
TNS-12560: TNS:protocol adapter error
TNS-00511: No listener
Linux Error: 111: Connection refused
here is the screenshot
[http://imageshack.us/photo/my-images/717/screenshotxls.jpg/]
Edited by: neeshu on May 20, 2012 6:13 AM
This discussion has been closed.