From: oradba@sybrandb.demon.nl
Newsgroups: comp.databases.oracle.server
Subject: Re: Net8 - Problem
Date: Sat, 11 Nov 2000 22:31:29 GMT
Organization: Deja.com - Before you buy.
Lines: 76
Message-ID: <8ukhc2$lq0$1@nnrp1.deja.com>
References: <8uk2e3$asr$1@nnrp1.deja.com>
NNTP-Posting-Host: 213.116.100.52
X-Article-Creation-Date: Sat Nov 11 22:31:29 2000 GMT
X-Http-User-Agent: Mozilla/4.0 (compatible; MSIE 5.01; Windows 98; Parool INTERNET)
X-Http-Proxy: 1.1 x61.deja.com:80 (Squid/1.1.22) for client 213.116.100.52
X-MyDeja-Info: XMYDJUIDsybrandb


In article <8uk2e3$asr$1@nnrp1.deja.com>,
  michaelbogen@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.

Hth,

--
Sybrand Bakker, Oracle DBA

All standard disclaimers apply
------------------------------------------------------------------------


Sent via Deja.com http://www.deja.com/
Before you buy.