Re: Net8 - Problem

From: <michaelbogen_at_my-deja.com>
Date: Sun, 12 Nov 2000 16:07:18 GMT
Message-ID: <8umf7k$kk$1@nnrp1.deja.com>

In article <8umdqg$vg6$1_at_nnrp1.deja.com>,   michaelbogen_at_my-deja.com wrote:
> In article <8ukhc2$lq0$1_at_nnrp1.deja.com>,
> oradba_at_sybrandb.demon.nl wrote:
> > In article <8uk2e3$asr$1_at_nnrp1.deja.com>,
> > michaelbogen_at_my-deja.com wrote:
> > > Hello!
> > >
> > > I have a problem running net8-Oracle 8i on a NT. In the dos-box
 tnsping
> > > <servicename> works fine. However, running tnsping80 <servicename>
 I
 always
> > > get a TNS-12203 Error (TNS:unable to connect to destination).
 sqlplus
 in the
> > > dos-box also works however using SQL-Plus for windows (and other
 windows
> > > programs as well) I again get the TNS-12203 error. BTW, what is
 the
> > > difference between tnsping and tnsping80?
> > >
> > > I guess my *ora files are not set correctly.
> > >
> > > Listner.ora:
> > > LISTENER =
> > > (DESCRIPTION_LIST =
> > > (DESCRIPTION =
> > > (ADDRESS = (PROTOCOL = TCP)(HOST = myhost)(PORT = 1521))
> > > )
> > > )
> > > SID_LIST_LISTENER =
> > > (SID_LIST =
> > > (SID_DESC =
> > > (GLOBAL_DBNAME = FHF)
> > > (ORACLE_HOME = c:\orant8i)
> > > (SID_NAME = FHF)
> > > )
> > > )
> > >
> > > sqlnet.ora:
> > > NAMES.DEFAULT_DOMAIN = mydomain.xy
> > > SQLNET.AUTHENTICATION_SERVICES= (NTS)
> > > NAMES.DIRECTORY_PATH= (TNSNAMES)
> > >
> > > tnsnames.ora:
> > > FHF, FHF.mydomain.xy =
> > > (DESCRIPTION =
> > > (ADDRESS_LIST =
> > > (ADDRESS = (PROTOCOL = TCP)(HOST = myhost)(PORT = 1521))
> > > )
> > > (CONNECT_DATA =
> > > (SID = FHF)
> > > )
> > > )
> > >
> > > THANKS FOR ANY HELP!!!
> > > Michael
> > >
> > > Sent via Deja.com http://www.deja.com/
> > > Before you buy.
> > >
> > 12203 usually means :
> > the host you refer to in your tnsnames.ora doesn't exist
> > or there is no listener running.
> > The host name should refer to an existing hostname, which can be
> > resolved either by dns, or by lmhosts or by hosts, latter files both
 in
> > \winnt\system32\drivers\etc directory.
> > Your tnsnames.ora definitely is incorrect, as you can have only one
> > servicename before the = sign. If you want an alias, you'll need to
> > repeat the complete block.
> >
> Hi!

>

> Thanks so far.
> The host does exist and the listener does run. I also fixed the
> tnsnames.ora file. However, tnsping80 still doesent't work, I still
 get
> the 12203 error. Any ideas? (tnsping (not tnsping80) works.)
>
> Michael

oops, meanwhile has become a "12538: TNS:no such protocol adapter" error :-( Thanks for any help.

Michael

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Sun Nov 12 2000 - 10:07:18 CST