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

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 ?

Sounds kinda like metalink Note: 336177.1 plus some em config issues.

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

But have you stopped all of them? I'm guessing there was a bogus install of em you missed, and it is trying to find a default ORCL SID in your oratab.

>
> Any ideas ?
>
> Thanks in advance.
> Prashant

jg

--
@home.com is bogus.
You backed up to where?
http://computerworld.com/hardwaretopics/storage/story/0,10801,107607,00.html