{"id":27154,"date":"2023-08-07T22:38:51","date_gmt":"2023-08-07T20:38:51","guid":{"rendered":"https:\/\/www.dbi-services.com\/blog\/?p=27154"},"modified":"2023-08-14T08:04:29","modified_gmt":"2023-08-14T06:04:29","slug":"oci-automate-your-oracle-cloud-database-software-releases-deployment-db-home","status":"publish","type":"post","link":"https:\/\/www.dbi-services.com\/blog\/oci-automate-your-oracle-cloud-database-software-releases-deployment-db-home\/","title":{"rendered":"OCI: Automate your Oracle Cloud Database software releases deployment (db-home)"},"content":{"rendered":"\n<p>As part of a very exciting project around Oracle Exadata Cloud @ Customer (aka. ExaCC) technology, we wanted to rollout in an automated manner the database software aka. ORACLE_HOME on ExaCC database clusters (aka. VM cluster). However, we rapidly identified a small lack of command-line parameters to &#8220;mimic&#8221; the console behavior. <\/p>\n\n\n\n<p>This post describes briefly how to get rid of this &#8220;limitation&#8221; and applies to various kind of OCI Database services deployments (ExaCC, ExaCS, DBsystems) except Oracle Autonomous database.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-the-magic-oci-console-button-display-all-available-versions\">The magic OCI console button &#8220;Display all available versions&#8221; <\/h2>\n\n\n\n<p>Indeed, it sounds obvious that DBAs wanna to deploy Oracle database instances on top of the latest Oracle database software available! However, we do also like to validate\/ensure the database Release Update number.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"578\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2023\/08\/Screenshot-2023-08-07-at-18.13.49-1024x578.png\" alt=\"\" class=\"wp-image-27156\" srcset=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2023\/08\/Screenshot-2023-08-07-at-18.13.49-1024x578.png 1024w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2023\/08\/Screenshot-2023-08-07-at-18.13.49-300x169.png 300w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2023\/08\/Screenshot-2023-08-07-at-18.13.49-768x433.png 768w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2023\/08\/Screenshot-2023-08-07-at-18.13.49-1536x867.png 1536w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2023\/08\/Screenshot-2023-08-07-at-18.13.49-2048x1155.png 2048w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-let-s-mimic-the-console-with-oci-cli\">Let&#8217;s &#8220;mimic&#8221; the Console with OCI-cli<\/h2>\n\n\n\n<p>According to the oci-cli documentation supplied database versions should be visible using &#8220;<a href=\"https:\/\/docs.oracle.com\/en-us\/iaas\/tools\/oci-cli\/3.30.1\/oci_cli_docs\/cmdref\/db\/db-home\/list.html\">oci db version list<\/a>&#8221; <\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>jew@dbi-X-Geissberg ~ % <strong>oci db version list --compartment-id ${<strong>OCI_CLI_TENANCY<\/strong>} --query \"data&#091;*].{version: version, \\\"is-latest-for-major-version\\\": \\\"is-latest-for-major-version\\\"}\"<\/strong>\n&#091;\n{\n\"is-latest-for-major-version\": true,\n\"version\": \"11.2.0.4\"\n},\n{\n\"is-latest-for-major-version\": true,\n\"version\": \"12.1.0.2\"\n},\n{\n\"is-latest-for-major-version\": true,\n\"version\": \"12.2.0.1\"\n},\n{\n\"is-latest-for-major-version\": true,\n\"version\": \"18.0.0.0\"\n},\n{\n\"is-latest-for-major-version\": true,\n\"version\": \"19.0.0.0\"\n},\n{\n\"is-latest-for-major-version\": true,\n\"version\": \"21.0.0.0\"\n}\n]<\/code><\/pre>\n\n\n\n<p>However, neither the documentation nor the CLI results shows any Release Updates information.<\/p>\n\n\n\n<p>The same, applies to the HashiCorp #Terraform data source and #Ansible modules <\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Terraform data source: <a href=\"https:\/\/registry.terraform.io\/providers\/oracle\/oci\/latest\/docs\/data-sources\/database_db_versions\">oci_database_db_versions<\/a> <\/li>\n\n\n\n<li>Ansible module: <a href=\"https:\/\/oci-ansible-collection.readthedocs.io\/en\/latest\/collections\/oracle\/oci\/oci_database_db_version_facts_module.html#ansible-collections-oracle-oci-oci-database-db-version-facts-module\">oracle.oci.oci_database_db_version_facts<\/a><\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-so-what-let-s-try-to-to-talk-to-oci-database-restapis-directly\">So, what? Let&#8217;s try to to talk to OCI Database RestAPIs directly<\/h2>\n\n\n\n<p>Well, let&#8217;s give a try to postman to walk though the Database Service API endpoints. Unfortunately, there is no <a href=\"https:\/\/www.postman.com\/oracledevs\/workspace\/oracle-cloud-infrastructure-rest-apis\/overview\">postman OCI collection for the Database service API<\/a>.  <br><br>Same result, while walking though the <a href=\"https:\/\/docs.oracle.com\/en-us\/iaas\/api\/#\/en\/database\/20160918\/DbVersionSummary\/ListDbVersions\">OCI Database Service API &#8220;ListDbVersions&#8221; endpoint<\/a> documentation.<\/p>\n\n\n\n<p>However, while looking at the &#8220;dbaascli&#8221; commands we could reverse engineer the RestAPI calls and extrapolate the correct URI to interact with OCI. Furthermore, a blog from another DBA colleague <a href=\"https:\/\/prostrednyp.medium.com\/oci-dbcs-patching-using-software-images-via-rest-api-595a1458d5ff\">Peter Prostredny<\/a> gave us some really worth inputs! <\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-ansible-builtin-uri-module-to-talk-with-oci-database-restapis\">ansible.builtin.uri  module to talk with OCI Database RestAPIs<\/h2>\n\n\n\n<pre class=\"wp-block-code\"><code>- name: List Oracle supplied database Release Updates available\n  <strong>ansible.builtin.uri:<\/strong>\n    url: \"https:\/\/{{ host }}{{ rest_api }}\"\n    method: GET\n    return_content: true\n    headers:\n      date: \"{{ date }}\"\n      Authorization: 'Signature version=\"1\", keyId=\"{{ key_id }}\", algorithm=\"rsa-sha256\",headers=\"(request-target) date host\",signature=\"{{ signature }}\"'\n  vars:\n    host: \"database.{{ oci_region }}.oraclecloud.com\"\n    rest_api: \"\/20160918\/dbVersions\/19.0.0.0\/minorVersions?compartmentId={{ oci_tenant_id }}\"\n    #\n    key_id: \"{{ oci_tenant_id }}\/{{ oci_user_id }}\/{{ oci_user_fingerprint }}\"\ndate: \"{{\u00a0now(utc=True).strftime('%a, %d %b %Y %H:%M:%S') }} GMT\"\n\n    date_header: \"date: {{ date }}\"\n    host_header: \"host: {{ host }}\"\n    request_target: \"(request-target): get {{ rest_api }}\"\n    signing_string: \"{{ request_target }}\\n{{ date_header }}\\n{{ host_header }}\"\n    headers: \"(request-target) date host\"\n    signature: \"{{ reg_signature.stdout }}\"\n  register: reg_call_results<\/code><\/pre>\n\n\n\n<p>However, the aforementioned solution is not really &#8220;easy&#8221; to read (and maintain). Furthermore, it requires additional tweaks to publish OCI credentials and manage some &#8220;time skew&#8221; issues between your client and OCI.<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">{\"code\":\"NotAuthenticated\",\"message\":\"Date 'Mon, 07 Aug 2023 20:28:26 UTC' is not within allowed clock skew. Current 'Mon, 07 Aug 2023 20:33:27 UTC', valid datetime range: ['Mon, 07 Aug 2023 20:28:27 UTC', 'Mon, 07 Aug 2023 20:38:28 UTC']\"}<\/pre>\n\n\n\n<p>Thus, we moved forward looking at the oci-cli  command &#8220;<a href=\"https:\/\/docs.oracle.com\/en-us\/iaas\/tools\/oci-cli\/3.30.1\/oci_cli_docs\/cmdref\/raw-request.html\">oci raw-request<\/a>&#8220;.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-talking-with-oci-database-service-api-endpoints-using-oci-cli-raw-request\">Talking with OCI Database service API endpoints using oci-cli raw request<\/h2>\n\n\n\n<p>Indeed, oci-cli &#8220;raw-request&#8221; mode seems to a good practice as we can expose credentials through the same mechanism as for the Ansible oracle.oci collection modules without any special treatment.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>jew@dbi-X-Geissberg ~ % <strong>oci raw-request --http-method GET --target-uri \"https:\/\/database.eu-zurich-1.oraclecloud.com\/20160918\/dbVersions\/19.0.0.0\/minorVersions?compartmentId=${OCI_CLI_TENANCY}\"<\/strong> | jq '.data&#091;]' | jq '{ version: .version }'\n{\n\"version\": \"19.17.0.0\"\n}\n{\n\"version\": \"19.18.0.0\"\n}\n{\n\"version\": \"19.19.0.0\"\n}<\/code><\/pre>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-the-end\">The end<\/h2>\n\n\n\n<p>Really? This is of course only the begin of your Journey \ud83d\ude42 But now, you should be able to start deploying Oracle Home&#8217;s on your VMclusters, DBsystems or creating your own customer Oracle Cloud database software images.<br><br>Enjoy!<\/p>\n","protected":false},"excerpt":{"rendered":"<p>As part of a very exciting project around Oracle Exadata Cloud @ Customer (aka. ExaCC) technology, we wanted to rollout in an automated manner the database software aka. ORACLE_HOME on ExaCC database clusters (aka. VM cluster). However, we rapidly identified a small lack of command-line parameters to &#8220;mimic&#8221; the console behavior. This post describes briefly [&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":[1321,955,198,1320,2966,59],"tags":[150,1375,96],"type_dbi":[],"class_list":["post-27154","post","type-post","status-publish","format-standard","hentry","category-ansible","category-cloud","category-database-management","category-devops","category-oci","category-oracle","tag-ansible","tag-oci","tag-oracle"],"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>OCI: Automate your Oracle Cloud Database software releases deployment (db-home) - 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\/oci-automate-your-oracle-cloud-database-software-releases-deployment-db-home\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"OCI: Automate your Oracle Cloud Database software releases deployment (db-home)\" \/>\n<meta property=\"og:description\" content=\"As part of a very exciting project around Oracle Exadata Cloud @ Customer (aka. ExaCC) technology, we wanted to rollout in an automated manner the database software aka. ORACLE_HOME on ExaCC database clusters (aka. VM cluster). However, we rapidly identified a small lack of command-line parameters to &#8220;mimic&#8221; the console behavior. This post describes briefly [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dbi-services.com\/blog\/oci-automate-your-oracle-cloud-database-software-releases-deployment-db-home\/\" \/>\n<meta property=\"og:site_name\" content=\"dbi Blog\" \/>\n<meta property=\"article:published_time\" content=\"2023-08-07T20:38:51+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-08-14T06:04:29+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2023\/08\/Screenshot-2023-08-07-at-18.13.49-1024x578.png\" \/>\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=\"2 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\\\/oci-automate-your-oracle-cloud-database-software-releases-deployment-db-home\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/oci-automate-your-oracle-cloud-database-software-releases-deployment-db-home\\\/\"},\"author\":{\"name\":\"J\u00e9r\u00f4me Witt\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/person\\\/a2d3ecddaf732850101a39b9d62c31b7\"},\"headline\":\"OCI: Automate your Oracle Cloud Database software releases deployment (db-home)\",\"datePublished\":\"2023-08-07T20:38:51+00:00\",\"dateModified\":\"2023-08-14T06:04:29+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/oci-automate-your-oracle-cloud-database-software-releases-deployment-db-home\\\/\"},\"wordCount\":422,\"commentCount\":0,\"image\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/oci-automate-your-oracle-cloud-database-software-releases-deployment-db-home\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/sites\\\/2\\\/2023\\\/08\\\/Screenshot-2023-08-07-at-18.13.49-1024x578.png\",\"keywords\":[\"Ansible\",\"OCI\",\"Oracle\"],\"articleSection\":[\"Ansible\",\"Cloud\",\"Database management\",\"DevOps\",\"OCI\",\"Oracle\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/oci-automate-your-oracle-cloud-database-software-releases-deployment-db-home\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/oci-automate-your-oracle-cloud-database-software-releases-deployment-db-home\\\/\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/oci-automate-your-oracle-cloud-database-software-releases-deployment-db-home\\\/\",\"name\":\"OCI: Automate your Oracle Cloud Database software releases deployment (db-home) - dbi Blog\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/oci-automate-your-oracle-cloud-database-software-releases-deployment-db-home\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/oci-automate-your-oracle-cloud-database-software-releases-deployment-db-home\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/sites\\\/2\\\/2023\\\/08\\\/Screenshot-2023-08-07-at-18.13.49-1024x578.png\",\"datePublished\":\"2023-08-07T20:38:51+00:00\",\"dateModified\":\"2023-08-14T06:04:29+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/person\\\/a2d3ecddaf732850101a39b9d62c31b7\"},\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/oci-automate-your-oracle-cloud-database-software-releases-deployment-db-home\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/oci-automate-your-oracle-cloud-database-software-releases-deployment-db-home\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/oci-automate-your-oracle-cloud-database-software-releases-deployment-db-home\\\/#primaryimage\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/sites\\\/2\\\/2023\\\/08\\\/Screenshot-2023-08-07-at-18.13.49-1024x578.png\",\"contentUrl\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/sites\\\/2\\\/2023\\\/08\\\/Screenshot-2023-08-07-at-18.13.49-1024x578.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/oci-automate-your-oracle-cloud-database-software-releases-deployment-db-home\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"OCI: Automate your Oracle Cloud Database software releases deployment (db-home)\"}]},{\"@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":"OCI: Automate your Oracle Cloud Database software releases deployment (db-home) - 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\/oci-automate-your-oracle-cloud-database-software-releases-deployment-db-home\/","og_locale":"en_US","og_type":"article","og_title":"OCI: Automate your Oracle Cloud Database software releases deployment (db-home)","og_description":"As part of a very exciting project around Oracle Exadata Cloud @ Customer (aka. ExaCC) technology, we wanted to rollout in an automated manner the database software aka. ORACLE_HOME on ExaCC database clusters (aka. VM cluster). However, we rapidly identified a small lack of command-line parameters to &#8220;mimic&#8221; the console behavior. This post describes briefly [&hellip;]","og_url":"https:\/\/www.dbi-services.com\/blog\/oci-automate-your-oracle-cloud-database-software-releases-deployment-db-home\/","og_site_name":"dbi Blog","article_published_time":"2023-08-07T20:38:51+00:00","article_modified_time":"2023-08-14T06:04:29+00:00","og_image":[{"url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2023\/08\/Screenshot-2023-08-07-at-18.13.49-1024x578.png","type":"","width":"","height":""}],"author":"J\u00e9r\u00f4me Witt","twitter_card":"summary_large_image","twitter_misc":{"Written by":"J\u00e9r\u00f4me Witt","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.dbi-services.com\/blog\/oci-automate-your-oracle-cloud-database-software-releases-deployment-db-home\/#article","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/oci-automate-your-oracle-cloud-database-software-releases-deployment-db-home\/"},"author":{"name":"J\u00e9r\u00f4me Witt","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/a2d3ecddaf732850101a39b9d62c31b7"},"headline":"OCI: Automate your Oracle Cloud Database software releases deployment (db-home)","datePublished":"2023-08-07T20:38:51+00:00","dateModified":"2023-08-14T06:04:29+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/oci-automate-your-oracle-cloud-database-software-releases-deployment-db-home\/"},"wordCount":422,"commentCount":0,"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/oci-automate-your-oracle-cloud-database-software-releases-deployment-db-home\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2023\/08\/Screenshot-2023-08-07-at-18.13.49-1024x578.png","keywords":["Ansible","OCI","Oracle"],"articleSection":["Ansible","Cloud","Database management","DevOps","OCI","Oracle"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.dbi-services.com\/blog\/oci-automate-your-oracle-cloud-database-software-releases-deployment-db-home\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dbi-services.com\/blog\/oci-automate-your-oracle-cloud-database-software-releases-deployment-db-home\/","url":"https:\/\/www.dbi-services.com\/blog\/oci-automate-your-oracle-cloud-database-software-releases-deployment-db-home\/","name":"OCI: Automate your Oracle Cloud Database software releases deployment (db-home) - dbi Blog","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/oci-automate-your-oracle-cloud-database-software-releases-deployment-db-home\/#primaryimage"},"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/oci-automate-your-oracle-cloud-database-software-releases-deployment-db-home\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2023\/08\/Screenshot-2023-08-07-at-18.13.49-1024x578.png","datePublished":"2023-08-07T20:38:51+00:00","dateModified":"2023-08-14T06:04:29+00:00","author":{"@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/a2d3ecddaf732850101a39b9d62c31b7"},"breadcrumb":{"@id":"https:\/\/www.dbi-services.com\/blog\/oci-automate-your-oracle-cloud-database-software-releases-deployment-db-home\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dbi-services.com\/blog\/oci-automate-your-oracle-cloud-database-software-releases-deployment-db-home\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dbi-services.com\/blog\/oci-automate-your-oracle-cloud-database-software-releases-deployment-db-home\/#primaryimage","url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2023\/08\/Screenshot-2023-08-07-at-18.13.49-1024x578.png","contentUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2023\/08\/Screenshot-2023-08-07-at-18.13.49-1024x578.png"},{"@type":"BreadcrumbList","@id":"https:\/\/www.dbi-services.com\/blog\/oci-automate-your-oracle-cloud-database-software-releases-deployment-db-home\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/www.dbi-services.com\/blog\/"},{"@type":"ListItem","position":2,"name":"OCI: Automate your Oracle Cloud Database software releases deployment (db-home)"}]},{"@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\/27154","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=27154"}],"version-history":[{"count":6,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/27154\/revisions"}],"predecessor-version":[{"id":27209,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/27154\/revisions\/27209"}],"wp:attachment":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media?parent=27154"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/categories?post=27154"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/tags?post=27154"},{"taxonomy":"type","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/type_dbi?post=27154"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}