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
From what you posted the first thing that jumped out was defining HOST
as 127.0.0.1. That is not a good thing by any definition. Strikes me the
question I'd be asking is ... what isn't working.
--
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)
Received on Mon Jan 09 2006 - 17:10:33 CST
