Re: STATUS = UNKNOWN in LSNRCTL STATUS.

2650954

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"

sb92075

how can we reproduce what you report?

yoonas

Hi,

Explain how you are trying to connect

Heard of this SQLDEVELOPER, try and find how easy it is to connect

Oracle SQL Developer</title><meta name="Title" content="Oracle SQL Developer"><meta n…

Regards

Yoonas

Hemant K Chitale

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

onkar.nath

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

2650954

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 status

LSNRCTL 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