| The Network Adapter could not establish the connection [message #403550] |
Sat, 16 May 2009 17:11  |
ashutoshsharma
Messages: 7
Registered: May 2009
|
Junior Member |
|
|
My installation happened properly. SQL Plus is getting opened without any issues. But i am not able to connect from Squirrel SQL. I am getting "The Network Adapter could not establish the connection" error.
This is what i am getting on the command prompt:
D:\app\product\11.1.0\db_1\BIN>lsnrctl start
LSNRCTL for 64-bit Windows: Version 11.1.0.6.0 - Production on 16-MAY-2009 17:54:14
Copyright (c) 1991, 2007, Oracle. All rights reserved.
Starting tnslsnr: please wait...
TNS-12560: TNS:protocol adapter error
TNS-00530: Protocol adapter error
D:\app\product\11.1.0\db_1\BIN>lsnrctl status
LSNRCTL for 64-bit Windows: Version 11.1.0.6.0 - Production on 16-MAY-2009 17:56:16
Copyright (c) 1991, 2007, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC)))
TNS-12541: TNS:no listener
TNS-12560: TNS:protocol adapter error
TNS-00511: No listener
64-bit Windows Error: 2: No such file or directory
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.2.4)(PORT=1521)))
TNS-12541: TNS:no listener
TNS-12560: TNS:protocol adapter error
TNS-00511: No listener
64-bit Windows Error: 61: Unknown error
D:\app\product\11.1.0\db_1\BIN>LSNRCTL
LSNRCTL for 64-bit Windows: Version 11.1.0.6.0 - Production on 16-MAY-2009 17:58:38
Copyright (c) 1991, 2007, Oracle. All rights reserved.
Welcome to LSNRCTL, type "help" for information.
LSNRCTL> services
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC)))
TNS-12541: TNS:no listener
TNS-12560: TNS:protocol adapter error
TNS-00511: No listener
64-bit Windows Error: 2: No such file or directory
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.2.4)(PORT=1521)))
TNS-12541: TNS:no listener
TNS-12560: TNS:protocol adapter error
TNS-00511: No listener
64-bit Windows Error: 61: Unknown error
LSNRCTL>
This is my tnsnames.ora
# tnsnames.ora Network Configuration File: D:\app\product\11.1.0\db_1\NETWORK\ADMIN\tnsnames.ora
# Generated by Oracle configuration tools.
LISTENER_ORCL =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.2.4)(PORT = null))
ORCL =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.2.4)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.2.4)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)
and this is listener.ora
# listener.ora Network Configuration File: D:\app\product\11.1.0\db_1\network\admin\listener.ora
# Generated by Oracle configuration tools.
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.2.4)(PORT = 1521))
)
)
This is when the TNSListener service is not started.
After starting it, at the command prompt-i get this:
D:\app\product\11.1.0\db_1\BIN>lsnrctl status
LSNRCTL for 64-bit Windows: Version 11.1.0.6.0 - Production on 16-MAY-2009 18:13:05
Copyright (c) 1991, 2007, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for 64-bit Windows: Version 11.1.0.6.0 - Production
Start Date 16-MAY-2009 18:12:57
Uptime 0 days 0 hr. 0 min. 9 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File D:\app\product\11.1.0\db_1\network\admin\listener.ora
Listener Log File d:\app\diag\tnslsnr\Ayush-PC\listener\alert\log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROCipc)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.2.4)(PORT=1521)))
The listener supports no services
The command completed successfully
D:\app\product\11.1.0\db_1\BIN>lsnrctl
LSNRCTL for 64-bit Windows: Version 11.1.0.6.0 - Production on 16-MAY-2009 18:13:15
Copyright (c) 1991, 2007, Oracle. All rights reserved.
Welcome to LSNRCTL, type "help" for information.
LSNRCTL> start
TNS-01106: Listener using listener name LISTENER has already been started
LSNRCTL>
But still i am not able to connect from SQuirrel SQL and the error is still the same:
java.sql.SQLRecoverableException: Io exception: The Network Adapter could not establish the connection
at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:101)
at oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:112)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:173)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:229)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:458)
at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:411)
at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:490)
at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:202)
at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:33)
at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:465)
at net.sourceforge.squirrel_sql.fw.sql.SQLDriverManager.getConnection(SQLDriverManager.java:133)
at net.sourceforge.squirrel_sql.client.mainframe.action.OpenConnectionCommand.execute(OpenConnectionCommand.java:97)
at net.sourceforge.squirrel_sql.client.mainframe.action.ConnectToAliasCommand$SheetHandler.run(ConnectToAliasCommand.java:280)
at net.sourceforge.squirrel_sql.fw.util.TaskExecuter.run(TaskExecuter.java:82)
at java.lang.Thread.run(Unknown Source)
Also attaching the screen shot from Oracle net manager output
[Updated on: Sat, 16 May 2009 17:32] Report message to a moderator |
|
|
|
|
|
|
|
|
|
| Re: The Network Adapter could not establish the connection [message #403555 is a reply to message #403550] |
Sat, 16 May 2009 18:09  |
 |
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
|
Senior Member |
|
|
You need to help us by following the Posting Guidelines as stated below.
http://www.orafaq.com/forum/t/88153/0/
Go to the URL above click the link "Posting Guidelines"
Go to the section labeled "Practice" & do as directed.
I am confused about what you claim is the problem.
>My installation happened properly.
>SQL Plus is getting opened without any issues.
>But i am not able to connect from Squirrel SQL. I am getting "The Network Adapter could not establish the connection" error.
>This is the screen shot of DataBase configuration assistant
This screen shot is unreadable.
If you have a "installation happened properly.", why are you running DBCA again?
Using SQL*Plus do CUT of whole session providing proof SQL*Net is properly configured & operational.
Post tail end of listener.log file.
[Updated on: Sat, 16 May 2009 18:10] Report message to a moderator |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
