How to
debug a database link(dblink)?
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?
Ans:
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