RE: Use of OID for name resolution

Thanks! Now we can say OID is indeed an overkill.

That "cool" feature was accidentally found by my coworker. She did 
that for a long time without realizing it's undocumented (actually 
I didn't look hard in documentation). I verified it from 9iR2 up 
to 11gR1, using both OID and ONAMES. But since it's undocumented, 
we probably shouldn't do it in production unless for some quick 
and dirty work. 

Yong Huang


--- On Thu, 10/22/09, Bobak, Mark <Mark.Bobak@xxxxxxxxxxxx> wrote:

Wow!  I didn't know you could do that!

Very cool!  (Learn something new every day!) 

And yes, I just tested, and it works.

[oracle@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@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@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@xmldb64> select db_link from dba_db_links;

no rows selected

SYSTEM@xmldb64> select * from dual@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


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

Other related posts: