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

From: I.A. Saez Scheihing <SaezScheihing_at_gee-mail.kom>
Date: Tue, 10 Jan 2006 10:48:23 +0100
Message-Id: <pan.2006.01.10.09.48.21.940351@gee-mail.kom>

Prashant,

There is a space in 127.0.0.1 (127.0.0. 1) or is it a typo?

Ivan

On Mon, 09 Jan 2006 14:15:08 -0800, PK wrote:

> 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 Tue Jan 10 2006 - 03:48:23 CST