Re: Win95 Client Connecting to Oracle Workgroup Server

In addition the following suggestions:

Check out your TNS_ADMIN registry key, it should point to the directory where TNSNAMES.ORA (and SQLNET.ORA) resides. If there is no TNS_ADMIN in your registry, these files should be in the directory %oracle_home%\network\admin (usually: c:\orawin95\network\admin)

If these clients are at different locations check out the TCP/IP configuration. Start with ping <nodename> if that works, try TNSPING <SID>. Once you get a response there, it should work fine. Otherwise, check out subnet-masks, routing or host-tables, consult your network manager.

regards.
Guus van de Sande

-- 
- remove NOSPAM from my e-mail adress -

Dave Klinger <dklinger_at_bechtel.com> schreef in artikel
<35F7E01F.7C4818E7_at_bechtel.com>...


> This first thing to check is the TNSNAMES.ORA files (assuming you're not

 using


> Orancle Names Server)..  Make sure the entry on the machine that is

 "erroring out"


> is correct.  The particular error you received is usually caused by the

 address


> listed in the TNSNAMES file being wrong.

> 

> Dave

> 

> sunilk7631_at_my-dejanews.com wrote:

> 

> > I have oracle 7 workgroup server for windows NT.

> > Trying to use PLUS33W an sql tool to access the oracle database from a

 windows


> > 95 client

> >

> > My WIN.INI  configuration is as follows

> >

> > [ORACLE]

> > Ora_Config=r:\orawin\oracle.ini

> >

> > The map drive r: is also the nt server with the oracle database on it.

> >

> > My path in autoexec.bat has R:\orawin\bin

> >

> > I have two clients which have the same configuration both are windows

 95a they


> > both use tcp/ip as the network protocol and the server is only

 configured for


> > tcp/ip, however one of them works and the other doesn't. The one that

 doesn't


> > gives the following error ORA-12203:TNS:Unable to connect to

 destination.


> >

> > Any help would be most appreciated.

> >

> > -----== Posted via Deja News, The Leader in Internet Discussion ==-----

> > http://www.dejanews.com/rg_mkgrp.xp   Create Your Own Free Member Forum

> 

> 

> 

>