TNS-12502
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: TNS-12502

Hybrid View

  1. #1
    Join Date
    Jun 2001
    Posts
    76
    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
    On the other hand, you have different fingers.

  2. #2
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    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]
    Thanx
    Sam



    Life is a journey, not a destination!


  3. #3
    Join Date
    Jun 2001
    Posts
    76
    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
    On the other hand, you have different fingers.

  4. #4
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    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
    Thanx
    Sam



    Life is a journey, not a destination!


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width