RE: Use of OID for name resolution
Date: Thu, 22 Oct 2009 17:32:17 -0400
Message-ID: <6AFC12B9BFCDEA45B7274C534738067F2328FF08_at_AAPQMAILBX02V.proque.st>
I also wasn't aware that it wasn't documented, so, thanks for pointing that out!
-----Original Message-----
From: Yong Huang [mailto:yong321_at_yahoo.com]
Sent: Thursday, October 22, 2009 5:31 PM
To: Bobak, Mark
Cc: oracle-l_at_freelists.org
Subject: 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_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 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
-- http://www.freelists.org/webpage/oracle-lReceived on Thu Oct 22 2009 - 16:32:17 CDT