RE: Use of OID for name resolution
Date: Thu, 22 Oct 2009 14:31:10 -0700 (PDT)
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.
- On Thu, 10/22/09, Bobak, Mark <Mark.Bobak_at_proquest.com> 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_at_fv360eval201 ~]$ tnsping prd1
TNS Ping Utility for Linux: Version 126.96.36.199.0 - Production on 22-OCT-2009 16:35:15
Copyright (c) 1997, 2009, Oracle. All rights reserved.
Used parameter files:
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 188.8.131.52.0 Production on Thu Oct 22 16:35:44 2009
Copyright (c) 1982, 2009, Oracle. All rights reserved.
Oracle Database 11g Enterprise Edition Release 184.108.40.206.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options
SYSTEM_at_xmldb64> select db_link from dba_db_links;
no rows selected
SYSTEM_at_xmldb64> select * from dual_at_prd1;
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.
-MarkReceived on Thu Oct 22 2009 - 16:31:10 CDT