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

PK wrote:
> Hi Joel,
>
> Yes I have stopped the agents. I have ruled out one more Java program
> which turned out to be ISEE of HP. This was stopped but the problem
> continues happening. There is only one more EAI application
> (webMethods) that connects to the database using JDBC but it connects
> to the database fine and it has got no errors in its own logs.
>
> It looks like an every successfull connect by the EAI application
> results in such an error message:
>
> 11-JAN-2006 09:01:28 *
> (CONNECT_DATA=(CID=(PROGRAM=)(HOST=__jdbc__)(USER=))(SID=<OUR_ORACLE_SID>))
> * (ADDRESS=(PROTOCOL=tcp)(HOST=<SERVER_IP_ADDRESS>)(PORT=50278)) *
> establish * <OUR_ORACLE_SID> * 0
> 11-JAN-2006 09:01:30 *
> (CONNECT_DATA=(SID=ORCL)(CID=(PROGRAM=)(HOST=__jdbc__)(USER=oracle))) *
> (ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=50279)) * establish * ORCL
> * 12505
>
> Thanks for pointing out the 'Too Many '__JDBC__' Entries In LISTENER
> Log' metalink entry, but this problem is happening on 3 other servers
> where we have no grid control installed (but similar database
> construction -9.2.06/9.2.0.5 and same application).

What other things do you have installed on these servers? WEBDAV? GIOP? Hmmm, maybe we should back up a step and find every file on the system that references ORCL - maybe we'll find some config file or something:

find / -exec grep -l ORCL {} \; > ORCLanywhere (It seems ORCL is a string all over the place in the executables and libraries).

Another thought: Make a new instance named ORCL and see what connects to it. Do you have any with that name anywhere on your network? (I would guess some large majority of Windows platform Oracle instances have that name)

A bizarre thought: a host with an actual name of 127.0.0.1 ???

>
> Its very hard to get some meaningful answer out of Oracle support as
> they ask questions like: "are you using 1521 port ?" when my SR has got
> RDA outputs, listener.ora and listener trace files uploaded !
>

lol! I've gotten the impression in the past they don't see uploads without a bit of effort.

>
> Prashant

jg

--
@home.com is bogus.
Scofflaw or not?
http://www.signonsandiego.com/uniontrib/20060111/news_1n11license.html