Re: TNS cannot connect to destination WHY?

On Fri, 18 Aug 2000 03:00:31 GMT, nitefrog_at_yahoo.com (The NiteFrog.-) wrote:

Check for the existance of an oracle_home\network and an oracle_home\net80 directory. If you are running designer or developer you may have both. If you have both you can set an environment variable TNS_ADMIN=oracle_home\net80\admin so that the machine ALWAYS goes here for the file, or you can copy the "good" TNSNAMES file into the other location.

This may not be the problem but I have seen it often enough to mention it.

Hope it helps

Kelvin Kirkland

>Hello,
>
>Like I mentioned in the previous message I can connect vais a
>different machine. So therefore the remote machine must be up as I
>can connect via another computer. Every thing works on one machine
>but not the other.
>
>My question is why? Same tnsnames.ora file.
>
>Thanks,.
>
>Kev.-
>
>On Thu, 17 Aug 2000 21:56:31 GMT, Alexander Penev <alex_at_cska.net>
>wrote:
>
>>Is the remote machine up? Is the listener running? Is there a network
>>problem?New Firewall configuration? Can you ping the remote machine?
>>Can you telnet the listener (telnet remotemashine 1521 if use the
>>default port) Has the ip adress changed?
>>Have you tried to restart the listener. What is the output of lsnrctl
>>status
>>There may be hundreds of reasons. Your question is just too general too
>>give a concret answer.
>>HTH
>>
>>
>>> We just installed Oracle 8i version 8.1.5.
>>> Everything was working fine I could create
>>> services names with Easy Config and connect
>>> to the remote database no problem.
>>>
>>> Now all of a sudden it stopped working I now
>>> get TNS unable to connect to destination. Nothing
>>> changed on our end but for the life of me I cannot
>>> connect but every thing was fine last week!
>>>
>>> I cannot even create a service. Now I can connect
>>> to the local database but not the remote one.
>>>
>>> Now from antother in another city I can connect
>>> to the remote database.
>>>
>>> What happened? Any ideas? Please help! I dont
>>> even know how to fix it. I went through deja and
>>> the answers didnt really help.
>>>
>>> I am completely stumped.
>>>
>>> Thank you all,
>>>
>>> Kev.-
>>
Received on Fri Aug 18 2000 - 17:59:19 CDT