Re: Help with TNS problem.

Hello Jim,

Thanks for the reply. The weird thing is that it used to work then all of a sudden just stopped. Now I can connect from my machine to the remote but not from my partners machine to the remote. SO the listener has to be working as I can get to it.

The error number he is getting is ORA-12203.

Thanks again,

Kev.-

On Fri, 18 Aug 2000 11:23:26 -0400, "Jim Gregory" <JG200024_at_NCR.com> wrote:

>Really need more info with exact error number but it sounds like the service
>name in your local tnsnames is ok but, for some reason, you cannot connect
>to the remote database. It could be the listener on the remote system is
>down or now is not listening for the DB you're trying to connect to.
>
>Try a Unix ping to the remote box to verify it is reachable by your local
>connection. If so then try tnsping from your local box to the remote to see
>if it sees the remote box.
>
>I'm assuming you are using tnsnames and not ORACLE names to connect to the
>remote server.
>
>HTH
>
>--
>Jim Gregory
>Principal Consultant for Keane, Inc.
>Currently assigned to NCR
>"Opinions are my own and do not reflect
> those of Keane or my clients"
>The NiteFrog.- <nitefrog_at_yahoo.com> wrote in message
>news:399c5517.70439296_at_news.mindspring.com...
>> Hello All,
>>
>> 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 - 14:12:37 CDT