Re: Help with TNS problem.

12203 is cannot connect to destination. As the listener and the database are obviously up I strongly suspect the network configuration on that particular workstation (or a duff tnsnames.ora)

HTH

--
Niall Litchfield
Oracle DBA
Audit Commission UK
"The NiteFrog.-" <nitefrog_at_yahoo.com> wrote in message
news:399d8449.44976452_at_news.mindspring.com...


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

> >

> >

>