Re: TNS-12203 HELP!!!!

From: JHY <jhy_at_earthling.net>
Date: Tue, 30 Jun 1998 00:44:38 -0400
Message-ID: <6n9qff$kt5@bgtnsc02.worldnet.att.net>

From my own notes:

ORA-12203 TNS: Unable to connect to destination

Cause: 1) NT Service not started: OracleTNSListener

2) Incorrect TCP/IP host in database alias

If the listener is up, then check the definition of the database alias on your client. If you're using TCP/IP, make sure you can ping the server from your client. Try using the IP address instead of a host name.

HTH 8track_at_my-dejanews.com wrote:

> Remote user cannot access my databases, yet I can. He is using the same
> tnsnames, sql.ora and oracle.ini. It is oracle 7.3 running on NT server 4.0
> The listener is up and running....after I can access the DB. I am stuck as how
> to troubleshoot anymore, tracing gave me a 12203 message, but it doesn't make
> sense.
> Thank you in advance
>
> -----== Posted via Deja News, The Leader in Internet Discussion ==-----
> http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum
Received on Mon Jun 29 1998 - 23:44:38 CDT