Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Net8 Problem
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_at_worldnet.att.net - (the real address)
> Thanks a million.
> Chuck
Received on Tue Feb 02 1999 - 14:44:11 CST