-
Oracle 8.1.5
Solaris 7
I am receiving the following error(s) in listener.log when trying to run my java app:
TNS-12502: tNS:listener received no CONNECT_DATA from client
*** According to Oracle ***
TNS-12502 TNS:listener received no CONNECT_DATA from client
Cause: No CONNECT_DATA was passed to the listener.
Action: Check that the service name resolved from TNSNAMES.ORA has the CONNECT_DATA component of the connect descriptor.
******
I have filled in the CONNECT_DATA on client (in tnsnames.ora) with as many variables as I could find that are valid. They all match tns on the server, and I cannot get past this point. any suggestions?
R
-
Were you able to establish a simple sqlplus connection to the server using
sqlplus username/password@servicename
Make sure that the service_name in the tnsnames.ora matches the service name in your initSID.ora file on the server.
Sam
[Edited by sambavan on 09-13-2001 at 05:35 PM]
-
yes. From the client machine I can successfully
sqlplus username/password@jupiter
(jupiter being the server)
I have been battling this error for about a week, and this morning managed to severly kill tnsnames.ora (see previous thread) and at this point am out of ideas.
I have the EXTPROC_CONNECTION_DATA... set in tnsnames. Any ideas?
R
-
Do you still provide the service name in the tnsnames.ora file or SID. If it were SID then cheange it ti SERVICE_NAME and make sure it is the same as that of the SERVICE_NAME mentioned under initSID.ora file.
Next make sure that if you haven't removed the NAMES.DEFAULT_DOMAIN = world, you would want to comment that out, if you just want to use the jupiter as your connection string name. Hopefully this woud solve the problems ...
Sam