How do you debug a database link (dblink)?

[m.L.]

I have just created a database link for two databases on the same
machine. I added the entries in the tnsname.ora and also listener.ora
since these are new databases.

For some reasons, I kept getting error messages like 'TNS cannot
resolve the name **' I did restart the listener couple times, but
the error stayed. The connected string I used is the basic,
dbname.hostname!

Is there anyways or suggestions that can help us debugging the dblink?

any ideas?

Please send your response here, or contact me through emails, mleung
@intelus.com, mle...@earthlink.net

thanks
Michael Leung

[Sybrand Bakker]

Hi Michael

database links are being taken care of by the server. You should ensure
the new service name is in the tnsnames.ora on the server.
If that still doesn't resolve your problem add or change, the following on
the server sqlnet.ora
trace_level_client = 16
trace_unique_client = true
trace_directory_client = <Oracle_home>\network\trace.

This will dump every call being made by sqlnet to a trace file.

Hth,

Sybrand Bakker, Oracle DBA