Skip to Main Content

SQL Developer

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

I cannot locate a listener - Error Vendor Code 17002

699224May 2 2012 — edited May 2 2012
I cannot locate a listener when using SQL Developer by connecting to a database

Using Windows XP

SQL DEVELOPER VERSION - 3.1.07

1) Error when trying to connect the database:
An Error was encountered performing the request operations.
IO Error, The network adapter could not establish the connection. Vendor Code 17002


2) I tried to start the listener - LSNRCTL START
I get this Failed to start service.error 3
TNS - 12560 : TNS protocol adapter error
TNS -00530 - Protocol Adapter error

3) I have in LIstener.ora
Listener2=
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(Key = EXTPROC1))
(ADDRESS = (PROTOCOL = TCP) HOST = kevin)(Port = 1521))
)
)
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = muneo.oracle.com)
(ORACLE_HOME = C:\oracle\product\10.2.0\db_4)
(SID_NAME = muneo)
)
)
LISTENER =
(DESCRIPTION =
(ADDRESS = PROTOCOL = TCP)(HOST = kevin)(Port = 1521))
)

TNSNAME.ORA
(DESCIPTION -
(ADDRESS = (PROTOCOL = TCP)(HOST= Kevin)
(Port =1521))
CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = Muneo)
)
)
EXPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY=EXTPROC1))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)


Thank you in advance for your time.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 30 2012
Added on May 2 2012
1 comment
1,148 views