{"id":4812,"date":"2012-12-10T05:09:15","date_gmt":"2012-12-10T09:09:15","guid":{"rendered":"http:\/\/onlineappsdba.com\/?p=4812"},"modified":"2016-05-05T11:10:33","modified_gmt":"2016-05-05T15:10:33","slug":"bulkmodify-ldap-tool-usage-oid-11g","status":"publish","type":"post","link":"https:\/\/onlineappsdba.com\/index.php\/2012\/12\/10\/bulkmodify-ldap-tool-usage-oid-11g\/","title":{"rendered":"BulkModify ldap tool usage: OID 11g"},"content":{"rendered":"<p>Hi All,<\/p>\n<p>This post will give an insight about bulkmodify ldap tool. Bulk Modify ldap tool is used to modify large number of ldap entries in an efficient manner. Bulk Modify tool supports:<\/p>\n<ul>\n<li>Sub-tree based modification<\/li>\n<li>Single attribute filter such as objectclass=*<\/li>\n<li>Addition or replacing attribute values<\/li>\n<\/ul>\n<p>The bulkmodify tool performs schema checking on the specified attribute name and value pair during initialization. All entries that meet the following criteria are modified:<\/p>\n<ul>\n<li>They are under the specified subtree.<\/li>\n<li>They meet the single filter condition.<\/li>\n<li>They contain the attribute to be modified as either mandatory or optional.<\/li>\n<li>Cannot modify a single valued attribute. In this case, modify the schema to make it multi-valued attribute and fire bulkmodify command.<\/li>\n<\/ul>\n<p>There are few exceptions under which bulkmodify does not modify an attribute and they are as follows:<\/p>\n<ul>\n<li>dn<\/li>\n<li>cn<\/li>\n<li>userpassword<\/li>\n<li>orclentrylevelaci<\/li>\n<li>orclaci<\/li>\n<li>orclcertificatehash<\/li>\n<li>orclcertificatematch<\/li>\n<\/ul>\n<p><strong>Syntax:<\/strong><\/p>\n<p>bulkmodify connect=connect_string basedn=Base_DN {[add=&#8221;TRUE&#8221;|&#8221;FALSE&#8221;]|[replace=&#8221;TRUE&#8221;|&#8221;FALSE&#8221;]} attribute=attribute_name value=attribute_value [filter=filter_string] [size=transaction_size] [threads=num_of_threads] [debug=&#8221;TRUE&#8221;|&#8221;FALSE&#8221;] [encode=character_set] [verbose=&#8221;TRUE&#8221;|&#8221;FALSE&#8221;]<\/p>\n<p>The log file for bulkmodify operation can be found at $AS_INSTANCE\/diagnostics\/logs\/OID\/tools\/bulkmodify.log<\/p>\n<p><strong>Pre-requisites:<\/strong><\/p>\n<p>OID processes should be shutdown before firing bulkmodify command as otherwise it will throw an error as shown below.<\/p>\n<p><em><span style=\"color: #ff0000;\">OID Processes running on target node and entry cache is enabled Action:<br \/>\nShutdown OID Processes on target node or disable entry cache.<\/span><\/em><\/p>\n<p><strong>Our use case is as follows:<\/strong><\/p>\n<p>The OID has several realms such as cn=Employees; cn=Customers; cn=Agents and so on and each realm has several thousands of users. Some of the users has an attribute value defined. The requirement is to add a default value for all users across realms if the value is not present.<\/p>\n<p>Here the ldap filter is very important.<\/p>\n<p><em><strong><span style=\"color: #ff0000;\">.\/bulkmodify connect=&#8221;CONN_STRING&#8221; basedn=&#8221;realm&#8221; add=&#8221;TRUE&#8221; attribute=&#8221;attr_name&#8221; value=&#8221;attr_new_value&#8221; filter=&#8221;(! (attr_name=*))&#8221;<\/span><\/strong><\/em><\/p>\n<p><strong>NOTE<\/strong>: There is a space after ! character as otherwise the command will result in error<\/p>\n<p><span style=\"color: #ff0000;\">-bash: !: event not found<\/span><\/p>\n<p>Hope this helps.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Hi All, This post will give an insight about bulkmodify ldap tool. Bulk Modify ldap tool is used to modify [&hellip;]<\/p>\n","protected":false},"author":115,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"site-sidebar-layout":"default","site-content-layout":"","ast-site-content-layout":"default","site-content-style":"default","site-sidebar-style":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","theme-transparent-header-meta":"","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"default","ast-page-background-enabled":"default","ast-page-background-meta":{"desktop":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"ast-content-background-meta":{"desktop":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"footnotes":""},"categories":[436],"tags":[],"class_list":["post-4812","post","type-post","status-publish","format-standard","hentry","category-oid"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v25.8 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>BulkModify ldap tool usage: OID 11g -<\/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:\/\/onlineappsdba.com\/index.php\/2012\/12\/10\/bulkmodify-ldap-tool-usage-oid-11g\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"BulkModify ldap tool usage: OID 11g -\" \/>\n<meta property=\"og:description\" content=\"Hi All, This post will give an insight about bulkmodify ldap tool. Bulk Modify ldap tool is used to modify [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/onlineappsdba.com\/index.php\/2012\/12\/10\/bulkmodify-ldap-tool-usage-oid-11g\/\" \/>\n<meta property=\"article:published_time\" content=\"2012-12-10T09:09:15+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2016-05-05T15:10:33+00:00\" \/>\n<meta name=\"author\" content=\"Masroof Ahmad\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Masroof Ahmad\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/onlineappsdba.com\/index.php\/2012\/12\/10\/bulkmodify-ldap-tool-usage-oid-11g\/\",\"url\":\"https:\/\/onlineappsdba.com\/index.php\/2012\/12\/10\/bulkmodify-ldap-tool-usage-oid-11g\/\",\"name\":\"BulkModify ldap tool usage: OID 11g -\",\"isPartOf\":{\"@id\":\"https:\/\/onlineappsdba.com\/#website\"},\"datePublished\":\"2012-12-10T09:09:15+00:00\",\"dateModified\":\"2016-05-05T15:10:33+00:00\",\"author\":{\"@id\":\"https:\/\/onlineappsdba.com\/#\/schema\/person\/909a876ed58d400faf82caf81d61bfdb\"},\"breadcrumb\":{\"@id\":\"https:\/\/onlineappsdba.com\/index.php\/2012\/12\/10\/bulkmodify-ldap-tool-usage-oid-11g\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/onlineappsdba.com\/index.php\/2012\/12\/10\/bulkmodify-ldap-tool-usage-oid-11g\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/onlineappsdba.com\/index.php\/2012\/12\/10\/bulkmodify-ldap-tool-usage-oid-11g\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/onlineappsdba.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"BulkModify ldap tool usage: OID 11g\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/onlineappsdba.com\/#website\",\"url\":\"https:\/\/onlineappsdba.com\/\",\"name\":\"\",\"description\":\"Oracle Implementation &amp; Training Experts\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/onlineappsdba.com\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/onlineappsdba.com\/#\/schema\/person\/909a876ed58d400faf82caf81d61bfdb\",\"name\":\"Masroof Ahmad\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/onlineappsdba.com\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/10f9db7bdbbd7f9ccfbe9b2d208e5978fc28315e9c704383e639a926ea0fce5f?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/10f9db7bdbbd7f9ccfbe9b2d208e5978fc28315e9c704383e639a926ea0fce5f?s=96&d=mm&r=g\",\"caption\":\"Masroof Ahmad\"},\"url\":\"https:\/\/onlineappsdba.com\/index.php\/author\/masroof\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"BulkModify ldap tool usage: OID 11g -","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:\/\/onlineappsdba.com\/index.php\/2012\/12\/10\/bulkmodify-ldap-tool-usage-oid-11g\/","og_locale":"en_US","og_type":"article","og_title":"BulkModify ldap tool usage: OID 11g -","og_description":"Hi All, This post will give an insight about bulkmodify ldap tool. Bulk Modify ldap tool is used to modify [&hellip;]","og_url":"https:\/\/onlineappsdba.com\/index.php\/2012\/12\/10\/bulkmodify-ldap-tool-usage-oid-11g\/","article_published_time":"2012-12-10T09:09:15+00:00","article_modified_time":"2016-05-05T15:10:33+00:00","author":"Masroof Ahmad","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Masroof Ahmad","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/onlineappsdba.com\/index.php\/2012\/12\/10\/bulkmodify-ldap-tool-usage-oid-11g\/","url":"https:\/\/onlineappsdba.com\/index.php\/2012\/12\/10\/bulkmodify-ldap-tool-usage-oid-11g\/","name":"BulkModify ldap tool usage: OID 11g -","isPartOf":{"@id":"https:\/\/onlineappsdba.com\/#website"},"datePublished":"2012-12-10T09:09:15+00:00","dateModified":"2016-05-05T15:10:33+00:00","author":{"@id":"https:\/\/onlineappsdba.com\/#\/schema\/person\/909a876ed58d400faf82caf81d61bfdb"},"breadcrumb":{"@id":"https:\/\/onlineappsdba.com\/index.php\/2012\/12\/10\/bulkmodify-ldap-tool-usage-oid-11g\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/onlineappsdba.com\/index.php\/2012\/12\/10\/bulkmodify-ldap-tool-usage-oid-11g\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/onlineappsdba.com\/index.php\/2012\/12\/10\/bulkmodify-ldap-tool-usage-oid-11g\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/onlineappsdba.com\/"},{"@type":"ListItem","position":2,"name":"BulkModify ldap tool usage: OID 11g"}]},{"@type":"WebSite","@id":"https:\/\/onlineappsdba.com\/#website","url":"https:\/\/onlineappsdba.com\/","name":"","description":"Oracle Implementation &amp; Training Experts","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/onlineappsdba.com\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/onlineappsdba.com\/#\/schema\/person\/909a876ed58d400faf82caf81d61bfdb","name":"Masroof Ahmad","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/onlineappsdba.com\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/10f9db7bdbbd7f9ccfbe9b2d208e5978fc28315e9c704383e639a926ea0fce5f?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/10f9db7bdbbd7f9ccfbe9b2d208e5978fc28315e9c704383e639a926ea0fce5f?s=96&d=mm&r=g","caption":"Masroof Ahmad"},"url":"https:\/\/onlineappsdba.com\/index.php\/author\/masroof\/"}]}},"_links":{"self":[{"href":"https:\/\/onlineappsdba.com\/index.php\/wp-json\/wp\/v2\/posts\/4812","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/onlineappsdba.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/onlineappsdba.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/onlineappsdba.com\/index.php\/wp-json\/wp\/v2\/users\/115"}],"replies":[{"embeddable":true,"href":"https:\/\/onlineappsdba.com\/index.php\/wp-json\/wp\/v2\/comments?post=4812"}],"version-history":[{"count":0,"href":"https:\/\/onlineappsdba.com\/index.php\/wp-json\/wp\/v2\/posts\/4812\/revisions"}],"wp:attachment":[{"href":"https:\/\/onlineappsdba.com\/index.php\/wp-json\/wp\/v2\/media?parent=4812"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/onlineappsdba.com\/index.php\/wp-json\/wp\/v2\/categories?post=4812"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/onlineappsdba.com\/index.php\/wp-json\/wp\/v2\/tags?post=4812"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}