Re: JDBC client causes TNS-12502 on server's listener

Well,

    what driver are you using to connect to the oracle db? Try using Oracle's thin driver (type4). See if that makes a difference.

hth,
Cindy

Enkidu Utnapishtim wrote:

> 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:50:00 CDT