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

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

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 !

Prashant Received on Tue Jan 10 2006 - 16:14:32 CST