Link to home
Start Free TrialLog in
Avatar of mwcmp
mwcmp

asked on

TNS No Listener...

i have set the oracle ODBC in my server side... my server side connect to orcl:world.. then i have set up the ODBC for my client side.. but when i connect my client side to the database.. it gaves me TNS No Listener.. wat does this error mean? did i miss out anything to setting up a network database?
ASKER CERTIFIED SOLUTION
Avatar of BobMc
BobMc

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Giant2
Giant2

adding.
the nameserver you use is present in your tnsnames.ora?
the tnsnames.ora is referring to a correct Oracle-Listener?

Giant.
You should first try tnsping.exe

This utility will make sure that your tnsnames.ora file is configured correctly.
If not, you should add an entry in the file with the relevant network information in order to have SQLnet to know how to connect to your Oracle engine.

MT-