Discussions
Categories
- 196.9K All Categories
- 2.2K Data
- 239 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
- 546 SQLcl
- 4K SQL Developer Data Modeler
- 187K SQL & PL/SQL
- 21.3K SQL Developer
- 295.9K Development
- 17 Developer Projects
- 138 Programming Languages
- 292.6K 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
- 442 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
Re: STATUS = UNKNOWN in LSNRCTL STATUS.

I use oracle client and ODBC but still find no luck.
while testing connection via oracle wire protocol
it gives error like :[ oracle wire protocol driver]
" Connection refused . Verify hostname or port number. "
[ODBC oracle wire protocol driver] [oracle]
"ORA-12203: unable to connect destination"
Answers
-
how can we reproduce what you report?
-
Hi,
Explain how you are trying to connect
Heard of this SQLDEVELOPER, try and find how easy it is to connect
Regards
Yoonas
-
The error messages are quite explicit and also easy to understand.
You need to figure out if
a. You have the network configured correctly
b. You have the connect-string configured correctly
Hemant K Chitale
-
are you able to tnsping your tns string ? (it will be in your tnanames.ora file). If no then you have problem with connection settings, correct that.
Also what is the output of lsnrctl status command?
Onkar
-
Output of tnsping and lsnrctl:
************************************************************************************************************
[[email protected] dbhome_1]$ tnsping ACDM
TNS Ping Utility for Linux: Version 11.2.0.1.0 - Production on 29-APR-2014 15:06:00
Copyright (c) 1997, 2009, Oracle. All rights reserved.
Used parameter files:
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = LOM-NEYTR-RHEL-NEW1)(PORT = 1521))) (CONNECT_DATA = (SERVICE_NAME = ACDM)))
OK (0 msec)
[[email protected] dbhome_1]$ lsnrctl statusLSNRCTL for Linux: Version 11.2.0.1.0 - Production on 29-APR-2014 15:16:15
Copyright (c) 1991, 2009, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC0)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 11.2.0.1.0 - Production
Start Date 26-APR-2014 14:48:51
Uptime 3 days 0 hr. 27 min. 24 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /home/oracle/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora
Listener Log File /home/oracle/app/oracle/product/11.2.0/diag/tnslsnr/LOM-NEYTR-RHEL-NEW1/listener/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC0)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=LOM-NEYTR-RHEL-NEW1)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=LOM-NEYTR-RHEL-NEW1)(PORT=2481))(PROTOCOL_STACK=(PRESENTATION=GIOP)(SESSION=RAW)))
Services Summary...
Service "ACDM" has 2 instance(s).
Instance "ACDM", status UNKNOWN, has 1 handler(s) for this service...
Instance "ACDM", status READY, has 1 handler(s) for this service...
Service "PLSExtProc" has 1 instance(s).
Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully