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 last published in June 2003

PRO+

Content

Find more PRO+ content and other member only offers, here.

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.

Start the conversation

Send me notifications when other members comment.

By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Please create a username to comment.

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide

SearchDataCenter

SearchContentManagement

SearchFinancialApplications

Close