RE: What is Generating All these Connection Attempts to a Database That No Longer Exists?

From: Mercadante, Thomas F \(LABOR\) <Thomas.Mercadante_at_labor.state.ny.us>
Date: Wed, 7 Feb 2007 10:59:27 -0500
Message-ID: <ABB9D76E187C5146AB5683F5A07336FFE08AFD@EXCNYSM0A1AJ.nysemail.nyenet>

Sam,  

I think this means that some program is trying to connect to the now non-existent database.  

Do you have an OEM console set up someplace on another machine? It might be trying to connect.

Tom  

---

This transmission may contain confidential, proprietary, or privileged information which is intended solely for use by the individual or entity to whom it is addressed. If you are not the intended recipient, you are hereby notified that any disclosure, dissemination, copying or distribution of this transmission or its attachments is strictly prohibited. In addition, unauthorized access to this transmission may violate federal or State law, including the Electronic Communications Privacy Act of 1985. If you have received this transmission in error, please notify the sender immediately by return e-mail and delete the transmission and its attachments.

---

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Sam Bootsma Sent: Wednesday, February 07, 2007 10:54 AM To: oracle-l_at_freelists.org
Subject: What is Generating All these Connection Attempts to a Database That No Longer Exists?  

07-FEB-2007 10:31:36 *
(CONNECT_DATA=(CID=(PROGRAM=)(HOST=__jdbc__)(USER=))(SERVICE_NAME=HAR521 )) * (ADDRESS=(PROTOCOL=tcp)(HOST=a.b.c.d)(PORT=pppp)) * establish * HAR521 * 12514 TNS-12514: TNS:listener does not currently know of service requested in connect descriptor  

We receive the above message in our listener.log file every 4 to 5 minutes. HAR521 used to be a database, but not now. HAR521 does not exist in the /etc/oratab file, and there is no entry for HAR521 in our tnsnames.ora file. The port number (pppp) is different for every entry in the listener.log file (although it may repeat eventually, I haven't checked). The host a.b.c.d is always the same and is the IP address of our database server .... the database server that used to have a service named HAR521 (but no longer does).  

Can anybody tell me what might be generating these entries in our listener.log file and how I can get it to stop generating these connection attempts?  

Thanks very much. We are running Oracle 10.2.0.2 on AIX 5.3.  

Sam Bootsma

Oracle Database Administrator

Information Technology Services
George Brown College

Phone: 416-415-5000 x4933
Fax: 416-415-4836
E-mail: sbootsma_at_georgebrown.ca <mailto:sbootsma_at_georgebrown.ca>

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

Received on Wed Feb 07 2007 - 09:59:27 CST