Database Link Question
- From: "Taylor, Chris David" <Chris.Taylor@xxxxxxxxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 16 Oct 2007 14:38:45 -0500
I've come across a weird database link issue that I haven't seen before
in other environments.
We're running 10.2.0.3 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@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
Email: chris.taylor@xxxxxxxxxxxxxxx
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.
Other related posts:
