RE: Database Link Question

Quick update to this....SYS.LINK$ has a lot of link information in it
even though we don't have those database links.

 

Very bizarre.

 

Chris Taylor

Sr. Oracle DBA

Ingram Barge Company

Nashville, TN 37205

Office: 615-517-3355

Cell: 615-354-4799

Email: chris.taylor@xxxxxxxxxxxxxxx

________________________________

From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Taylor, Chris David
Sent: Tuesday, October 16, 2007 2:39 PM
To: oracle-l@xxxxxxxxxxxxx
Subject: Database Link Question

 

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: