From: michaelbogen@my-deja.com
Newsgroups: comp.databases.oracle.server
Subject: Net8 - Problem
Date: Sat, 11 Nov 2000 18:16:39 GMT
Organization: Deja.com - Before you buy.
Lines: 49
Message-ID: <8uk2e3$asr$1@nnrp1.deja.com>
NNTP-Posting-Host: 129.143.4.35
X-Article-Creation-Date: Sat Nov 11 17:45:56 2000 GMT
X-Http-User-Agent: Mozilla/4.75 [de] (WinNT; U)
X-Http-Proxy: 1.0 st2-ce, 1.0 x54.deja.com:80 (Squid/1.1.22) for client 141.28.4.140, 129.143.4.35


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.