Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> Re: Ora-12203 TNS: Connection to host not possible

Re: Ora-12203 TNS: Connection to host not possible

From: TurkBear <noone_at_nowhere.com>
Date: Mon, 06 Aug 2001 11:10:32 -0500
Message-ID: <a9gtmtgrkhp8e4b497426apt3bpsb7hsc7@4ax.com>

We would need to see your tnsnames.ora, sqlnet.ora and listener.ora files to determine what's up..

Meanwhile, here is a more detailed extract about that error:



ORA-12203 ORA-12203TNS:Unable to connect to destination

Cause:Invalid TNS address supplied or destination is not listening. This error can also occur because of underlying network transport problems.

Action:Verify that the service name you entered on the command line was correct. Ensure that the listener is running at the remote node and that the ADDRESS parameters specified in TNSNAMES.ORA are correct. Finally, check that all Interchanges needed to make the connection are up and running.



hth

"Frank Baumann" <f.baumann_at_fb-netcom.de> wrote:

>I have a Windows 2000-Server with Oracle 8.16 installed. The Database is
>running correct.
>
>From the clients with Windows 2000 and Oracle 8.16 Client-Software i become
>the message:
>Ora-12203 TNS: Connection to host not possible.
>
>All entries i made, i checked 10 times, are correct
>
>Is there anything wrong with Name-Service, with Connection Time-Out?
>
>Greetings
> Frank
>

-----= Posted via Newsfeeds.Com, Uncensored Usenet News =----- http://www.newsfeeds.com - The #1 Newsgroup Service in the World! -----== Over 80,000 Newsgroups - 16 Different Servers! =----- Received on Mon Aug 06 2001 - 11:10:32 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US