Re: Net8 - Problem

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.

Hth,

--
Sybrand Bakker, Oracle DBA

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


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