RE: Use of OID for name resolution

Very cool! (Learn something new every day!)

And yes, I just tested, and it works.

[oracle_at_fv360eval201 ~]$ tnsping prd1

TNS Ping Utility for Linux: Version 11.2.0.1.0 - Production on 22-OCT-2009 16:35:15

Copyright (c) 1997, 2009, Oracle. All rights reserved.

Used parameter files:
/oracle/product/11.2.0/db/network/admin/sqlnet.ora

Used LDAP adapter to resolve the alias
Attempting to contact (DESCRIPTION=(LOAD_BALANCE=ON)(FAILOVER_=ON)(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=pqrac101-vip.dc4.pqe)(PORT=1521))(ADDRESS=(PROTOCOL=TCP)(HOST=pqrac102-vip.dc4.pqe)(PORT=1521))(ADDRESS=(PROTOCOL=TCP)(HOST=pqrac103-vip.dc4.pqe)(PORT=1521))(LOAD_BALANCE=yes))(CONNECT_DATA=(FAILOVER_MODE=(TYPE=SELECT)(METHOD=BASIC))(SERVICE_NAME=pqprd))) OK (50 msec)
[oracle_at_fv360eval201 ~]$ cat $ORACLE_HOME/network/admin/ldap.ora # LDAP.ORA Network Configuration File: /oracle/product/9.2.0/network/admin/ldap.ora # Generated by Oracle configuration tools.

DEFAULT_ADMIN_CONTEXT = "" DIRECTORY_SERVERS= (dtgoid.aa1.pqe:3838) <<========== This is my tnsManager server!

DIRECTORY_SERVER_TYPE = OID [oracle_at_fv360eval201 ~]$ sqlplus system

SQL*Plus: Release 11.2.0.1.0 Production on Thu Oct 22 16:35:44 2009

Copyright (c) 1982, 2009, Oracle. All rights reserved.

Enter password:

Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options

Session altered.

SYSTEM_at_xmldb64> select db_link from dba_db_links;

no rows selected

SYSTEM_at_xmldb64> select * from dual_at_prd1;

D
-
X

So, yes, it works. I guess it makes sense. I don't think Oracle knows the difference between a real OID server and a tnsManager server.

-Mark

-----Original Message-----
From: Yong Huang [mailto:yong321_at_yahoo.com] Sent: Thursday, October 22, 2009 4:28 PM To: Bobak, Mark
Cc: oracle-l_at_freelists.org
Subject: RE: Use of OID for name resolution

> Check out tnsManager, here:
> http://www.shutdownabort.com/tnsmanager/

Mark,

Do you know if tnsManager has the capability of resolving a connection for your SQL that references a remote connection without a DB link? What I mean is that, with OID (or NAMES), "select * from t_at_conn" works even without creating the database link "conn", as long as

• "conn" is a connection string entry in OID that resolves to a remote database
• The DB server you run the query on is configured to look up names in OID
• The username/password are the same for this local and the "conn" database (if not, you get ORA-1017, but not ORA-02019: connection description for remote database not found)

I find this feature quite convenient when I need to access a remote database on a temporary, or even permanent, basis.

Yong Huang       

--
http://www.freelists.org/webpage/oracle-l