RE: Getting repeated no listener error in the alert log

From: Iggy Fernandez <iggy_fernandez_at_hotmail.com>
Date: Fri, 12 Jun 2015 21:27:22 -0700
Message-ID: <BLU179-W542E2A799B65923061382AEBBA0_at_phx.gbl>

One of the db links perhaps?
select db_link, host from dba_db_links
Iggy

From: ashoke.k.mandal_at_medtronic.com
To: oracle-l-bounce_at_freelists.org; oracle-l_at_freelists.org Subject: Getting repeated no listener error in the alert log Date: Sat, 13 Jun 2015 03:48:14 +0000

Hello All,
 
I am repeatedly receiving the following error into the alert log of the database on phx11cn1 server. Does it mean some process is trying to connect a database
 on the HOST=10.72.10.53? How to identify which process is trying to do that. The listener on HOST=10.72.10.53 has the port as 11021 and not sure what process is trying to use a hardcoded listener port as 1521 to connect to the database on HOST=10.72.10.53.

 
Any idea how to identify what process is generating this error message.
 
Thanks,
Ashoke
 
Repeated error message coming to alert log on phx11cn1:
Fatal NI connect error 12541, connecting to:
(DESCRIPTION=(CONNECT_DATA=(SERVICE_NAME=)(CID=(PROGRAM=oracle)(HOST=phx11cn1)(USER=oracle)))(ADDRESS=(PROTOCOL=TCP)(HOST=10.72.10.53)(PORT=1521)))
 
  VERSION INFORMATION:
        TNS for Solaris: Version 11.2.0.3.0 - Production
        TCP/IP NT Protocol Adapter for Solaris: Version 11.2.0.3.0 - Production
  Time: 12-JUN-2015 17:15:29
  Tracing not turned on.
  Tns error struct:
    ns main err code: 12541
 
TNS-12541: TNS:no listener
    ns secondary err code: 12560
    nt main err code: 511
 
TNS-00511: No listener
    nt secondary err code: 146
    nt OS err code: 0
 
Errors in file /phx11db1/u01/app/oracle/diag/rdbms/thdmas/thdmas/trace/thdmas_reco_13158.trc:
ORA-12154: TNS:could not resolve the connect identifier specified
ORA-02019: connection description for remote database not found
ORA-12154: TNS:could not resolve the connect identifier specified
ORA-12541: TNS:no listener
Fri Jun 12 18:06:28 2015
 
==================
The content of Trace file /phx11db1/u01/app/oracle/diag/rdbms/thdmas/thdmas/trace/thdmas_reco_13158.trc
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
ORACLE_HOME = /phx11db1/u01/app/oracle/product/11.2.0/db_3
System name:    SunOS
Node name:      phx11cn1
Release:        5.10
Version:        Generic_142900-13
Machine:        sun4u
Instance name: thdmas
Redo thread mounted by this instance: 1
Oracle process number: 14
Unix process pid: 13158, image: oracle_at_phx11cn1 (RECO)
*** 2015-06-12 17:15:30.137
ERROR, tran=113.29.105210, session#=1, ose=0:
ORA-12154: TNS:could not resolve the connect identifier specified
ORA-02019: connection description for remote database not found
ORA-12154: TNS:could not resolve the connect identifier specified
ORA-12541: TNS:no listener

 


[CONFIDENTIALITY AND PRIVACY NOTICE]

Information transmitted by this email is proprietary to Medtronic and is intended for use only by the individual or entity to which it is addressed, and may contain information that is private, privileged, confidential or exempt from disclosure under applicable law. If you are not the intended recipient or it appears that this mail has been forwarded to you without proper authority, you are notified that any use or dissemination of this information in any manner is strictly prohibited. In such cases, please delete this mail from your records.
 
To view this notice in other languages you can either select the following link or manually copy and paste the link into the address bar of a web browser: http://emaildisclaimer.medtronic.com
 		 	   		  

--
http://www.freelists.org/webpage/oracle-l

Received on Sat Jun 13 2015 - 06:27:22 CEST