TNS-12505 entries in listener.log 9.2.0.6/HP-UX

From: PK <pk26au_at_yahoo.com>
Date: 9 Jan 2006 14:15:08 -0800
Message-ID: <1136844908.520853.85590@g44g2000cwa.googlegroups.com>

Hi,

In our servers there are multiple entries with entries of the following kind:
10-JAN-2006 09:07:03 *
(CONNECT_DATA=(SID=ORCL)(CID=(PROGRAM=)(HOST=__jdbc__)(USER=oracle))) *
(ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.

1)(PORT=55902)) * establish * ORCL * 12505 TNS-12505: TNS:listener could not resolve SID given in connect descriptor

These entries are happening every 4 or 5 seconds and the listener.log is increasing heavily in size. What is the best possible way of tracing back where these requests are coming from ?

Version we are using is 9.2.0.6 on HP-UX (PA-RISC) 11.11.

I have ruled out Grid Control, Intelligent agent as culprits as these entries continue even after stopping those agents.

Any ideas ?

Thanks in advance.
Prashant Received on Mon Jan 09 2006 - 16:15:08 CST