{"id":9927,"date":"2017-04-06T09:50:50","date_gmt":"2017-04-06T07:50:50","guid":{"rendered":"https:\/\/www.dbi-services.com\/blog\/oud-oracle-unified-directory-11-1-2-3-oracle-generates-more-and-more-ldap-lookups-with-every-release\/"},"modified":"2017-04-06T09:50:50","modified_gmt":"2017-04-06T07:50:50","slug":"oud-oracle-unified-directory-11-1-2-3-oracle-generates-more-and-more-ldap-lookups-with-every-release","status":"publish","type":"post","link":"https:\/\/www.dbi-services.com\/blog\/oud-oracle-unified-directory-11-1-2-3-oracle-generates-more-and-more-ldap-lookups-with-every-release\/","title":{"rendered":"OUD \u2013 Oracle Unified Directory 11.1.2.3, Oracle generates more and more LDAP lookups with every release"},"content":{"rendered":"<h2>By William Sescu<\/h2>\n<p>After installing OUD some time ago, I was doing some tests to see how it performs, and as long as I do ldap searching on the command line it looks very good. I am running Unified Directory 11.1.2.3.170117 (latest PSU), just for the protocol and I use the OUD only for TNS resolving and nothing else. However, Oracle clients are not connecting with &#8220;ldapsearch&#8221;, they are using &#8220;sqlplus&#8221; and the TNS name is resolved automatically in background.<\/p>\n<p>I do have the following ldap.ora and sqlnet.ora. Very simply and nothing special.<\/p>\n<pre class=\"brush: actionscript3; gutter: true; first-line: 1\">oracle@dbidg03:\/u01\/app\/oracle\/network\/admin\/ [DBIT122] cat ldap.ora\nDIRECTORY_SERVERS= (dbidg01:1389)\nDEFAULT_ADMIN_CONTEXT = \"dc=dbi,dc=com\"\nDIRECTORY_SERVER_TYPE = OID\n\noracle@dbidg03:\/u01\/app\/oracle\/network\/admin\/ [DBIT122] cat sqlnet.ora\nNAMES.DIRECTORY_PATH = (TNSNAMES,LDAP,EZCONNECT)<\/pre>\n<p>Here is a little quiz: How many LDAP search requests do you expect when you connect to a 12.2 databases with the following command?<\/p>\n<pre class=\"brush: actionscript3; gutter: true; first-line: 1\">sqlplus system\/manager@dbit122_ldap<\/pre>\n<p>Only one, right? Oracle looks up the TNS name dbit122_ldap in the OUD and retrieves the connect string. As soon as Oracle has the connect details, OUD does not play any role anymore. In case you do a ldapsearch from the 12.2 Oracle Home, then this is exactly the case.<\/p>\n<pre class=\"brush: actionscript3; gutter: true; first-line: 1\">oracle@dbidg03:\/u01\/app\/oracle\/network\/admin\/ [DBIT122] which ldapsearch\n\/u01\/app\/oracle\/product\/12.2.0\/dbhome_1\/bin\/ldapsearch\noracle@dbidg03:\/u01\/app\/oracle\/network\/admin\/ [DBIT122] ldapsearch -v -h dbidg01 -p 1389 -b \"cn=DBIT122_LDAP,cn=OracleContext,dc=dbi,dc=com\" -s base \"(objectclass=*)\" \"objectclass,orclNetDescString,orclNetDescName,orclVersion\"\nldap_open( dbidg01, 1389 )\nfilter pattern: (objectclass=*)\nreturning: objectclass,orclNetDescString,orclNetDescName,orclVersion\nfilter is: ((objectclass=*))\ncn=dbit122_ldap,cn=OracleContext,dc=dbi,dc=com\n1 matches<\/pre>\n<p>In the OUD access log, you can see it clearly. One connect, the bind, the search request and finally the disconnect. Exactly how it should be, and the etime is 1 millisecond. That&#8217;s the elapsed time to deliver the search request which is very fast.<\/p>\n<pre class=\"brush: actionscript3; gutter: true; first-line: 1\">[dbafmw@dbidg01 logs]$ tail -40f \/u01\/app\/oracle\/product\/Middleware\/11.1.2.3\/asinst_1\/OUD\/logs\/access\n...\n[06\/Apr\/2017:10:46:49 +0200] CONNECT conn=877 from=192.168.56.203:21971 to=192.168.56.201:1389 protocol=LDAP\n[06\/Apr\/2017:10:46:49 +0200] BIND REQ conn=877 op=0 msgID=1 type=SIMPLE dn=\"\" version=3\n[06\/Apr\/2017:10:46:49 +0200] BIND RES conn=877 op=0 msgID=1 result=0 authDN=\"\" etime=0\n[06\/Apr\/2017:10:46:49 +0200] SEARCH REQ conn=877 op=1 msgID=2 base=\"cn=DBIT122_LDAP,cn=OracleContext,dc=dbi,dc=com\" scope=base filter=\"(objectclass=*)\" attrs=\"objectclass,orclNetDescString,orclNetDescName,orclVersion\"\n[06\/Apr\/2017:10:46:49 +0200] SEARCH RES conn=877 op=1 msgID=2 result=0 nentries=1 etime=1\n[06\/Apr\/2017:10:46:49 +0200] UNBIND REQ conn=877 op=2 msgID=3\n[06\/Apr\/2017:10:46:49 +0200] DISCONNECT conn=877 reason=\"Client Disconnect\"<\/pre>\n<p>Ok. Let&#8217;s do the first test with Oracle 10.2.0.5. I know, it is not supported, however, regarding LDAP searches it is a version \u00a0where everything is ok. My test is very simple, just a sqlplus connection and then an exit. Nothing else.<\/p>\n<pre class=\"brush: actionscript3; gutter: true; first-line: 1\">oracle@dbidg03:\/u01\/app\/oracle\/network\/admin\/ [DBIT102] sqlplus -V\n\nSQL*Plus: Release 10.2.0.5.0 - Production\n\noracle@dbidg03:\/u01\/app\/oracle\/network\/admin\/ [DBIT102] sqlplus system\/manager@dbit122_ldap\n\nSQL*Plus: Release 10.2.0.5.0 - Production on Thu Apr 6 11:00:02 2017\n\nCopyright (c) 1982, 2010, Oracle.  All Rights Reserved.\n\n\nConnected to:\nOracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production\n\nSQL&gt; exit\nDisconnected from Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production<\/pre>\n<p>In the OUD access log I see, like expected only one search request.<\/p>\n<pre class=\"brush: actionscript3; gutter: true; first-line: 1\">[dbafmw@dbidg01 logs]$ tail -40f \/u01\/app\/oracle\/product\/Middleware\/11.1.2.3\/asinst_1\/OUD\/logs\/access\n...\n[06\/Apr\/2017:11:01:18 +0200] CONNECT conn=879 from=192.168.56.203:21974 to=192.168.56.201:1389 protocol=LDAP\n[06\/Apr\/2017:11:01:18 +0200] BIND REQ conn=879 op=0 msgID=1 type=SIMPLE dn=\"\" version=3\n[06\/Apr\/2017:11:01:18 +0200] BIND RES conn=879 op=0 msgID=1 result=0 authDN=\"\" etime=0\n[06\/Apr\/2017:11:01:18 +0200] SEARCH REQ conn=879 op=1 msgID=2 base=\"cn=dbit122_ldap,cn=OracleContext,dc=dbi,dc=com\" scope=base filter=\"(objectclass=*)\" attrs=\"objectclass,orclNetDescString,orclNetDescName,orclVersion\"\n[06\/Apr\/2017:11:01:18 +0200] SEARCH RES conn=879 op=1 msgID=2 result=0 nentries=1 etime=2\n[06\/Apr\/2017:11:01:18 +0200] UNBIND REQ conn=879 op=2 msgID=3\n[06\/Apr\/2017:11:01:18 +0200] DISCONNECT conn=879 reason=\"Client Disconnect\"<\/pre>\n<p>Let&#8217;s to the same now with 11.2.0.4. This time with a fully supported version. Yes. It still is. \ud83d\ude42<\/p>\n<pre class=\"brush: actionscript3; gutter: true; first-line: 1\">oracle@dbidg03:\/u01\/app\/oracle\/network\/admin\/ [DBIT112] sqlplus -V\n\nSQL*Plus: Release 11.2.0.4.0 Production\n\noracle@dbidg03:\/u01\/app\/oracle\/network\/admin\/ [DBIT112] sqlplus system\/manager@dbit122_ldap\n\nSQL*Plus: Release 11.2.0.4.0 Production on Thu Apr 6 11:03:17 2017\n\nCopyright (c) 1982, 2013, Oracle.  All rights reserved.\n\n\nConnected to:\nOracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production\n\nSQL&gt; exit\nDisconnected from Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production<\/pre>\n<p>Wowwwww &#8230; now I see already two search request on the OUD. To be honest, I haven&#8217;t expected that. One should be sufficient from my point of view.<\/p>\n<pre class=\"brush: actionscript3; gutter: true; first-line: 1\">[dbafmw@dbidg01 logs]$ tail -40f \/u01\/app\/oracle\/product\/Middleware\/11.1.2.3\/asinst_1\/OUD\/logs\/access\n...\n[06\/Apr\/2017:11:03:43 +0200] CONNECT conn=882 from=192.168.56.203:21979 to=192.168.56.201:1389 protocol=LDAP\n[06\/Apr\/2017:11:03:43 +0200] BIND REQ conn=882 op=0 msgID=1 type=SIMPLE dn=\"\" version=3\n[06\/Apr\/2017:11:03:43 +0200] BIND RES conn=882 op=0 msgID=1 result=0 authDN=\"\" etime=0\n[06\/Apr\/2017:11:03:43 +0200] SEARCH REQ conn=882 op=1 msgID=2 base=\"cn=dbit122_ldap,cn=OracleContext,dc=dbi,dc=com\" scope=base filter=\"(objectclass=*)\" attrs=\"objectclass,orclNetDescString,orclNetDescName,orclVersion\"\n[06\/Apr\/2017:11:03:43 +0200] SEARCH RES conn=882 op=1 msgID=2 result=0 nentries=1 etime=1\n[06\/Apr\/2017:11:03:43 +0200] UNBIND REQ conn=882 op=2 msgID=3\n[06\/Apr\/2017:11:03:43 +0200] DISCONNECT conn=882 reason=\"Client Disconnect\"\n[06\/Apr\/2017:11:03:43 +0200] CONNECT conn=883 from=192.168.56.203:21980 to=192.168.56.201:1389 protocol=LDAP\n[06\/Apr\/2017:11:03:43 +0200] BIND REQ conn=883 op=0 msgID=1 type=SIMPLE dn=\"\" version=3\n[06\/Apr\/2017:11:03:43 +0200] BIND RES conn=883 op=0 msgID=1 result=0 authDN=\"\" etime=1\n[06\/Apr\/2017:11:03:43 +0200] SEARCH REQ conn=883 op=1 msgID=2 base=\"cn=dbit122_ldap,cn=OracleContext,dc=dbi,dc=com\" scope=base filter=\"(objectclass=*)\" attrs=\"objectclass,orclNetDescString,orclNetDescName,orclVersion\"\n[06\/Apr\/2017:11:03:43 +0200] SEARCH RES conn=883 op=1 msgID=2 result=0 nentries=1 etime=2\n[06\/Apr\/2017:11:03:43 +0200] UNBIND REQ conn=883 op=2 msgID=3\n[06\/Apr\/2017:11:03:43 +0200] DISCONNECT conn=883 reason=\"Client Disconnect\"<\/pre>\n<p>But when you think, it can&#8217;t get worse, then do the same simple test with a 12.1.0.2 Oracle client.<\/p>\n<pre class=\"brush: actionscript3; gutter: true; first-line: 1\">oracle@dbidg03:\/u01\/app\/oracle\/network\/admin\/ [DBIT121] sqlplus -V\n\nSQL*Plus: Release 12.1.0.2.0 Production\n\noracle@dbidg03:\/u01\/app\/oracle\/network\/admin\/ [DBIT121] sqlplus system\/manager@dbit122_ldap\n\nSQL*Plus: Release 12.1.0.2.0 Production on Thu Apr 6 11:06:18 2017\n\nCopyright (c) 1982, 2014, Oracle.  All rights reserved.\n\nLast Successful login time: Thu Apr 06 2017 11:03:43 +02:00\n\nConnected to:\nOracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production\n\nSQL&gt; exit\nDisconnected from Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production<\/pre>\n<p>Incredible, it is issuing three ldap search requests against the OUD for a simple sqlplus connection.<\/p>\n<pre class=\"brush: actionscript3; gutter: true; first-line: 1\">[dbafmw@dbidg01 logs]$ tail -40f \/u01\/app\/oracle\/product\/Middleware\/11.1.2.3\/asinst_1\/OUD\/logs\/access\n...\n[06\/Apr\/2017:11:06:41 +0200] CONNECT conn=887 from=192.168.56.203:21986 to=192.168.56.201:1389 protocol=LDAP\n[06\/Apr\/2017:11:06:41 +0200] BIND REQ conn=887 op=0 msgID=1 type=SIMPLE dn=\"\" version=3\n[06\/Apr\/2017:11:06:41 +0200] BIND RES conn=887 op=0 msgID=1 result=0 authDN=\"\" etime=0\n[06\/Apr\/2017:11:06:41 +0200] SEARCH REQ conn=887 op=1 msgID=2 base=\"cn=dbit122_ldap,cn=OracleContext,dc=dbi,dc=com\" scope=base filter=\"(objectclass=*)\" attrs=\"objectclass,orclNetDescString,orclNetDescName,orclVersion\"\n[06\/Apr\/2017:11:06:41 +0200] SEARCH RES conn=887 op=1 msgID=2 result=0 nentries=1 etime=1\n[06\/Apr\/2017:11:06:41 +0200] UNBIND REQ conn=887 op=2 msgID=3\n[06\/Apr\/2017:11:06:41 +0200] DISCONNECT conn=887 reason=\"Client Disconnect\"\n[06\/Apr\/2017:11:06:41 +0200] CONNECT conn=888 from=192.168.56.203:21987 to=192.168.56.201:1389 protocol=LDAP\n[06\/Apr\/2017:11:06:41 +0200] BIND REQ conn=888 op=0 msgID=1 type=SIMPLE dn=\"\" version=3\n[06\/Apr\/2017:11:06:41 +0200] BIND RES conn=888 op=0 msgID=1 result=0 authDN=\"\" etime=0\n[06\/Apr\/2017:11:06:41 +0200] SEARCH REQ conn=888 op=1 msgID=2 base=\"cn=dbit122_ldap,cn=OracleContext,dc=dbi,dc=com\" scope=base filter=\"(objectclass=*)\" attrs=\"objectclass,orclNetDescString,orclNetDescName,orclVersion\"\n[06\/Apr\/2017:11:06:41 +0200] SEARCH RES conn=888 op=1 msgID=2 result=0 nentries=1 etime=2\n[06\/Apr\/2017:11:06:41 +0200] UNBIND REQ conn=888 op=2 msgID=3\n[06\/Apr\/2017:11:06:41 +0200] DISCONNECT conn=888 reason=\"Client Disconnect\"\n[06\/Apr\/2017:11:06:41 +0200] CONNECT conn=889 from=192.168.56.203:21988 to=192.168.56.201:1389 protocol=LDAP\n[06\/Apr\/2017:11:06:41 +0200] BIND REQ conn=889 op=0 msgID=1 type=SIMPLE dn=\"\" version=3\n[06\/Apr\/2017:11:06:41 +0200] BIND RES conn=889 op=0 msgID=1 result=0 authDN=\"\" etime=1\n[06\/Apr\/2017:11:06:41 +0200] SEARCH REQ conn=889 op=1 msgID=2 base=\"cn=dbit122_ldap,cn=OracleContext,dc=dbi,dc=com\" scope=base filter=\"(objectclass=*)\" attrs=\"objectclass,orclNetDescString,orclNetDescName,orclVersion\"\n[06\/Apr\/2017:11:06:41 +0200] SEARCH RES conn=889 op=1 msgID=2 result=0 nentries=1 etime=2\n[06\/Apr\/2017:11:06:41 +0200] UNBIND REQ conn=889 op=2 msgID=3\n[06\/Apr\/2017:11:06:41 +0200] DISCONNECT conn=889 reason=\"Client Disconnect\"<\/pre>\n<p>The last test is now with a 12cR2 client. Will it increase now to 4?<\/p>\n<pre class=\"brush: actionscript3; gutter: true; first-line: 1\">oracle@dbidg03:\/u01\/app\/oracle\/network\/admin\/ [DBIT122] sqlplus system\/manager@dbit122_ldap\n\nSQL*Plus: Release 12.2.0.1.0 Production on Thu Apr 6 11:09:08 2017\n\nCopyright (c) 1982, 2016, Oracle.  All rights reserved.\n\nLast Successful login time: Thu Apr 06 2017 11:06:41 +02:00\n\nConnected to:\nOracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production\n\nSQL&gt; exit\nDisconnected from Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production<\/pre>\n<p>No, it did not increase to 4. But with 12cR2 you will see like with 12cR1 also 3 search requests against the OUD.<\/p>\n<pre class=\"brush: actionscript3; gutter: true; first-line: 1\">[dbafmw@dbidg01 logs]$ tail -40f \/u01\/app\/oracle\/product\/Middleware\/11.1.2.3\/asinst_1\/OUD\/logs\/access\n...\n[06\/Apr\/2017:11:09:07 +0200] CONNECT conn=890 from=192.168.56.203:21990 to=192.168.56.201:1389 protocol=LDAP\n[06\/Apr\/2017:11:09:07 +0200] BIND REQ conn=890 op=0 msgID=1 type=SIMPLE dn=\"\" version=3\n[06\/Apr\/2017:11:09:07 +0200] BIND RES conn=890 op=0 msgID=1 result=0 authDN=\"\" etime=1\n[06\/Apr\/2017:11:09:07 +0200] SEARCH REQ conn=890 op=1 msgID=2 base=\"cn=dbit122_ldap,cn=OracleContext,dc=dbi,dc=com\" scope=base filter=\"(objectclass=*)\" attrs=\"objectclass,orclNetDescString,orclNetDescName,orclVersion\"\n[06\/Apr\/2017:11:09:07 +0200] SEARCH RES conn=890 op=1 msgID=2 result=0 nentries=1 etime=2\n[06\/Apr\/2017:11:09:07 +0200] UNBIND REQ conn=890 op=2 msgID=3\n[06\/Apr\/2017:11:09:07 +0200] DISCONNECT conn=890 reason=\"Client Disconnect\"\n[06\/Apr\/2017:11:09:07 +0200] CONNECT conn=891 from=192.168.56.203:21991 to=192.168.56.201:1389 protocol=LDAP\n[06\/Apr\/2017:11:09:07 +0200] BIND REQ conn=891 op=0 msgID=1 type=SIMPLE dn=\"\" version=3\n[06\/Apr\/2017:11:09:07 +0200] BIND RES conn=891 op=0 msgID=1 result=0 authDN=\"\" etime=0\n[06\/Apr\/2017:11:09:07 +0200] SEARCH REQ conn=891 op=1 msgID=2 base=\"cn=dbit122_ldap,cn=OracleContext,dc=dbi,dc=com\" scope=base filter=\"(objectclass=*)\" attrs=\"objectclass,orclNetDescString,orclNetDescName,orclVersion\"\n[06\/Apr\/2017:11:09:07 +0200] SEARCH RES conn=891 op=1 msgID=2 result=0 nentries=1 etime=1\n[06\/Apr\/2017:11:09:07 +0200] UNBIND REQ conn=891 op=2 msgID=3\n[06\/Apr\/2017:11:09:07 +0200] DISCONNECT conn=891 reason=\"Client Disconnect\"\n[06\/Apr\/2017:11:09:07 +0200] CONNECT conn=892 from=192.168.56.203:21992 to=192.168.56.201:1389 protocol=LDAP\n[06\/Apr\/2017:11:09:07 +0200] BIND REQ conn=892 op=0 msgID=1 type=SIMPLE dn=\"\" version=3\n[06\/Apr\/2017:11:09:07 +0200] BIND RES conn=892 op=0 msgID=1 result=0 authDN=\"\" etime=0\n[06\/Apr\/2017:11:09:07 +0200] SEARCH REQ conn=892 op=1 msgID=2 base=\"cn=dbit122_ldap,cn=OracleContext,dc=dbi,dc=com\" scope=base filter=\"(objectclass=*)\" attrs=\"objectclass,orclNetDescString,orclNetDescName,orclVersion\"\n[06\/Apr\/2017:11:09:07 +0200] SEARCH RES conn=892 op=1 msgID=2 result=0 nentries=1 etime=1\n[06\/Apr\/2017:11:09:07 +0200] UNBIND REQ conn=892 op=2 msgID=3\n[06\/Apr\/2017:11:09:07 +0200] DISCONNECT conn=892 reason=\"Client Disconnect\"<\/pre>\n<p>So what is the reason for this high increase in ldap searches. Instead of 1, it is doing 3 with 12cR1 and 12cR2, and 2 with 11gR2. That is 66% more than with Oracle 10gR2 clients. That&#8217;s enormous from my point view. Quite a huge extra load on your OUD server, when \u00a0you upgrade your Oracle clients.<\/p>\n<p>To make it short, I have no answer. It might be related to the old Oracle Names code, which seems that it is still there. I have found errors in the client trace file regarding a A.SMD query. The A.SMD call is coming from the old Oracle Names server, where you could have done stuff like &#8220;NAMESCTL&gt; QUERY DB920.oracle.com A.SMD&#8221;. But this is really a long time ago. My last Oracle Name server, I have seen in 2002.<\/p>\n<pre class=\"brush: actionscript3; gutter: true; first-line: 1\">oracle@dbidg02:\/u01\/app\/oracle\/network\/trc\/ [DBIT122] cat 12.2_client.trc | grep A.SMD\n(4144394624) [04-APR-2017 14:38:18:633] nnfttran: Error querying DBIT122_LDAP of attribute A.SMD errcode 408\n(4144394624) [04-APR-2017 14:38:18:642] nnfttran: Error querying DBIT122_LDAP of attribute A.SMD errcode 408\n(4144394624) [04-APR-2017 14:38:18:646] nnfttran: Error querying DBIT122_LDAP of attribute A.SMD errcode 408<\/pre>\n<p>If I take a look at my 12cR2 adapters I have no Oracle Names compiled in. I don&#8217;t know if this is possible at all, with 12c.<\/p>\n<pre class=\"brush: actionscript3; gutter: true; first-line: 1\">oracle@dbidg03:\/u01\/app\/oracle\/network\/admin\/ [DBIT122] adapters | egrep -A 5 \"Installed Oracle Net naming methods\"\nInstalled Oracle Net naming methods are:\n\n    Local Naming (tnsnames.ora)\n    Oracle Directory Naming\n    Oracle Host Naming<\/pre>\n<h3>Conclusion<\/h3>\n<p>Ok. What should I say &#8230; take care if you upgrade your clients to more recent versions, in case you use OUD to resolve your names. It might generate some extra load on your OUD servers. More and more with every release since 10gR2. By the way &#8230; I have opened a SR at Oracle, because this seems to be a bug for me. I was very surprised, that I was the first one facing this issue. Will keep you posted as soon as I have results. \ud83d\ude09<\/p>\n","protected":false},"excerpt":{"rendered":"<p>By William Sescu After installing OUD some time ago, I was doing some tests to see how it performs, and as long as I do ldap searching on the command line it looks very good. I am running Unified Directory 11.1.2.3.170117 (latest PSU), just for the protocol and I use the OUD only for TNS [&hellip;]<\/p>\n","protected":false},"author":27,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[229],"tags":[1053,1054],"type_dbi":[],"class_list":["post-9927","post","type-post","status-publish","format-standard","hentry","category-database-administration-monitoring","tag-oracle-unified-directory","tag-oud"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v27.2 (Yoast SEO v27.4) - https:\/\/yoast.com\/product\/yoast-seo-premium-wordpress\/ -->\n<title>OUD \u2013 Oracle Unified Directory 11.1.2.3, Oracle generates more and more LDAP lookups with every release - dbi Blog<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.dbi-services.com\/blog\/oud-oracle-unified-directory-11-1-2-3-oracle-generates-more-and-more-ldap-lookups-with-every-release\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"OUD \u2013 Oracle Unified Directory 11.1.2.3, Oracle generates more and more LDAP lookups with every release\" \/>\n<meta property=\"og:description\" content=\"By William Sescu After installing OUD some time ago, I was doing some tests to see how it performs, and as long as I do ldap searching on the command line it looks very good. I am running Unified Directory 11.1.2.3.170117 (latest PSU), just for the protocol and I use the OUD only for TNS [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dbi-services.com\/blog\/oud-oracle-unified-directory-11-1-2-3-oracle-generates-more-and-more-ldap-lookups-with-every-release\/\" \/>\n<meta property=\"og:site_name\" content=\"dbi Blog\" \/>\n<meta property=\"article:published_time\" content=\"2017-04-06T07:50:50+00:00\" \/>\n<meta name=\"author\" content=\"Oracle Team\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Oracle Team\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"9 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/oud-oracle-unified-directory-11-1-2-3-oracle-generates-more-and-more-ldap-lookups-with-every-release\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/oud-oracle-unified-directory-11-1-2-3-oracle-generates-more-and-more-ldap-lookups-with-every-release\\\/\"},\"author\":{\"name\":\"Oracle Team\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/person\\\/66ab87129f2d357f09971bc7936a77ee\"},\"headline\":\"OUD \u2013 Oracle Unified Directory 11.1.2.3, Oracle generates more and more LDAP lookups with every release\",\"datePublished\":\"2017-04-06T07:50:50+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/oud-oracle-unified-directory-11-1-2-3-oracle-generates-more-and-more-ldap-lookups-with-every-release\\\/\"},\"wordCount\":650,\"commentCount\":0,\"keywords\":[\"Oracle Unified Directory\",\"OUD\"],\"articleSection\":[\"Database Administration &amp; Monitoring\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/oud-oracle-unified-directory-11-1-2-3-oracle-generates-more-and-more-ldap-lookups-with-every-release\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/oud-oracle-unified-directory-11-1-2-3-oracle-generates-more-and-more-ldap-lookups-with-every-release\\\/\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/oud-oracle-unified-directory-11-1-2-3-oracle-generates-more-and-more-ldap-lookups-with-every-release\\\/\",\"name\":\"OUD \u2013 Oracle Unified Directory 11.1.2.3, Oracle generates more and more LDAP lookups with every release - dbi Blog\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#website\"},\"datePublished\":\"2017-04-06T07:50:50+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/person\\\/66ab87129f2d357f09971bc7936a77ee\"},\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/oud-oracle-unified-directory-11-1-2-3-oracle-generates-more-and-more-ldap-lookups-with-every-release\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/oud-oracle-unified-directory-11-1-2-3-oracle-generates-more-and-more-ldap-lookups-with-every-release\\\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/oud-oracle-unified-directory-11-1-2-3-oracle-generates-more-and-more-ldap-lookups-with-every-release\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"OUD \u2013 Oracle Unified Directory 11.1.2.3, Oracle generates more and more LDAP lookups with every release\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#website\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/\",\"name\":\"dbi Blog\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/person\\\/66ab87129f2d357f09971bc7936a77ee\",\"name\":\"Oracle Team\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/f711f7cd2c9b09bf2627133755b569fb5be0694810cfd33033bdd095fedba86d?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/f711f7cd2c9b09bf2627133755b569fb5be0694810cfd33033bdd095fedba86d?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/f711f7cd2c9b09bf2627133755b569fb5be0694810cfd33033bdd095fedba86d?s=96&d=mm&r=g\",\"caption\":\"Oracle Team\"},\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/author\\\/oracle-team\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"OUD \u2013 Oracle Unified Directory 11.1.2.3, Oracle generates more and more LDAP lookups with every release - dbi Blog","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.dbi-services.com\/blog\/oud-oracle-unified-directory-11-1-2-3-oracle-generates-more-and-more-ldap-lookups-with-every-release\/","og_locale":"en_US","og_type":"article","og_title":"OUD \u2013 Oracle Unified Directory 11.1.2.3, Oracle generates more and more LDAP lookups with every release","og_description":"By William Sescu After installing OUD some time ago, I was doing some tests to see how it performs, and as long as I do ldap searching on the command line it looks very good. I am running Unified Directory 11.1.2.3.170117 (latest PSU), just for the protocol and I use the OUD only for TNS [&hellip;]","og_url":"https:\/\/www.dbi-services.com\/blog\/oud-oracle-unified-directory-11-1-2-3-oracle-generates-more-and-more-ldap-lookups-with-every-release\/","og_site_name":"dbi Blog","article_published_time":"2017-04-06T07:50:50+00:00","author":"Oracle Team","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Oracle Team","Est. reading time":"9 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.dbi-services.com\/blog\/oud-oracle-unified-directory-11-1-2-3-oracle-generates-more-and-more-ldap-lookups-with-every-release\/#article","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/oud-oracle-unified-directory-11-1-2-3-oracle-generates-more-and-more-ldap-lookups-with-every-release\/"},"author":{"name":"Oracle Team","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee"},"headline":"OUD \u2013 Oracle Unified Directory 11.1.2.3, Oracle generates more and more LDAP lookups with every release","datePublished":"2017-04-06T07:50:50+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/oud-oracle-unified-directory-11-1-2-3-oracle-generates-more-and-more-ldap-lookups-with-every-release\/"},"wordCount":650,"commentCount":0,"keywords":["Oracle Unified Directory","OUD"],"articleSection":["Database Administration &amp; Monitoring"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.dbi-services.com\/blog\/oud-oracle-unified-directory-11-1-2-3-oracle-generates-more-and-more-ldap-lookups-with-every-release\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dbi-services.com\/blog\/oud-oracle-unified-directory-11-1-2-3-oracle-generates-more-and-more-ldap-lookups-with-every-release\/","url":"https:\/\/www.dbi-services.com\/blog\/oud-oracle-unified-directory-11-1-2-3-oracle-generates-more-and-more-ldap-lookups-with-every-release\/","name":"OUD \u2013 Oracle Unified Directory 11.1.2.3, Oracle generates more and more LDAP lookups with every release - dbi Blog","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/#website"},"datePublished":"2017-04-06T07:50:50+00:00","author":{"@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee"},"breadcrumb":{"@id":"https:\/\/www.dbi-services.com\/blog\/oud-oracle-unified-directory-11-1-2-3-oracle-generates-more-and-more-ldap-lookups-with-every-release\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dbi-services.com\/blog\/oud-oracle-unified-directory-11-1-2-3-oracle-generates-more-and-more-ldap-lookups-with-every-release\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.dbi-services.com\/blog\/oud-oracle-unified-directory-11-1-2-3-oracle-generates-more-and-more-ldap-lookups-with-every-release\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/www.dbi-services.com\/blog\/"},{"@type":"ListItem","position":2,"name":"OUD \u2013 Oracle Unified Directory 11.1.2.3, Oracle generates more and more LDAP lookups with every release"}]},{"@type":"WebSite","@id":"https:\/\/www.dbi-services.com\/blog\/#website","url":"https:\/\/www.dbi-services.com\/blog\/","name":"dbi Blog","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.dbi-services.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee","name":"Oracle Team","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/f711f7cd2c9b09bf2627133755b569fb5be0694810cfd33033bdd095fedba86d?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/f711f7cd2c9b09bf2627133755b569fb5be0694810cfd33033bdd095fedba86d?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/f711f7cd2c9b09bf2627133755b569fb5be0694810cfd33033bdd095fedba86d?s=96&d=mm&r=g","caption":"Oracle Team"},"url":"https:\/\/www.dbi-services.com\/blog\/author\/oracle-team\/"}]}},"_links":{"self":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/9927","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/users\/27"}],"replies":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/comments?post=9927"}],"version-history":[{"count":0,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/9927\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media?parent=9927"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/categories?post=9927"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/tags?post=9927"},{"taxonomy":"type","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/type_dbi?post=9927"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}