Home » RDBMS Server » Server Administration » The Network Adapter could not establish the connection (Oracle 11g Windows Vista 64 Bit)
The Network Adapter could not establish the connection [message #403550] Sat, 16 May 2009 17:11 Go to next message
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 #403551 is a reply to message #403550] Sat, 16 May 2009 17:21 Go to previous messageGo to next message
BlackSwan
Messages: 25035
Registered: January 2009
Location: SoCal
Senior Member
What ORA or TNS error number?

Post tail end of listener.log file.

[Updated on: Sat, 16 May 2009 17:36]

Report message to a moderator

Re: The Network Adapter could not establish the connection [message #403552 is a reply to message #403551] Sat, 16 May 2009 17:43 Go to previous messageGo to next message
ashutoshsharma
Messages: 7
Registered: May 2009
Junior Member
That one is not helpful for me and doesn't solve the problem
Re: The Network Adapter could not establish the connection [message #403554 is a reply to message #403550] Sat, 16 May 2009 17:52 Go to previous messageGo to next message
ashutoshsharma
Messages: 7
Registered: May 2009
Junior Member
This is the screen shot of DataBase configuration assistant
Re: The Network Adapter could not establish the connection [message #403555 is a reply to message #403550] Sat, 16 May 2009 18:09 Go to previous messageGo to next message
BlackSwan
Messages: 25035
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

Re: The Network Adapter could not establish the connection [message #403556 is a reply to message #403555] Sat, 16 May 2009 18:41 Go to previous messageGo to next message
ashutoshsharma
Messages: 7
Registered: May 2009
Junior Member
i m trying to find out some thing on my own. That's why i m running DBCA.
Here is the output of SQL Plus
SQL> help index

Enter Help [topic] for help.

@ COPY PAUSE SHUTDOWN
@@ DEFINE PRINT SPOOL
/ DEL PROMPT SQLPLUS
ACCEPT DESCRIBE QUIT START
APPEND DISCONNECT RECOVER STARTUP
ARCHIVE LOG EDIT REMARK STORE
ATTRIBUTE EXECUTE REPFOOTER TIMING
BREAK EXIT REPHEADER TTITLE
BTITLE GET RESERVED WORDS (SQL) UNDEFINE
CHANGE HELP RESERVED WORDS (PL/SQL) VARIABLE
CLEAR HOST RUN WHENEVER OSERROR
COLUMN INPUT SAVE WHENEVER SQLERROR
COMPUTE LIST SET XQUERY
CONNECT PASSWORD SHOW


SQL> clear
SQL> select sysdate from dual;

SYSDATE
---------
16-MAY-09
  • Attachment: DBCA.jpg
    (Size: 125.01KB, Downloaded 195 times)
Re: The Network Adapter could not establish the connection [message #403557 is a reply to message #403550] Sat, 16 May 2009 18:50 Go to previous messageGo to next message
BlackSwan
Messages: 25035
Registered: January 2009
Location: SoCal
Senior Member
>i m trying to find out some thing on my own.
I applaud your curiosity.

The whole Oracle documentation set can be found at http://tahiti.oracle.com

I suggest you spend more time Reading The Fine Manuals & less time blindly pointing & clicking.

Good Luck!
Re: The Network Adapter could not establish the connection [message #403608 is a reply to message #403557] Sun, 17 May 2009 09:06 Go to previous messageGo to next message
ashutoshsharma
Messages: 7
Registered: May 2009
Junior Member
There is not much help from those also.
Re: The Network Adapter could not establish the connection [message #403609 is a reply to message #403608] Sun, 17 May 2009 09:17 Go to previous messageGo to next message
BlackSwan
Messages: 25035
Registered: January 2009
Location: SoCal
Senior Member
ashutoshsharma wrote on Sun, 17 May 2009 07:06
There is not much help from those also.


Folks who know much more Oracle than you disagree,
Re: The Network Adapter could not establish the connection [message #403614 is a reply to message #403609] Sun, 17 May 2009 10:31 Go to previous messageGo to next message
ashutoshsharma
Messages: 7
Registered: May 2009
Junior Member
i have tried the jdbc program also but that is also giving me the same problem.
Re: The Network Adapter could not establish the connection [message #403616 is a reply to message #403550] Sun, 17 May 2009 10:40 Go to previous message
BlackSwan
Messages: 25035
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.
Previous Topic: tempfile
Next Topic: How to change partitioning (range-list) to (range)?
Goto Forum:
  


Current Time: Sat Dec 03 18:08:30 CST 2016

Total time taken to generate the page: 0.24931 seconds