Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Net8 - Problem
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
Sent via Deja.com http://www.deja.com/
Before you buy.
Received on Sun Nov 12 2000 - 09:43:12 CST