Re: Getting repeated no listener error in the alert log

From: Karth Panchan <keyantech_at_gmail.com>
Date: Sat, 13 Jun 2015 00:10:03 -0400
Message-Id: <449E0289-E395-48C3-97C9-06281520BD1D_at_gmail.com>



Ashoke

Have you checked listener log file?

Karth

Sent from my IPhone

> On Jun 12, 2015, at 11:48 PM, Mandal, Ashoke <ashoke.k.mandal_at_medtronic.com> wrote:
>
> 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:10:03 CEST

Original text of this message