RE: DB links

From: Jacques Kilchoer <Jacques.Kilchoer_at_quest.com>
Date: Wed, 11 Feb 2004 15:57:55 -0800
Message-ID: <B5C5F99D765BB744B54FFDF35F602621033DAEBB@irvmbxw02>

Have you turned on SQL Net tracing and looked at the trace file?

In sqlnet.ora:

# trace_level values: OFF, USER, ADMIN, SUPPORT

trace_directory_client =3D c:\temp
trace_file_client =3D net_client
trace_unique_client =3D on
trace_timestamp_client =3D true
trace_level_client =3D off

trace_directory_server =3D /tmp
trace_file_server =3D net_server

trace_timestamp_server =3D true
trace_level_server =3D off

If you have several Oracle Homes on the machine, then for debugging I = use different sqlnet.ora files and trace_file names in each Oracle Home = so that I can easily tell from the file name which Oracle Home was being = used for the network connection.

> -----Original Message-----
> Michael Milligan

>=20

> Has anyone had trouble using a link created for just certain=20
> databases, when
> everything is set right. In other words, no reason can be seen why it
> wouldn't work? We changed the global name, etc., etc. I can=20
> connect to the
> database but when I create the link, then try to select from dual from
> another database, it says "TNSNames cannot resolve service=20
> name". But using
> the same service name, I immediately connect successfully to=20
> the database!

>=20
> Driving us crazy. Any help would be greatly appreciated.

---

Please see the official ORACLE-L FAQ: http://www.orafaq.com

---

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.

--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Received on Wed Feb 11 2004 - 17:57:55 CST