Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> JDBC client causes TNS-12502 on server's listener

JDBC client causes TNS-12502 on server's listener

From: Enkidu Utnapishtim <utnapishtim43NOSPAM_at_hotmail.com>
Date: Thu, 18 Jul 2002 20:20:36 GMT
Message-ID: <3D372314.1090908@hotmail.com>


I am trying to research why a JDBC client (WebLogic java app) keeps generating a "TNS-12502: TNS:listener received no CONNECT_DATA from client" in my server's listener.log file. The message appears every minute or so (making my listener.log grow way too fast).

I checked MetaLink and did a Google search (web and newsgroups).

Practically every response says to check the tnsnames.ora on the client for a valid CONNECT_DATA entry. Well now, that's mighty fine advice if the client is anything other than a JDBC (or ODBC) connection. As far as I can determine, JDBC completely and totally ignores tnsnames.ora anyhow. That's why you have to put connect strings like "host:port:sid" in many of Oracle's Java wizards (eg, Portal Config Assistant) instead of the alias name from tnsnames.ora ... so it can construct a JDBC compliant connect string.

So, my question is, where do I look (if not in the client's tnsnames.ora) for the problem?

Thanks,
Roger Crowley - LearningFramework - DBA Received on Thu Jul 18 2002 - 15:20:36 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US