Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

TNS names can't be resolved

534005Sep 15 2006 — edited Sep 18 2006

Hi All!

I try to connect to a database and the error message that TNS names can't be resolved. tnsnames.ora is copied from the PC where the connection works. Only one instance of Oracle client (9.2) is installed. I tried to add a TNS names in Net Assistent. It worked and the test within the assistent was successfull. The tnsnames.ora was also adjusted. But! I don't see the service in NetManager and I can't add any service there. The NT user is a member of the administrator group. I also try to connect using SQL plus, Excel, Enterprice manager - it doesn't work. Any ideas?

Is there any Windows service for the TNS? How it calls? I tried to check it with lsnrctl status but the command is not exist. Only client is installed on the PC.

Thanks,
Andrej

Locked Post

New comments cannot be posted to this locked post.

Locked on Oct 16 2006

Added on Sep 15 2006

#general-database-discussions

17 comments

1,555 views