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@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
