Re: Help with TNS problem.

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.-