{"id":5962,"date":"2024-08-06T14:18:00","date_gmt":"2024-08-06T12:18:00","guid":{"rendered":"https:\/\/promatis.com\/at\/running-oracle-soa-suite-on-docker-part-3-starting-a-database\/"},"modified":"2024-08-28T11:01:33","modified_gmt":"2024-08-28T09:01:33","slug":"running-oracle-soa-suite-on-docker-part-3-starting-a-database","status":"publish","type":"post","link":"https:\/\/promatis.com\/at\/running-oracle-soa-suite-on-docker-part-3-starting-a-database\/","title":{"rendered":"Running Oracle SOA Suite on Docker - Part 3: Starting a database"},"content":{"rendered":"

[et_pb_section fb_built=\"1\" custom_padding_last_edited=\"on|tablet\" disabled_on=\"off|off|off\" admin_label=\"Sektion\" _builder_version=\"4.25.1\" _module_preset=\"default\" custom_padding=\"0vh||5vh||false|false\" custom_padding_tablet=\"5vh||5vh||true|false\" custom_padding_phone=\"5vh||5vh||true|false\" locked=\"off\" global_colors_info=\"{}\" global_module=\"4879\" theme_builder_area=\"post_content\"][et_pb_row column_structure=\"1_4,3_4\" _builder_version=\"4.17.6\" _module_preset=\"default\" custom_margin=\"||0px||false|false\" global_colors_info=\"{}\" theme_builder_area=\"post_content\"][et_pb_column type=\"1_4\" _builder_version=\"4.17.6\" _module_preset=\"default\" global_colors_info=\"{}\" theme_builder_area=\"post_content\"][et_pb_image src=\"https:\/\/promatis.com\/wp-content\/uploads\/2022\/07\/johannes-michler.png\" alt=\"Johannes Michler PROMATIS Horus Oracle\" title_text=\"johannes-michler\" _builder_version=\"4.20.2\" _module_preset=\"default\" width=\"90%\" custom_margin=\"0vh||0vh||true|false\" border_radii=\"on|516px|516px|516px|516px\" global_colors_info=\"{}\" theme_builder_area=\"post_content\"][\/et_pb_image][\/et_pb_column][et_pb_column type=\"3_4\" _builder_version=\"4.17.6\" _module_preset=\"default\" global_colors_info=\"{}\" theme_builder_area=\"post_content\"][et_pb_text ul_type=\"square\" _builder_version=\"4.25.1\" _module_preset=\"default\" text_font=\"Open Sans||||||||\" link_font=\"Open Sans||||on|||gcid-0becd5ff-19fc-4653-a221-c8c75771a987|\" link_font_size=\"22px\" ul_font=\"Open Sans||||||||\" ul_font_size=\"17px\" ul_line_height=\"1.6em\" header_2_line_height=\"1.6em\" header_6_font_size=\"16px\" custom_margin=\"2vh||0px||false|false\" custom_padding=\"||||true|false\" hover_enabled=\"0\" text_font_size_tablet=\"20px\" text_font_size_phone=\"17px\" text_font_size_last_edited=\"on|tablet\" header_font_size_tablet=\"\" header_font_size_phone=\"28px\" header_font_size_last_edited=\"on|phone\" global_colors_info=\"{%22gcid-32812186-bc94-4de4-814c-2bf202477fd5%22:%91%22header_text_color%22,%22header_2_text_color%22,%22header_3_text_color%22,%22header_4_text_color%22,%22header_5_text_color%22,%22header_6_text_color%22,%22header_text_color%22,%22header_2_text_color%22,%22header_3_text_color%22,%22header_4_text_color%22,%22header_5_text_color%22,%22header_6_text_color%22,%22header_text_color%22,%22header_2_text_color%22,%22header_3_text_color%22,%22header_4_text_color%22,%22header_5_text_color%22,%22header_6_text_color%22%93,%22gcid-0becd5ff-19fc-4653-a221-c8c75771a987%22:%91%22link_text_color%22%93}\" theme_builder_area=\"post_content\" sticky_enabled=\"0\"]<\/p>\n

Johannes Michler<\/a><\/div>\n

[\/et_pb_text][et_pb_text ul_type=\"square\" _builder_version=\"4.20.0\" _module_preset=\"default\" text_font=\"Open Sans||||||||\" link_font=\"Open Sans||||on||||\" link_text_color=\"#00A9A0\" ul_font=\"Open Sans||||||||\" ul_font_size=\"17px\" ul_line_height=\"1.6em\" header_2_line_height=\"1.6em\" header_6_font_size=\"16px\" custom_margin=\"1vh||0px||false|false\" custom_padding=\"||||true|false\" text_font_size_tablet=\"20px\" text_font_size_phone=\"17px\" text_font_size_last_edited=\"on|tablet\" header_font_size_tablet=\"\" header_font_size_phone=\"28px\" header_font_size_last_edited=\"on|phone\" global_colors_info=\"{%22gcid-32812186-bc94-4de4-814c-2bf202477fd5%22:%91%22header_text_color%22,%22header_2_text_color%22,%22header_3_text_color%22,%22header_4_text_color%22,%22header_5_text_color%22,%22header_6_text_color%22%93}\" theme_builder_area=\"post_content\"]<\/p>\n


Executive Vice President<\/strong> \u2013\u00a0Head of Platforms\u00a0&\u00a0Development<\/p>\n

[\/et_pb_text][et_pb_text ul_type=\"square\" _builder_version=\"4.20.0\" _module_preset=\"default\" text_font=\"Open Sans||||||||\" text_text_color=\"gcid-0becd5ff-19fc-4653-a221-c8c75771a987\" text_font_size=\"22px\" link_font=\"Open Sans||||on||||\" link_text_color=\"#00A9A0\" ul_font=\"Open Sans||||||||\" ul_font_size=\"17px\" ul_line_height=\"1.6em\" header_2_line_height=\"1.6em\" header_6_font_size=\"16px\" custom_margin=\"5px||0px||false|false\" custom_padding=\"||||true|false\" text_font_size_tablet=\"20px\" text_font_size_phone=\"17px\" text_font_size_last_edited=\"on|tablet\" header_font_size_tablet=\"\" header_font_size_phone=\"28px\" header_font_size_last_edited=\"on|phone\" global_colors_info=\"{%22gcid-32812186-bc94-4de4-814c-2bf202477fd5%22:%91%22header_text_color%22,%22header_2_text_color%22,%22header_3_text_color%22,%22header_4_text_color%22,%22header_5_text_color%22,%22header_6_text_color%22,%22header_text_color%22,%22header_2_text_color%22,%22header_3_text_color%22,%22header_4_text_color%22,%22header_5_text_color%22,%22header_6_text_color%22,%22header_text_color%22,%22header_2_text_color%22,%22header_3_text_color%22,%22header_4_text_color%22,%22header_5_text_color%22,%22header_6_text_color%22%93,%22gcid-0becd5ff-19fc-4653-a221-c8c75771a987%22:%91%22text_text_color%22%93}\" theme_builder_area=\"post_content\"]<\/i><\/a><\/i><\/a><\/i><\/a>[\/et_pb_text][\/et_pb_column][\/et_pb_row][\/et_pb_section][et_pb_section fb_built=\"1\" _builder_version=\"4.16\" _module_preset=\"default\" custom_padding=\"0vh||10vh||false|false\" global_colors_info=\"{}\" theme_builder_area=\"post_content\"][et_pb_row use_custom_gutter=\"on\" _builder_version=\"4.17.3\" _module_preset=\"default\" custom_padding=\"0px||0px||true|false\" global_colors_info=\"{}\" theme_builder_area=\"post_content\"][et_pb_column type=\"4_4\" _builder_version=\"4.16\" _module_preset=\"default\" global_colors_info=\"{}\" theme_builder_area=\"post_content\"][et_pb_text _builder_version=\"4.25.1\" _module_preset=\"default\" background_enable_color=\"off\" custom_padding=\"0px||0px||true|false\" inline_fonts=\"Times New Roman\" global_colors_info=\"{%22gcid-32812186-bc94-4de4-814c-2bf202477fd5%22:%91%22header_text_color%22,%22header_2_text_color%22,%22header_3_text_color%22%93,%22gcid-0becd5ff-19fc-4653-a221-c8c75771a987%22:%91%22background_color%22%93}\" theme_builder_area=\"post_content\"]<\/p>\n

\"\"<\/p>\n

Operating - installing and maintaining - Oracle Fusion Middleware, especially Oracle SOA Suite 12.2.1.4 is quite some work. Not only does installation itself consist of a number of steps, but each quarterly critical patch update also requires applying a number of patches and - especially in simple, single server environments quite some downtime.<\/p>\n

This blog post series will cover how to run Oracle Fusion Middleware - especially Oracle SOA Suite on docker. The first post<\/a> covered the high-level steps of manual installation, Docker and Kubernetes options and has pointers to the relevant Oracle certification documentation. The second post<\/a> then described how - using OCI and Oracle Linux - a host to run docker containers can be setup up within minutes.<\/p>\n

In this third post we will cover provisioning an Oracle Database instance to hold the meta data of Oracle SOA Suite.
In the 4th episode I'll investigate provisioning and configuring SOA Suite itself. While I'll first show those steps in a minimalistic way, to wrap up, the final episodes will cover patching and more advanced deployment options.<\/p>\n

Signing into Oracle Container Registry<\/h2>\n

To use the pre-built containers provided by Oracle (and patched each quarter) navigate to https:\/\/container-registry.oracle.com\/<\/a> and sign-in with your Oracle SSO credentials. Navigate to Auth Token there:<\/p>\n

\"\"
Creation of an Auth Token (Step 1)<\/em><\/p>\n

Then click \"Generate Secret Key\" and safely store the generated key: It is not possible to reveal it again (but you can delete and create a new one).<\/p>\n

Then go to your docker host and issue:<\/p>\n

docker login container-registry.oracle.com<\/pre>\n
Provide your Oracle SSO Username as well as the token created:<\/p>\n
\"\"
Successful login to Oracle Container Registry<\/em><\/p>\n
Downloading a database image<\/h2>\n
For testing purposes, it might be enough to use the latest \"Free\" Edition of the database; this is not supported though. Let's give it a try for this mini-instance nevertheless; you can switch to a \"proper\" Database Edition by just replacing \"free\" with \"enterprise\":<\/p>\n
docker pull container-registry.oracle.com\/database\/free:latest<\/pre>\n
On OCI that command runs roughly 5 minutes. This is mainly for downloading 2 GB and extracting it to a 9 GB all-prepared image.<\/p>\n
Starting the database<\/h2>\n
After having downloaded the latest image you can start with the following simple commands:<\/p>\n
docker volume create mydbvol\ndocker network create soanet1\ndocker run --name myxe1 --network soanet1 -e ORACLE_PWD=Promatis1 -p 1521:1521 -v mydbvol:\/opt\/oracle\/oradata --rm container-registry.oracle.com\/database\/free:latest<\/pre>\n
This first of all creates a persistent volume that will store the datafiles and will survive reboots of the environment. Furthermore, it creates a network that we will use late on to allow connecting to the database both from the host and from the SOA container. To make this as easy as possible we also expose port 1521 to the host. The entire process just takes 2 minutes:<\/p>\n
\"\"
Initial startup of the new database<\/em><\/p>\n
Now you can connect to the DB e.g. using sql developer with the password provided as user SYSTEM; the service name is freepdb1.<\/p>\n
\"\"
Connection to newly started Oracle Database 23ai free<\/em><\/p>\n
Summary<\/h2>\n
As shown starting an Oracle Database (e.g. 23 ai free) is a thing of 3 commands and completes in 5 to 10 minutes (network bandwidth permitting). In the next section of the blog, we'll see how we can run an Oracle SOA Suite using that Database.<\/p>\n
[\/et_pb_text][\/et_pb_column][\/et_pb_row][\/et_pb_section]<\/p>\n","protected":false},"excerpt":{"rendered":"
This series covers how to run Oracle Fusion Middleware on Docker. This third shows you how to provision an Oracle Database instance to hold the meta data of Oracle SOA Suite.<\/p>\n","protected":false},"author":2,"featured_media":1234,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_et_pb_use_builder":"on","_et_pb_old_content":"","_et_gb_content_width":"","footnotes":""},"categories":[23],"tags":[493,102,175],"dipi_cpt_category":[],"class_list":["post-5962","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-techblog","tag-docker","tag-oracle","tag-soa-suite"],"_links":{"self":[{"href":"https:\/\/promatis.com\/at\/wp-json\/wp\/v2\/posts\/5962"}],"collection":[{"href":"https:\/\/promatis.com\/at\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/promatis.com\/at\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/promatis.com\/at\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/promatis.com\/at\/wp-json\/wp\/v2\/comments?post=5962"}],"version-history":[{"count":0,"href":"https:\/\/promatis.com\/at\/wp-json\/wp\/v2\/posts\/5962\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/promatis.com\/at\/wp-json\/wp\/v2\/media\/1234"}],"wp:attachment":[{"href":"https:\/\/promatis.com\/at\/wp-json\/wp\/v2\/media?parent=5962"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/promatis.com\/at\/wp-json\/wp\/v2\/categories?post=5962"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/promatis.com\/at\/wp-json\/wp\/v2\/tags?post=5962"},{"taxonomy":"dipi_cpt_category","embeddable":true,"href":"https:\/\/promatis.com\/at\/wp-json\/wp\/v2\/dipi_cpt_category?post=5962"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}