{"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-07T22:38:51","modified_gmt":"2023-08-07T20:38:51","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 class=\"wp-block-paragraph\">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 class=\"wp-block-paragraph\">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 class=\"wp-block-paragraph\">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\/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\/2023\/08\/Screenshot-2023-08-07-at-18.13.49-1024x578.png 1024w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2023\/08\/Screenshot-2023-08-07-at-18.13.49-300x169.png 300w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2023\/08\/Screenshot-2023-08-07-at-18.13.49-768x433.png 768w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2023\/08\/Screenshot-2023-08-07-at-18.13.49-1536x867.png 1536w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/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 class=\"wp-block-paragraph\">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 class=\"wp-block-paragraph\">However, neither the documentation nor the CLI results shows any Release Updates information.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">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 class=\"wp-block-paragraph\">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 class=\"wp-block-paragraph\">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 class=\"wp-block-paragraph\">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 class=\"wp-block-paragraph\">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 class=\"wp-block-paragraph\">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 class=\"wp-block-paragraph\">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;&nbsp;<\/p>\n","protected":false},"author":25,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"neve_meta_sidebar":"","neve_meta_container":"","neve_meta_enable_content_width":"","neve_meta_content_width":0,"neve_meta_title_alignment":"","neve_meta_author_avatar":"","neve_post_elements_order":"","neve_meta_disable_header":"","neve_meta_disable_footer":"","neve_meta_disable_title":"","neve_meta_reading_time":"","_themeisle_gutenberg_block_has_review":false,"footnotes":""},"categories":[1321,955,4133,1320,2966,59],"tags":[],"class_list":["post-27154","post","type-post","status-publish","format-standard","category-ansible","category-cloud","category-database","category-devops","category-oci","category-oracle"],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v28.8 (Yoast SEO v28.8) - https:\/\/yoast.com\/product\/yoast-seo-premium-wordpress\/ -->\n<title>OCI: Automate your Oracle Cloud Database software releases deployment (db-home) - dbi services 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;&nbsp;\" \/>\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 services Blog\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/dbiservices\/\" \/>\n<meta property=\"article:published_time\" content=\"2023-08-07T20:38:51+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2023\/08\/Screenshot-2023-08-07-at-18.13.49.png\" \/>\n\t<meta property=\"og:image:width\" content=\"2198\" \/>\n\t<meta property=\"og:image:height\" content=\"1240\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"J\u00e9r\u00f4me Witt\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@dbiservices\" \/>\n<meta name=\"twitter:site\" content=\"@dbiservices\" \/>\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\\\/ee31feb6f100473958f6f8193c36f427\"},\"headline\":\"OCI: Automate your Oracle Cloud Database software releases deployment (db-home)\",\"datePublished\":\"2023-08-07T20:38:51+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,\"publisher\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/#organization\"},\"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\\\/2023\\\/08\\\/Screenshot-2023-08-07-at-18.13.49-1024x578.png\",\"articleSection\":[\"Ansible\",\"Cloud\",\"Database\",\"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 services 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\\\/2023\\\/08\\\/Screenshot-2023-08-07-at-18.13.49-1024x578.png\",\"datePublished\":\"2023-08-07T20:38:51+00:00\",\"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\\\/2023\\\/08\\\/Screenshot-2023-08-07-at-18.13.49.png\",\"contentUrl\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/2023\\\/08\\\/Screenshot-2023-08-07-at-18.13.49.png\",\"width\":2198,\"height\":1240},{\"@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\":\"Home\",\"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 services Blog\",\"description\":\"#BeSharing\",\"publisher\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/#organization\"},\"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\":\"Organization\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/#organization\",\"name\":\"dbi services\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/2026\\\/09\\\/dbi-services-logo.png\",\"contentUrl\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/2026\\\/09\\\/dbi-services-logo.png\",\"width\":512,\"height\":512,\"caption\":\"dbi services\"},\"image\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/logo\\\/image\\\/\"},\"sameAs\":[\"https:\\\/\\\/www.facebook.com\\\/dbiservices\\\/\",\"https:\\\/\\\/x.com\\\/dbiservices\",\"https:\\\/\\\/www.linkedin.com\\\/company\\\/dbi-services\\\/\",\"https:\\\/\\\/www.youtube.com\\\/user\\\/dbiservices\"],\"description\":\"Swiss IT consulting and services company specialized in efficient data infrastructures and platforms: databases, application servers, cloud, DevOps, digitalization, analytics, data quality and monitoring. Headquartered in Del\u00e9mont with offices in Nyon, Basel, Bern and Zurich.\",\"email\":\"info@dbi-services.com\",\"telephone\":\"+41 32 422 96 00\",\"legalName\":\"dbi services SA\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/person\\\/ee31feb6f100473958f6f8193c36f427\",\"name\":\"J\u00e9r\u00f4me Witt\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/2022\\\/08\\\/JEW_web-min-scaled.jpg\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/2022\\\/08\\\/JEW_web-min-scaled.jpg\",\"contentUrl\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/2022\\\/08\\\/JEW_web-min-scaled.jpg\",\"caption\":\"J\u00e9r\u00f4me Witt\"},\"description\":\"J\u00e9r\u00f4me Witt leads the entire Oracle consulting team in Basel, having started his consulting career in 2008. He specializes in database and infrastructure management, Oracle high availability, backup and recovery, and performance tuning, alongside open-source technologies (Linux\\\/Unix), Perl, Shell, and Windows PowerShell, with a recent focus on automation using Ansible. He holds Oracle 12c\\\/11g Certified Professional, Oracle Certified Expert Tuning (OCE), and ITIL V3 Foundation certifications, and leads the Oracle DBA Essentials, Multitenant, and Ansible workshops. Prior to dbi services, he was a Consultant at Trivadis in Basel. His industry experience covers pharma, healthcare, banking and financial services, energy, and automotive.\",\"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 services 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;&nbsp;","og_url":"https:\/\/www.dbi-services.com\/blog\/oci-automate-your-oracle-cloud-database-software-releases-deployment-db-home\/","og_site_name":"dbi services Blog","article_publisher":"https:\/\/www.facebook.com\/dbiservices\/","article_published_time":"2023-08-07T20:38:51+00:00","og_image":[{"width":2198,"height":1240,"url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2023\/08\/Screenshot-2023-08-07-at-18.13.49.png","type":"image\/png"}],"author":"J\u00e9r\u00f4me Witt","twitter_card":"summary_large_image","twitter_creator":"@dbiservices","twitter_site":"@dbiservices","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\/ee31feb6f100473958f6f8193c36f427"},"headline":"OCI: Automate your Oracle Cloud Database software releases deployment (db-home)","datePublished":"2023-08-07T20:38:51+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,"publisher":{"@id":"https:\/\/www.dbi-services.com\/#organization"},"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\/2023\/08\/Screenshot-2023-08-07-at-18.13.49-1024x578.png","articleSection":["Ansible","Cloud","Database","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 services 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\/2023\/08\/Screenshot-2023-08-07-at-18.13.49-1024x578.png","datePublished":"2023-08-07T20:38:51+00:00","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\/2023\/08\/Screenshot-2023-08-07-at-18.13.49.png","contentUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2023\/08\/Screenshot-2023-08-07-at-18.13.49.png","width":2198,"height":1240},{"@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":"Home","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 services Blog","description":"#BeSharing","publisher":{"@id":"https:\/\/www.dbi-services.com\/#organization"},"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":"Organization","@id":"https:\/\/www.dbi-services.com\/#organization","name":"dbi services","url":"https:\/\/www.dbi-services.com\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2026\/09\/dbi-services-logo.png","contentUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2026\/09\/dbi-services-logo.png","width":512,"height":512,"caption":"dbi services"},"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/dbiservices\/","https:\/\/x.com\/dbiservices","https:\/\/www.linkedin.com\/company\/dbi-services\/","https:\/\/www.youtube.com\/user\/dbiservices"],"description":"Swiss IT consulting and services company specialized in efficient data infrastructures and platforms: databases, application servers, cloud, DevOps, digitalization, analytics, data quality and monitoring. Headquartered in Del\u00e9mont with offices in Nyon, Basel, Bern and Zurich.","email":"info@dbi-services.com","telephone":"+41 32 422 96 00","legalName":"dbi services SA"},{"@type":"Person","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/ee31feb6f100473958f6f8193c36f427","name":"J\u00e9r\u00f4me Witt","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/08\/JEW_web-min-scaled.jpg","url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/08\/JEW_web-min-scaled.jpg","contentUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/08\/JEW_web-min-scaled.jpg","caption":"J\u00e9r\u00f4me Witt"},"description":"J\u00e9r\u00f4me Witt leads the entire Oracle consulting team in Basel, having started his consulting career in 2008. He specializes in database and infrastructure management, Oracle high availability, backup and recovery, and performance tuning, alongside open-source technologies (Linux\/Unix), Perl, Shell, and Windows PowerShell, with a recent focus on automation using Ansible. He holds Oracle 12c\/11g Certified Professional, Oracle Certified Expert Tuning (OCE), and ITIL V3 Foundation certifications, and leads the Oracle DBA Essentials, Multitenant, and Ansible workshops. Prior to dbi services, he was a Consultant at Trivadis in Basel. His industry experience covers pharma, healthcare, banking and financial services, energy, and automotive.","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":0,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/27154\/revisions"}],"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"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}