Oracle FAQ Your Portal to the Oracle Knowledge Grid

Home -> Community -> Mailing Lists -> Oracle-L -> Database Link Question

Database Link Question

From: Taylor, Chris David <>
Date: Tue, 16 Oct 2007 14:38:45 -0500
Message-ID: <>

I've come across a weird database link issue that I haven't seen before in other environments.  

We're running on Windows 2003 servers with TNSNAMES on the servers and LDAP resolution on the clients.  

Now, if we have a query that selects from a non-existent database link, the query doesn't return an error nor does it time out.  

I know I'm missing something in my sqlnet.ora (on the server) but I cannot figure out what it is.  

SQL> select * from dba_db_links;

No rows found  

SQL> select * from mytable_at_tst1;

Waiting, waiting, waiting......waiting(n)  

Now, my TNSNAMES file has a TST1.WORLD entry, my global_name where I'm running the select statement is DEV1.WORLD.  

I know a select @TST1 shouldn't use TST1.WORLD directly from the TNSNAMES file, but why doesn't it return an error that the db link doesn't exist?  

Here is the sqlnet.ora:  

SQLNET.AUTHENTICATION_SERVICES = (NTS) NAMES.DEFAULT_DOMAIN = WORLD NAMES.DIRECTORY_PATH= (TNSNAMES, LDAP)   We do have LDAP specified as a fallback in case we forgot to update the TNSNAMES file with a new service name.  

What am I missing here?  

I've been searching google, but can't seem to find the right combination of search terms to give me the information I'm looking for.    

Chris Taylor

Sr. Oracle DBA

Ingram Barge Company

Nashville, TN 37205

Office: 615-517-3355

Cell: 615-354-4799


This message contains information that may be privileged or confidential and is the property of the Capgemini Group. It is intended only for the person to whom it is addressed. If you are not the intended recipient, you are not authorized to read, print, retain, copy, disseminate, distribute, or use this message or any part thereof. If you receive this message in error, please notify the sender immediately and delete all copies of this message.         

Received on Tue Oct 16 2007 - 14:38:45 CDT

Original text of this message