{"id":24965,"date":"2023-05-04T18:15:37","date_gmt":"2023-05-04T16:15:37","guid":{"rendered":"https:\/\/www.dbi-services.com\/blog\/?p=24965"},"modified":"2023-05-04T18:31:29","modified_gmt":"2023-05-04T16:31:29","slug":"patching-oda-to-19-18-error-in-sshd_config","status":"publish","type":"post","link":"https:\/\/www.dbi-services.com\/blog\/patching-oda-to-19-18-error-in-sshd_config\/","title":{"rendered":"Patching ODA to 19.18.: Error in sshd_config"},"content":{"rendered":"<p>I recently patched an Oracle Database Appliance (ODA) from 19.16. to 19.18. Detailed steps on how to patch to 19.18. are available <a href=\"https:\/\/www.dbi-services.com\/blog\/oda-version-19-18-is-available-how-to-patch\/\">here<\/a>. During the update-server step I got the following error:<\/p>\n\n\n<pre class=\"wp-block-code\"><code># odacli describe-job -i \"859c6b58-19e5-453e-96a9-f29bcc70894a\"\n\nJob details\n----------------------------------------------------------------\n                     ID:  859c6b58-19e5-453e-96a9-f29bcc70894a\n            Description:  Server Patching\n                 Status:  Failure\n                Created:  April 24, 2023 4:28:10 PM CEST\n                Message:  DCS-10001:Internal error encountered: Error in sshd_config.\n\nTask Name                                Start Time                          End Time                            Status\n---------------------------------------- ----------------------------------- ----------------------------------- ----------\nServer patching                          April 24, 2023 4:28:25 PM CEST      April 24, 2023 4:37:54 PM CEST      Failure\nValidating GI user metadata              April 24, 2023 4:28:25 PM CEST      April 24, 2023 4:28:25 PM CEST      Success\nValidate ILOM server reachable           April 24, 2023 4:28:25 PM CEST      April 24, 2023 4:28:25 PM CEST      Success\nValidate DCS Admin mTLS setup            April 24, 2023 4:28:25 PM CEST      April 24, 2023 4:28:25 PM CEST      Success\nServer patching                          April 24, 2023 4:28:26 PM CEST      April 24, 2023 4:37:54 PM CEST      Failure\nConfigure export clones resource         April 24, 2023 4:28:26 PM CEST      April 24, 2023 4:28:27 PM CEST      Success\nCreating repositories using yum          April 24, 2023 4:28:27 PM CEST      April 24, 2023 4:28:31 PM CEST      Success\nUpdating YumPluginVersionLock rpm        April 24, 2023 4:28:31 PM CEST      April 24, 2023 4:28:31 PM CEST      Success\nApplying OS Patches                      April 24, 2023 4:28:31 PM CEST      April 24, 2023 4:37:54 PM CEST      Success\nServer patching                          April 24, 2023 4:37:54 PM CEST      April 24, 2023 4:37:54 PM CEST      Failure\nModify sshd_config attribute             April 24, 2023 4:37:54 PM CEST      April 24, 2023 4:37:54 PM CEST      Failure<\/code><\/pre>\n\n\n\n<p>So obviously something is wrong with sshd_config. If an error happens when running a job on the ODA with odacli then I check the dcs agent logfile \/opt\/oracle\/dcs\/log\/dcs-agent.log. It contained the following:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>2023-04-24 16:37:54,771 DEBUG &#091;Modify sshd_config attribute : JobId=859c6b58-19e5-453e-96a9-f29bcc70894a] &#091;] c.o.d.c.u.CommonsUtils: Output :\n\/etc\/ssh\/sshd_config line 147: Directive 'Protocol' is not allowed within a Match block<\/code><\/pre>\n\n\n\n<p>At the end of the \/etc\/ssh\/sshd_config I saw those lines:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code># Example of overriding settings on a per-user basis\n#Match User anoncvs\n#       X11Forwarding no\n#       AllowTcpForwarding no\n#       PermitTTY no\n#       ForceCommand cvs server\n# BEGIN ANSIBLE MANAGED BLOCK\nMatch User user41\n  PasswordAuthentication no\nMatch User user46\n  PasswordAuthentication no\n# END ANSIBLE MANAGED BLOCK<\/code><\/pre>\n\n\n\n<p>So obviously the sshd_config file was adjusted by the customer using ansible. This update was done already a year ago and the ODA has been patched in between successfully. But why did I get an error <\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>Directive 'Protocol' is not allowed within a Match block<\/code><\/pre>\n\n\n\n<p>The line <\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>Protocol 2<\/code><\/pre>\n\n\n\n<p>was already in the file sshd_config. Unfortunately Oracle rolls back all changes in case of failure and I could not see what happened with sshd_config. In the dcs-agent.log I saw that 2 files were temporarily created to modify the sshd_config-file:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>\/opt\/oracle\/dcs\/bin\/modifySshdConfScript.sh\n\/tmp\/dcsfiles\/temp.txt<\/code><\/pre>\n\n\n\n<p>Both files were deleted as part of the cleanup of the failure. So I created a simple loop to check every second if one of above files has been created:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code># while true\n&gt; do\n&gt; cat \/opt\/oracle\/dcs\/bin\/modifySshdConfScript.sh \/tmp\/dcsfiles\/temp.txt\n&gt; sleep 1\n&gt; done\ncat: \/opt\/oracle\/dcs\/bin\/modifySshdConfScript.sh: No such file or directory\ncat: \/tmp\/dcsfiles\/temp.txt: No such file or directory\n...<\/code><\/pre>\n\n\n\n<p>While this was running I started my update-server again:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code># \/opt\/oracle\/dcs\/bin\/odacli update-server -v 19.18.0.0.0<\/code><\/pre>\n\n\n\n<p>REMARK: After the failure the clusterware was no longer running. I.e. above update-server resulted in an immediate message<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>DCS-10059:Oracle Clusterware is not running on all nodes.<\/code><\/pre>\n\n\n\n<p>To start the clusterware again I just did a reboot.<\/p>\n\n\n\n<p>After the reboot and starting my loop again (followed by the update-server in a separate session) I got this output:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code># while true\n&gt; do\n&gt; cat \/opt\/oracle\/dcs\/bin\/modifySshdConfScript.sh \/tmp\/dcsfiles\/temp.txt\n&gt; sleep 1\n&gt; done\ncat: \/opt\/oracle\/dcs\/bin\/modifySshdConfScript.sh: No such file or directory\ncat: \/tmp\/dcsfiles\/temp.txt: No such file or directory\n...\ncat: \/opt\/oracle\/dcs\/bin\/modifySshdConfScript.sh: No such file or directory\ncat: \/tmp\/dcsfiles\/temp.txt: No such file or directory\n#!\/bin\/sh\nSSHD_CONF_FILE=\/etc\/ssh\/sshd_config\nif &#091; -f \"$SSHD_CONF_FILE\" ]; then\n...\n  sed -i 's\/^&#091;^#]*Protocol\/#&amp;\/' $SSHD_CONF_FILE\n...\n  echo 'AllowTcpForwarding no' &gt;&gt; $SSHD_CONF_FILE\n  echo 'Protocol 2' &gt;&gt; $SSHD_CONF_FILE\n...\nelse\n  echo \"Unable to locate sshd config file SSHD_CONF_FILE\"\n  exit 1\nfi\n...\ncat: \/opt\/oracle\/dcs\/bin\/modifySshdConfScript.sh: No such file or directory\ncat: \/tmp\/dcsfiles\/temp.txt: No such file or directory\n...<\/code><\/pre>\n\n\n\n<p>So the issue became clear now. The existing line<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>Protocol 2<\/code><\/pre>\n\n\n\n<p>was put in comments and new lines (including the line &#8220;Protocol 2&#8221;) were added at the end of sshd_config. The line<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>Protocol 2<\/code><\/pre>\n\n\n\n<p>is not allowed in a Match Block, which has been included &#8220;open ended&#8221; with the ansible update.<\/p>\n\n\n\n<p>My workaround was to temporarily comment the Match-commands in sshd_config and then my update-server did run through:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code># BEGIN ANSIBLE MANAGED BLOCK\n#Match User user41\n#  PasswordAuthentication no\n#Match User user46\n#  PasswordAuthentication no\n# END ANSIBLE MANAGED BLOCK<\/code><\/pre>\n\n\n\n<p>Afterwards I moved above lines to the end of the sshd_config again and un-commented the lines as they were before. Then restart sshd or reboot the server.<\/p>\n\n\n\n<p>I&#8217;ve found several blogs and discussions on how to end a Match-block in sshd_config to avoid the errors I&#8217;ve seen. You may check <a href=\"https:\/\/unix.stackexchange.com\/questions\/67334\/openssh-how-to-end-a-match-block\">here<\/a> or <a href=\"https:\/\/www.suse.com\/support\/kb\/doc\/?id=000018711\">here<\/a>. Basically the customer did modify the sshd_config correctly, because Match-Blocks should be added at the end of the file. This can also been seen by the example, which was there in the default sshd_config of the ODA at the end of the file:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code># Example of overriding settings on a per-user basis\n#Match User anoncvs\n#       X11Forwarding no\n#       AllowTcpForwarding no\n#       PermitTTY no\n#       ForceCommand cvs server<\/code><\/pre>\n\n\n\n<p>Workarounds to end a Match-Block with the line &#8220;Match&#8221; should not be used anymore. Better would be to end the block with &#8220;Match All&#8221;, but even that may not be correct. So is it an Oracle bug of the ODA patching software here? Yes and No. Yes, because modifying files should be done in a way, which won&#8217;t break the syntax. No, because changes (customizations) in sshd_config should be undone before patching an ODA. So it goes back to the statement that you should not modify\/customize an Oracle Database Appliance. But if you do then undo those modifications before patching and redo them after the patch has been successfully installed.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>I recently patched an Oracle Database Appliance (ODA) from 19.16. to 19.18. Detailed steps on how to patch to 19.18. are available here. During the update-server step I got the following error: So obviously something is wrong with sshd_config. If an error happens when running a job on the ODA with odacli then I check [&hellip;]<\/p>\n","protected":false},"author":35,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[59],"tags":[],"type_dbi":[2952,2950,2954,2953,2948,2728,2949,2951],"class_list":["post-24965","post","type-post","status-publish","format-standard","hentry","category-oracle","type-etc-ssh-sshd_config","type-19-18","type-error","type-failed","type-oda","type-oracle","type-patch","type-sshd_config"],"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>Patching ODA to 19.18.: Error in sshd_config - 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\/patching-oda-to-19-18-error-in-sshd_config\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Patching ODA to 19.18.: Error in sshd_config\" \/>\n<meta property=\"og:description\" content=\"I recently patched an Oracle Database Appliance (ODA) from 19.16. to 19.18. Detailed steps on how to patch to 19.18. are available here. During the update-server step I got the following error: So obviously something is wrong with sshd_config. If an error happens when running a job on the ODA with odacli then I check [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dbi-services.com\/blog\/patching-oda-to-19-18-error-in-sshd_config\/\" \/>\n<meta property=\"og:site_name\" content=\"dbi Blog\" \/>\n<meta property=\"article:published_time\" content=\"2023-05-04T16:15:37+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-05-04T16:31:29+00:00\" \/>\n<meta name=\"author\" content=\"Clemens Bleile\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@ifgtxD2SrQ8r!YuXj\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Clemens Bleile\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"5 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\/patching-oda-to-19-18-error-in-sshd_config\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/patching-oda-to-19-18-error-in-sshd_config\/\"},\"author\":{\"name\":\"Clemens Bleile\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/0ac04011f60f2e93c115358d0789c2da\"},\"headline\":\"Patching ODA to 19.18.: Error in sshd_config\",\"datePublished\":\"2023-05-04T16:15:37+00:00\",\"dateModified\":\"2023-05-04T16:31:29+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/patching-oda-to-19-18-error-in-sshd_config\/\"},\"wordCount\":537,\"commentCount\":0,\"articleSection\":[\"Oracle\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/patching-oda-to-19-18-error-in-sshd_config\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/patching-oda-to-19-18-error-in-sshd_config\/\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/patching-oda-to-19-18-error-in-sshd_config\/\",\"name\":\"Patching ODA to 19.18.: Error in sshd_config - dbi Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#website\"},\"datePublished\":\"2023-05-04T16:15:37+00:00\",\"dateModified\":\"2023-05-04T16:31:29+00:00\",\"author\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/0ac04011f60f2e93c115358d0789c2da\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/patching-oda-to-19-18-error-in-sshd_config\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/patching-oda-to-19-18-error-in-sshd_config\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/patching-oda-to-19-18-error-in-sshd_config\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\/\/www.dbi-services.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Patching ODA to 19.18.: Error in sshd_config\"}]},{\"@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\/0ac04011f60f2e93c115358d0789c2da\",\"name\":\"Clemens Bleile\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/secure.gravatar.com\/avatar\/1f596609fc67cb28ed714e7bccc81ed4cd73b8582a8148a490c77daeb2fde21a?s=96&d=mm&r=g\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/1f596609fc67cb28ed714e7bccc81ed4cd73b8582a8148a490c77daeb2fde21a?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/1f596609fc67cb28ed714e7bccc81ed4cd73b8582a8148a490c77daeb2fde21a?s=96&d=mm&r=g\",\"caption\":\"Clemens Bleile\"},\"description\":\"Clemens Bleile has more than 30 years of IT experience, thirteen in Oracle Support and fifteen in Oracle Consulting. He is specialized in Oracle Database Performance Tuning (SQL Tuning, DB Tuning) and developing an Oracle DB IT architecture (highly available, low-maintenance, cost efficient storage of data). He is an expert in problem analysis and resolution. Prior to joining dbi services, Clemens Bleile was Manager of the EMEA Database Performance team at the Oracle Global Customer Support Services. Clemens Bleile is Oracle Certified Professional 11g, 12c and Oracle Certified Expert for Performance Management and Tuning and holds a Master Degree, Business Information Systems from the Fachhochschule Furtwangen, Germany.\",\"sameAs\":[\"https:\/\/www.dbi-services.com\",\"https:\/\/x.com\/ifgtxD2SrQ8r!YuXj\"],\"url\":\"https:\/\/www.dbi-services.com\/blog\/author\/clemens-bleile\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Patching ODA to 19.18.: Error in sshd_config - 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\/patching-oda-to-19-18-error-in-sshd_config\/","og_locale":"en_US","og_type":"article","og_title":"Patching ODA to 19.18.: Error in sshd_config","og_description":"I recently patched an Oracle Database Appliance (ODA) from 19.16. to 19.18. Detailed steps on how to patch to 19.18. are available here. During the update-server step I got the following error: So obviously something is wrong with sshd_config. If an error happens when running a job on the ODA with odacli then I check [&hellip;]","og_url":"https:\/\/www.dbi-services.com\/blog\/patching-oda-to-19-18-error-in-sshd_config\/","og_site_name":"dbi Blog","article_published_time":"2023-05-04T16:15:37+00:00","article_modified_time":"2023-05-04T16:31:29+00:00","author":"Clemens Bleile","twitter_card":"summary_large_image","twitter_creator":"@ifgtxD2SrQ8r!YuXj","twitter_misc":{"Written by":"Clemens Bleile","Est. reading time":"5 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.dbi-services.com\/blog\/patching-oda-to-19-18-error-in-sshd_config\/#article","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/patching-oda-to-19-18-error-in-sshd_config\/"},"author":{"name":"Clemens Bleile","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/0ac04011f60f2e93c115358d0789c2da"},"headline":"Patching ODA to 19.18.: Error in sshd_config","datePublished":"2023-05-04T16:15:37+00:00","dateModified":"2023-05-04T16:31:29+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/patching-oda-to-19-18-error-in-sshd_config\/"},"wordCount":537,"commentCount":0,"articleSection":["Oracle"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.dbi-services.com\/blog\/patching-oda-to-19-18-error-in-sshd_config\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dbi-services.com\/blog\/patching-oda-to-19-18-error-in-sshd_config\/","url":"https:\/\/www.dbi-services.com\/blog\/patching-oda-to-19-18-error-in-sshd_config\/","name":"Patching ODA to 19.18.: Error in sshd_config - dbi Blog","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/#website"},"datePublished":"2023-05-04T16:15:37+00:00","dateModified":"2023-05-04T16:31:29+00:00","author":{"@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/0ac04011f60f2e93c115358d0789c2da"},"breadcrumb":{"@id":"https:\/\/www.dbi-services.com\/blog\/patching-oda-to-19-18-error-in-sshd_config\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dbi-services.com\/blog\/patching-oda-to-19-18-error-in-sshd_config\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.dbi-services.com\/blog\/patching-oda-to-19-18-error-in-sshd_config\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/www.dbi-services.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Patching ODA to 19.18.: Error in sshd_config"}]},{"@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\/0ac04011f60f2e93c115358d0789c2da","name":"Clemens Bleile","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/1f596609fc67cb28ed714e7bccc81ed4cd73b8582a8148a490c77daeb2fde21a?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/1f596609fc67cb28ed714e7bccc81ed4cd73b8582a8148a490c77daeb2fde21a?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/1f596609fc67cb28ed714e7bccc81ed4cd73b8582a8148a490c77daeb2fde21a?s=96&d=mm&r=g","caption":"Clemens Bleile"},"description":"Clemens Bleile has more than 30 years of IT experience, thirteen in Oracle Support and fifteen in Oracle Consulting. He is specialized in Oracle Database Performance Tuning (SQL Tuning, DB Tuning) and developing an Oracle DB IT architecture (highly available, low-maintenance, cost efficient storage of data). He is an expert in problem analysis and resolution. Prior to joining dbi services, Clemens Bleile was Manager of the EMEA Database Performance team at the Oracle Global Customer Support Services. Clemens Bleile is Oracle Certified Professional 11g, 12c and Oracle Certified Expert for Performance Management and Tuning and holds a Master Degree, Business Information Systems from the Fachhochschule Furtwangen, Germany.","sameAs":["https:\/\/www.dbi-services.com","https:\/\/x.com\/ifgtxD2SrQ8r!YuXj"],"url":"https:\/\/www.dbi-services.com\/blog\/author\/clemens-bleile\/"}]}},"_links":{"self":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/24965","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\/35"}],"replies":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/comments?post=24965"}],"version-history":[{"count":7,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/24965\/revisions"}],"predecessor-version":[{"id":24973,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/24965\/revisions\/24973"}],"wp:attachment":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media?parent=24965"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/categories?post=24965"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/tags?post=24965"},{"taxonomy":"type","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/type_dbi?post=24965"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}