tnsnames Local Naming
Net service names are resolved using the tnsnames.ora file which resides on the client.
onames Oracle Names
Net service names and database service names are resolved centrally through an Oracle Names server.
hostname Host Naming
Net service names are resolved using the host naming method. Certain criteria must be met to use host naming.
Now you have two options... In your sqlnet.ora file, specify the domain name as it had been specified in the tnsnames and try.
example say your tnsnames is to say
in your sqlnet.ora file specify
NAMES.DEFAULT_DOMAIN = xyz.com
Second option is, just comment the NAMES.DEFAULT_DOMAIN
One of the above should work.
Your port numbers have to be the same in both your TNSNAMES entries and your LISTENER.ORA.
If your listener is listening on port 1521 and the tnsnames is trying to contact port 1526 or any other port number besides 1521 you will get a NO LISTENER error
Thank you everybody for all your help - I finally got it to work!
I believe that it could be just a minor mistake when configuring the Oracle .
1. Have you startup Oracle Agent Service if you want to use
2. Can you use tnsping in your client machine to test the connection ?