Getting repeated no listener error in the alert log

From: Mandal, Ashoke <ashoke.k.mandal_at_medtronic.com>
Date: Sat, 13 Jun 2015 03:48:14 +0000
Message-ID: <DD179917255B1146B9367DC5E7C0DDB00230DD8F_at_MSPM1BMSGM41.ent.core.medtronic.com>

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 - 05:48:14 CEST