Q

Resolving the TNS-12502 error

I have an Oracle database with a server IP of 1.1.1.10, and it also has a virtual IP of 10.10.10.10. The virtual IP is the way some of my clients must hit the database with the use of tnsnames.ora(host=10.10.10.10) instead of the actual IP address. Those clients are receiving 12502 errors and the listener log is showing these errors also. Is there anything special I need to do?

Here's what the Error Messages guide says about the TNS-12502 error:

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.

So, the first step is to check your TNSNAMES.ORA file that the clients are using and verify that it looks something like this:

ORCL =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 10.10.10.10)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = ORCL)
    )
  )
It sounds like you're missing some information.

For More Information


This was first published in June 2003

Dig deeper on Oracle error messages

Pro+

Features

Enjoy the benefits of Pro+ membership, learn more and join.

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

0 comments

Oldest 

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to:

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide

SearchDataCenter

SearchContentManagement

SearchFinancialApplications

Close