Xref: alice comp.databases.oracle.server:39606
Path: alice!news-feed.fnsi.net!netnews.com!newsfeed.wirehub.nl!bullseye.news.demon.net!demon!news.demon.nl!demon!sybrandb.demon.nl!not-for-mail
From: Sybrand Bakker <postbus@sybrandb.demon.nl>
Newsgroups: comp.databases.oracle.server
Subject: Re: Net8 Problem
Date: Tue, 02 Feb 1999 21:44:11 +0100
Message-ID: <36B7639B.E17696AF@sybrandb.demon.nl>
References: <36B750D2.B0CCAA24@worldnet.att.net>
X-Trace: news.demon.nl 917988279 rover:40 NO-IDENT sybrandb.demon.nl:212.238.21.78
X-Complaints-To: abuse@demon.net
X-Mailer: Mozilla 4.5 [en] (Win95; I)
X-Accept-Language: en,ja
MIME-Version: 1.0
To: Chuck Bauer <C.Bauer@worldnet.att.net>
Content-Type: multipart/mixed;
 boundary="------------CB0FA176F4D464F8A28BB925"
Lines: 73
--------------CB0FA176F4D464F8A28BB925
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: 8bit

According to the error message either the database or the listener (most
likely) doesn't run.
do you see a TNSlistener service running in the services applet of
control panel on the NT server?

Basically the listener.ora on the server should have
an addres block
with one address entry reading
(protocol=ipc)(key=<your database sid>)
the second address entry reading
(protocol=tcp)(host=<the node name of your server>)(port=1521)
and a sid_list
with the sid the listener is listening for.
The tcp address should occur in the address list of tnsnames.ora
the ipc address should not occur in this file.
Tnsnames.ora on client and server should be the same, with one
difference
automatic_ipc = OFF on the client (it should be ON on the server). On
the client it doesn't work anyway, as IPC stands for interprocess
communication.
Alternatively, send me your files and I will probably be able to fix it.

Hth,

Sybrand Bakker, Oracle DBA

Chuck Bauer wrote:

> My former partner was the DBA, and left in the middle of
> working in Net8, so I still cannot get the Oracle client on
> a 95 workstation to talk to the Oracle server on NT. Even
> after reading, “Getting Started” three times, I still remain
> mostly clueless how to get SQLNET to a functional condition.
> TNSNAMES.ORA and SQLNET.ORA are identical on both machines.
> Testing the “connection” with Net8 from the server results
> in a connection. However, testing the connection from 95
> returns:
> Connecting.... The test did not succeed. ORA-12203: TNS:
> unable to connect to destination. There may be an error in
> the fields entered or the server may not be ready for a
> connection. You can check the server and retry, or continue.
>
> If anyone has a successful checklist you follow that works
> on the NT platform, please send it, along with any other
> recommendations to:
> C.Bauer@worldnet.att.net - (the real address)
> Thanks a million.
> Chuck

--------------CB0FA176F4D464F8A28BB925
Content-Type: text/x-vcard; charset=us-ascii;
 name="postbus.vcf"
Content-Transfer-Encoding: 7bit
Content-Description: Card for Sybrand Bakker
Content-Disposition: attachment;
 filename="postbus.vcf"

begin:vcard 
n:Bakker;Sybrand
x-mozilla-html:FALSE
version:2.1
email;internet:postbus@sybrandb.demon.nl
x-mozilla-cpt:;0
fn:Sybrand Bakker
end:vcard

--------------CB0FA176F4D464F8A28BB925--