{"id":39018,"date":"2025-06-03T22:41:36","date_gmt":"2025-06-03T20:41:36","guid":{"rendered":"https:\/\/www.dbi-services.com\/blog\/?p=39018"},"modified":"2025-06-12T10:07:50","modified_gmt":"2025-06-12T08:07:50","slug":"exacc-cs-modify-database-parameters-in-batch-mode-using-dbaascli","status":"publish","type":"post","link":"https:\/\/www.dbi-services.com\/blog\/exacc-cs-modify-database-parameters-in-batch-mode-using-dbaascli\/","title":{"rendered":"ExaCC\/CS: modify database parameters in batch mode using dbaascli"},"content":{"rendered":"\n<p>This post briefly describes how to use a JSON responseFIle to modify (container) database parameters on Oracle Cloud ExaCC\/ExaCS service.<\/p>\n\n\n\n<p><\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-what-are-our-options-with-dbaascli\">What are our options with dbaascli? <\/h2>\n\n\n\n<p>Well, we can simply go ahead and apply single changes one by one.<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: bash; title: ; notranslate\" title=\"\">\ntime sudo dbaascli database modifyParameters --dbname CDBZ001T\u00a0 --setParameters _fix_control=&quot;23473108:off&quot;\n\nDBAAS CLI version 25.1.2.0.0\n\nExecuting command database modifyParameters --dbname CDBZ001T --setParameters _fix_control=23473108:off&lt;br&gt;&lt;br&gt;Job id: c5f5e1ba-39b6-4ab1-a5fa-c7f1211c037a\nSession log: \/var\/opt\/oracle\/log\/CDBZ001T\/database\/modifyParameters\/dbaastools_2025-06-03_09-15-44-PM_220508.log\n\nLoading PILOT...\nSession ID of the current execution is: 18947&lt;br&gt;&lt;br&gt;Log file location: \/var\/opt\/oracle\/log\/CDBZ001T\/database\/modifyParameters\/pilot_2025-06-03_09-15-48-PM_220935\n-----------------\nRunning Plugin_Initialize job\nCompleted Plugin_Initialize job\n-----------------\nRunning Validate_Parameters job\nCompleted Validate_Parameters job\n-----------------\nRunning Apply_Dynamic_Parameters_Changes job\nCompleted Apply_Dynamic_Parameters_Changes job\n-----------------\nRunning Apply_Static_Parameters_Changes job\nCompleted Apply_Static_Parameters_Changes job\n\ndbaascli execution completed\n\nreal\u00a0\u00a0\u00a0 0m20.481s\nuser\u00a0\u00a0\u00a0 0m0.007s\nsys\u00a0\u00a0\u00a0\u00a0 0m0.008s\n<\/pre><\/div>\n\n\n<p><br>What a lucky test, we just set a single hidden parameter without any database restart. But hold on, more then 20 seconds to run a simple ALTER SYSTEM that&#8217;s okay but not pretty fast. A database restart was even unnecessary for this testcase.<br><\/p>\n\n\n\n<p>Well, the best is always to check the Oracle documentation first. Especially, the section about <a href=\"https:\/\/docs.oracle.com\/en-us\/iaas\/exadatacloud\/doc\/ecs-using-dbaascli.html#GUID-68FAA07E-588E-45C8-9144-5C413EA0B555\">&#8220;dbaascli database modifyParameters&#8221;<\/a><\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>dbaascli database modifyParameters --dbname &lt;value&gt; --setParameters &lt;values&gt;| --resetParameters &lt;values&gt; | <strong>--responseFile<\/strong>\n&#091;--backupPrepared]\n&#091;--instance]\n&#091;--allowBounce]\n\n<strong>--responseFile<\/strong> specifies the absolute location of the response JSON file to modify the database parameters \n\n<\/code><\/pre>\n\n\n\n<p>We Oracle DBA folk do certainly understand what is meant when there is a mention about a responseFile \ud83d\ude42 <\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-where-is-the-reponsefile-option-gone\">Where is the &#8211;reponseFile option gone? <\/h2>\n\n\n\n<p>Well, at the time of writing this article we are using the latest Oracle CloudToolings version available (RPM: dbaastools_exa-1.0-25.1.2.0.0_250505.1725.x86_64) but the option isn&#8217;t referenced in the command-line synoposis<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: bash; title: ; notranslate\" title=\"\">\n# dbaascli database modifyParameters --help\nDBAAS CLI version 25.1.2.0.0\nExecuting command database modifyParameters --help\n    database modifyParameters - modifies or resets initialization parameters for a given Oracle database.\n\n      Usage: dbaascli database modifyParameters --dbname &lt;value&gt;\n        {\n            --setParameters &lt;value&gt; &#x5B;--instance &lt;value&gt;] &#x5B;--backupPrepared] &#x5B;--allowBounce]\n            | --resetParameters &lt;value&gt; &#x5B;--instance &lt;value&gt;] &#x5B;--backupPrepared] &#x5B;--allowBounce]\n        }\n        &#x5B;--waitForCompletion &lt;value&gt;]\n\n      Where:\n        --dbname - Oracle database name.\n        --setParameters | --resetParameters\n        --setParameters - comma separated list of parameters to be modified with new values. For blank values use &#039;&#039;. E.g. parameter1=valueA,parameter2=&#039;&#039;,etc.\n            &#x5B;--instance - name of the instance on which the parameters will be processed. If not specified, the operation will be performed at the database level.]\n            &#x5B;--backupPrepared - flag to acknowledge that a proper database backup is in place prior to modifying critical or sensitive parameters.]\n            &#x5B;--allowBounce - flag to grant permission to bounce the database in order to reflect the changes on applicable static parameters.]\n        --resetParameters - comma separated list of parameters to be reset to their corresponding default values. E.g. parameter1,parameter2,etc.\n            &#x5B;--instance - name of the instance on which the parameters will be processed. If not specified, the operation will be performed at the database level.]\n            &#x5B;--backupPrepared - flag to acknowledge that a proper database backup is in place prior to modifying critical or sensitive parameters.]\n            &#x5B;--allowBounce - flag to grant permission to bounce the database in order to reflect the changes on applicable static parameters.]\n        &#x5B;--waitForCompletion - specifies false to run the operation in background. Valid values : true|false.]\n\n<\/pre><\/div>\n\n\n<h2 class=\"wp-block-heading\" id=\"h-how-to-use-the-json-file\">How to use the JSON file?<\/h2>\n\n\n\n<p>Well, here due to the inaccurate information and misleading Synopsis we had to strike back with Oracle support. Indeed, How shall the JSON being formatted ? Which combination are required to &#8220;&#8211;setParameters&#8221; or &#8220;&#8211;resetParameters&#8221; a parameter.<\/p>\n\n\n\n<p>Finally, after some internal research the Oracle support came back (after a while) with the expected JSON format<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: yaml; title: ; notranslate\" title=\"\">\n{\n&quot;setParameters&quot;:&quot;param1=value,param2=value,param3=value&quot;\n}\n<\/pre><\/div>\n\n\n<p>Sounds pretty logic if you omit all information from Oracle documenation and &#8220;dbaascli database modifyParameters&#8221; command synopsis.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-dbaascli-option-allowbounce\">dbaascli option &#8220;&#8211;allowBounce&#8221;<\/h2>\n\n\n\n<p>Changing sequentially static database parameters and restarting the  the container database may drastically increase the configuration of (container) database depending on the amount of parameters to modify.<br><br>As such, the combination between the dbaascli &#8220;&#8211;responseFile&#8221; and &#8211;allowBounce&#8221; is an excellent comprise to apply them all at once (batch processing).<\/p>\n\n\n\n<p>And indeed, Oracle executes in background an &#8220;ALTER SYSTEM &#8230; SCOPE=SPFILE&#8221; for all static parameters which requires are database restart. Of course, the restart occurs only once.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-are-we-obligated-to-use-dbaascli\">Are we obligated to use dbaascli ? <\/h2>\n\n\n\n<p>Luckily not, but they are a lot of automation running in background. For instance, if you do not the by yourself the Oracle System Global Area (aka. SGA) anytime you reshape the VMcluster memory, the Oracle SGA will be implicitly reshaped too. <\/p>\n\n\n\n<p>You can check all of them by using following command<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: yaml; title: ; notranslate\" title=\"\">\n# sudo dbaascli database getDetails --dbname CDBZ001T\n\n&lt;snipped truncated for readability&gt;\n  &quot;dbName&quot; : &quot;CDBZ001T&quot;,\n  &quot;dbUniqueName&quot; : &quot;CDBZ001T_SITE2&quot;,\n  &quot;dbDomain&quot; : &quot;jewlab.ch&quot;,\n  &quot;dbId&quot; : 3776747013,\n  &quot;cpuCount&quot; : 12,\n  &quot;sgaTarget&quot; : &quot;8192MB&quot;,\n  &quot;pgaAggregateTarget&quot; : &quot;5000MB&quot;,\n  &quot;dbSize&quot; : &quot;7141GB&quot;,\n\n&lt;snipped truncated for readability&gt;\n<\/pre><\/div>\n\n\n<p>Knowing, this you may think about some basic configuration-as-code techniques to manage database parameters.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-wrap-up-amp-caveats\">Wrap-up &amp; Caveats<\/h2>\n\n\n\n<p>Using JSON  to manage database parameters is quite cool as it can be the starting to point for any kind of configuration as code and even enable documentation-as-code techniques. <\/p>\n\n\n\n<p>Imagine maintaining all your database parameters over a simple YAML file.<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: yaml; title: ; notranslate\" title=\"\">\n  - name: &quot;db_files&quot;\n    value: &quot;8192&quot;\n    bounce_db: true\n    description: &quot;Oracle Bug 33888381 - ORA-1152 after Flashback Pluggable Database (Doc ID 33888381.8)&quot;\n<\/pre><\/div>\n\n\n<p>As usual, we have always exceptions with Oracle \ud83d\ude09 <\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>dbaascli expect a list of comma separated parameters. <br><br><code>--setParameters<\/code> specifies a comma-delimited list of parameters to modify with new values. For example: <code>parameter1=valueA<\/code>,<code>parameter2=valueB<\/code>, and so on. For blank values use parameter1=valueA,parameter2=&#8221;,etc.<br><br>As such,  you can&#8217;t apply with dbaascli parameter with multiple values such as hidden parameter &#8220;_fix_control&#8221;, but this applies to parameters like event, db_file_name_convert, aso &#8230;<br><\/li>\n\n\n\n<li> dbaascli can&#8217;t apply multiple times the same modification at least for parameter db_domain it fails (all the other we tested ran fine)<br><br>Running Validate_Parameters job<br>Execution of Validate_Parameters failed<br>[FATAL] [DBAAS-70154] The modification of the following parameter is not allowed: db_domain.<br>\u00a0\u00a0 ACTION: Verify the requested parameter and try again.<br>*** Executing jobs which need to be run always&#8230; ***<br><br><\/li>\n<\/ul>\n\n\n\n<p>Enjoy!<\/p>\n\n\n\n<p><\/p>\n\n\n\n<p><\/p>\n\n\n\n<p><\/p>\n","protected":false},"excerpt":{"rendered":"<p>This post briefly describes how to use a JSON responseFIle to modify (container) database parameters on Oracle Cloud ExaCC\/ExaCS service. What are our options with dbaascli? Well, we can simply go ahead and apply single changes one by one. What a lucky test, we just set a single hidden parameter without any database restart. But [&hellip;]<\/p>\n","protected":false},"author":25,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[955,3624,2966,59],"tags":[135,3413,2598],"type_dbi":[],"class_list":["post-39018","post","type-post","status-publish","format-standard","hentry","category-cloud","category-exacc-oracle","category-oci","category-oracle","tag-cloud","tag-dbaascli","tag-exacc-3"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v27.2 (Yoast SEO v27.2) - https:\/\/yoast.com\/product\/yoast-seo-premium-wordpress\/ -->\n<title>ExaCC\/CS: modify database parameters in batch mode using dbaascli - dbi Blog<\/title>\n<meta name=\"description\" content=\"using json to improve your efficiciency\" \/>\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\/exacc-cs-modify-database-parameters-in-batch-mode-using-dbaascli\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"ExaCC\/CS: modify database parameters in batch mode using dbaascli\" \/>\n<meta property=\"og:description\" content=\"using json to improve your efficiciency\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dbi-services.com\/blog\/exacc-cs-modify-database-parameters-in-batch-mode-using-dbaascli\/\" \/>\n<meta property=\"og:site_name\" content=\"dbi Blog\" \/>\n<meta property=\"article:published_time\" content=\"2025-06-03T20:41:36+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-06-12T08:07:50+00:00\" \/>\n<meta name=\"author\" content=\"J\u00e9r\u00f4me Witt\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"J\u00e9r\u00f4me Witt\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 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\/exacc-cs-modify-database-parameters-in-batch-mode-using-dbaascli\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/exacc-cs-modify-database-parameters-in-batch-mode-using-dbaascli\/\"},\"author\":{\"name\":\"J\u00e9r\u00f4me Witt\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/a2d3ecddaf732850101a39b9d62c31b7\"},\"headline\":\"ExaCC\/CS: modify database parameters in batch mode using dbaascli\",\"datePublished\":\"2025-06-03T20:41:36+00:00\",\"dateModified\":\"2025-06-12T08:07:50+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/exacc-cs-modify-database-parameters-in-batch-mode-using-dbaascli\/\"},\"wordCount\":570,\"commentCount\":0,\"keywords\":[\"Cloud\",\"dbaascli\",\"exacc\"],\"articleSection\":[\"Cloud\",\"ExaCC\",\"OCI\",\"Oracle\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/exacc-cs-modify-database-parameters-in-batch-mode-using-dbaascli\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/exacc-cs-modify-database-parameters-in-batch-mode-using-dbaascli\/\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/exacc-cs-modify-database-parameters-in-batch-mode-using-dbaascli\/\",\"name\":\"ExaCC\/CS: modify database parameters in batch mode using dbaascli - dbi Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#website\"},\"datePublished\":\"2025-06-03T20:41:36+00:00\",\"dateModified\":\"2025-06-12T08:07:50+00:00\",\"author\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/a2d3ecddaf732850101a39b9d62c31b7\"},\"description\":\"using json to improve your efficiciency\",\"breadcrumb\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/exacc-cs-modify-database-parameters-in-batch-mode-using-dbaascli\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/exacc-cs-modify-database-parameters-in-batch-mode-using-dbaascli\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/exacc-cs-modify-database-parameters-in-batch-mode-using-dbaascli\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\/\/www.dbi-services.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"ExaCC\/CS: modify database parameters in batch mode using dbaascli\"}]},{\"@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\/a2d3ecddaf732850101a39b9d62c31b7\",\"name\":\"J\u00e9r\u00f4me Witt\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/secure.gravatar.com\/avatar\/17095c081578ca53f52ec4030ba2bde72cc18badb325cd2ba1ee2831106507ad?s=96&d=mm&r=g\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/17095c081578ca53f52ec4030ba2bde72cc18badb325cd2ba1ee2831106507ad?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/17095c081578ca53f52ec4030ba2bde72cc18badb325cd2ba1ee2831106507ad?s=96&d=mm&r=g\",\"caption\":\"J\u00e9r\u00f4me Witt\"},\"description\":\"J\u00e9rome Witt started his Consultant career a few years ago. He is specialized in database and infrastructure management, engineering, and optimization. He is very skilled in Oracle high availability, backup &amp; recovery, and tuning technologies. His expertise also includes the open source field (Linux\/Unix), advanced Perl, Shell, Windows PowerShell programming, and Automation tools (UC4). J\u00e9r\u00f4me Witt is Oracle Certified Professional 11g (OCP 11g), Oracle Certified Expert Tuning (OCE), and ITIL V3 Foundation certified. Prior to joining dbi services, J\u00e9r\u00f4me Witt was Consultant at Trivadis in Basel. He also worked as a Junior Automation specialist at Selmoni AG in Basel. J\u00e9r\u00f4me Witt holds a BTS degree in Information Systems and Industrial Networks from France. His branch-related experience covers Pharma, Health Care, Banking &amp; Financial Services, Energy, Automotive etc.\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/author\/jerome-witt\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"ExaCC\/CS: modify database parameters in batch mode using dbaascli - dbi Blog","description":"using json to improve your efficiciency","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\/exacc-cs-modify-database-parameters-in-batch-mode-using-dbaascli\/","og_locale":"en_US","og_type":"article","og_title":"ExaCC\/CS: modify database parameters in batch mode using dbaascli","og_description":"using json to improve your efficiciency","og_url":"https:\/\/www.dbi-services.com\/blog\/exacc-cs-modify-database-parameters-in-batch-mode-using-dbaascli\/","og_site_name":"dbi Blog","article_published_time":"2025-06-03T20:41:36+00:00","article_modified_time":"2025-06-12T08:07:50+00:00","author":"J\u00e9r\u00f4me Witt","twitter_card":"summary_large_image","twitter_misc":{"Written by":"J\u00e9r\u00f4me Witt","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.dbi-services.com\/blog\/exacc-cs-modify-database-parameters-in-batch-mode-using-dbaascli\/#article","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/exacc-cs-modify-database-parameters-in-batch-mode-using-dbaascli\/"},"author":{"name":"J\u00e9r\u00f4me Witt","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/a2d3ecddaf732850101a39b9d62c31b7"},"headline":"ExaCC\/CS: modify database parameters in batch mode using dbaascli","datePublished":"2025-06-03T20:41:36+00:00","dateModified":"2025-06-12T08:07:50+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/exacc-cs-modify-database-parameters-in-batch-mode-using-dbaascli\/"},"wordCount":570,"commentCount":0,"keywords":["Cloud","dbaascli","exacc"],"articleSection":["Cloud","ExaCC","OCI","Oracle"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.dbi-services.com\/blog\/exacc-cs-modify-database-parameters-in-batch-mode-using-dbaascli\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dbi-services.com\/blog\/exacc-cs-modify-database-parameters-in-batch-mode-using-dbaascli\/","url":"https:\/\/www.dbi-services.com\/blog\/exacc-cs-modify-database-parameters-in-batch-mode-using-dbaascli\/","name":"ExaCC\/CS: modify database parameters in batch mode using dbaascli - dbi Blog","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/#website"},"datePublished":"2025-06-03T20:41:36+00:00","dateModified":"2025-06-12T08:07:50+00:00","author":{"@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/a2d3ecddaf732850101a39b9d62c31b7"},"description":"using json to improve your efficiciency","breadcrumb":{"@id":"https:\/\/www.dbi-services.com\/blog\/exacc-cs-modify-database-parameters-in-batch-mode-using-dbaascli\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dbi-services.com\/blog\/exacc-cs-modify-database-parameters-in-batch-mode-using-dbaascli\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.dbi-services.com\/blog\/exacc-cs-modify-database-parameters-in-batch-mode-using-dbaascli\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/www.dbi-services.com\/blog\/"},{"@type":"ListItem","position":2,"name":"ExaCC\/CS: modify database parameters in batch mode using dbaascli"}]},{"@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\/a2d3ecddaf732850101a39b9d62c31b7","name":"J\u00e9r\u00f4me Witt","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/17095c081578ca53f52ec4030ba2bde72cc18badb325cd2ba1ee2831106507ad?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/17095c081578ca53f52ec4030ba2bde72cc18badb325cd2ba1ee2831106507ad?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/17095c081578ca53f52ec4030ba2bde72cc18badb325cd2ba1ee2831106507ad?s=96&d=mm&r=g","caption":"J\u00e9r\u00f4me Witt"},"description":"J\u00e9rome Witt started his Consultant career a few years ago. He is specialized in database and infrastructure management, engineering, and optimization. He is very skilled in Oracle high availability, backup &amp; recovery, and tuning technologies. His expertise also includes the open source field (Linux\/Unix), advanced Perl, Shell, Windows PowerShell programming, and Automation tools (UC4). J\u00e9r\u00f4me Witt is Oracle Certified Professional 11g (OCP 11g), Oracle Certified Expert Tuning (OCE), and ITIL V3 Foundation certified. Prior to joining dbi services, J\u00e9r\u00f4me Witt was Consultant at Trivadis in Basel. He also worked as a Junior Automation specialist at Selmoni AG in Basel. J\u00e9r\u00f4me Witt holds a BTS degree in Information Systems and Industrial Networks from France. His branch-related experience covers Pharma, Health Care, Banking &amp; Financial Services, Energy, Automotive etc.","url":"https:\/\/www.dbi-services.com\/blog\/author\/jerome-witt\/"}]}},"_links":{"self":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/39018","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\/25"}],"replies":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/comments?post=39018"}],"version-history":[{"count":5,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/39018\/revisions"}],"predecessor-version":[{"id":39023,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/39018\/revisions\/39023"}],"wp:attachment":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media?parent=39018"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/categories?post=39018"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/tags?post=39018"},{"taxonomy":"type","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/type_dbi?post=39018"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}