{"id":69,"date":"2010-10-31T12:38:19","date_gmt":"2010-10-31T11:38:19","guid":{"rendered":"http:\/\/www.oradba.ch"},"modified":"2023-06-14T08:53:34","modified_gmt":"2023-06-14T06:53:34","slug":"home","status":"publish","type":"page","link":"https:\/\/www.oradba.ch\/wordpress\/","title":{"rendered":"Welcome to my site"},"content":{"rendered":"\n<p>My name is Stefan Oehrli. I&#8217;m a Swiss electrical engineer working since several years as an Oracle DBA and consultant. My main interests are <a href=\"https:\/\/www.oradba.ch\/wordpress\/category\/oracle-database\/backup-recovery\/\">backup &amp; recovery<\/a>, database internals, database <a href=\"https:\/\/www.oradba.ch\/wordpress\/category\/security\/\">security<\/a>, infrastructure management and other stuff coming across my daily work as a DBA and Tech Architecture Manager at Trivadis part of Accenture. For a while now, <a href=\"https:\/\/www.oradba.ch\/wordpress\/category\/oud\/\">Oracle Unified Directory<\/a> has been one of them. On this website I share my experience and some of my thoughts in these areas with you. Among other things, you find my <a href=\"\/blog\">blog<\/a>, a few <a href=\"\/scripts\">scripts<\/a>, links to some <a href=\"\/papers\">papers and presentations<\/a> I have written or co-authored,\u00a0list of <a href=\"https:\/\/www.oradba.ch\/wordpress\/public-appearances\/\">public appearances<\/a>\u00a0as well links to other interesting web resources.<\/p>\n\n\n\n<p>Enjoy&#8230;<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Recent Posts<\/h2>\n\n\n\n<p>A list of the 5 most recent posts. To see a full list go to the <a href=\"https:\/\/www.oradba.ch\/wordpress\/blog\">Blogs<\/a>.<\/p>\n\n\n\n<div class=\"wp-block-columns is-layout-flex wp-container-core-columns-is-layout-9d6595d7 wp-block-columns-is-layout-flex\">\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\" style=\"flex-basis:100%\">\n<div class=\"wp-block-group\"><div class=\"wp-block-group__inner-container is-layout-flow wp-block-group-is-layout-flow\"><ul class=\"wp-block-latest-posts__list has-dates alignleft wp-block-latest-posts\"><li><a class=\"wp-block-latest-posts__post-title\" href=\"https:\/\/www.oradba.ch\/wordpress\/2024\/11\/its-a-wrap-doag-conference\/\">It\u2019s a Wrap: DOAG Conference<\/a><time datetime=\"2024-11-22T21:05:46+01:00\" class=\"wp-block-latest-posts__post-date\">22. November 2024<\/time><div class=\"wp-block-latest-posts__post-excerpt\">A Challenging Start with a Silver Lining The DOAG Conference 2024 began with an eventful journey for me, Dani Schnider, and Martin Berger. A major train disruption in Memmingen forced us to switch to a rental car, turning our trip into an unplanned road trip. Despite the hiccups, we made good use of the time\u2026 <a class=\"wp-block-latest-posts__read-more\" href=\"https:\/\/www.oradba.ch\/wordpress\/2024\/11\/its-a-wrap-doag-conference\/\" rel=\"noopener noreferrer\">Read more<span class=\"screen-reader-text\">: It\u2019s a Wrap: DOAG Conference<\/span><\/a><\/div><\/li>\n<li><a class=\"wp-block-latest-posts__post-title\" href=\"https:\/\/www.oradba.ch\/wordpress\/2024\/09\/its-a-wrap-soug-day-in-zurich-and-romandie\/\">It\u2019s a Wrap: SOUG Day in Zurich and Romandie<\/a><time datetime=\"2024-09-24T17:34:50+02:00\" class=\"wp-block-latest-posts__post-date\">24. September 2024<\/time><div class=\"wp-block-latest-posts__post-excerpt\">The past few days have been an exciting time for Oracle database enthusiasts across Switzerland. The Swiss Oracle User Group (SOUG) organized two fantastic events: the larger SOUG Day in Zurich on September 20th, 2024, and a more intimate gathering in French-speaking Switzerland on September 24th, 2024. Both events attracted Oracle professionals from across the\u2026 <a class=\"wp-block-latest-posts__read-more\" href=\"https:\/\/www.oradba.ch\/wordpress\/2024\/09\/its-a-wrap-soug-day-in-zurich-and-romandie\/\" rel=\"noopener noreferrer\">Read more<span class=\"screen-reader-text\">: It\u2019s a Wrap: SOUG Day in Zurich and Romandie<\/span><\/a><\/div><\/li>\n<li><a class=\"wp-block-latest-posts__post-title\" href=\"https:\/\/www.oradba.ch\/wordpress\/2024\/09\/building-oracle-23ai-free-on-arm64\/\">Building Oracle 23ai Free on ARM64<\/a><time datetime=\"2024-09-18T00:39:07+02:00\" class=\"wp-block-latest-posts__post-date\">18. September 2024<\/time><div class=\"wp-block-latest-posts__post-excerpt\">Earlier this week, Oracle quietly released the RPM packages for Oracle 23ai Free Edition for ARM64 systems. This release is very interesting for developers using Macs with ARM processors as it allows them to create Oracle 23ai containers for their development and engineering environments. In this blog post, I&#8217;ll walk you through the steps of\u2026 <a class=\"wp-block-latest-posts__read-more\" href=\"https:\/\/www.oradba.ch\/wordpress\/2024\/09\/building-oracle-23ai-free-on-arm64\/\" rel=\"noopener noreferrer\">Read more<span class=\"screen-reader-text\">: Building Oracle 23ai Free on ARM64<\/span><\/a><\/div><\/li>\n<li><a class=\"wp-block-latest-posts__post-title\" href=\"https:\/\/www.oradba.ch\/wordpress\/2024\/01\/its-a-wrap-insights-from-the-soug-espresso-on-oracle-audit\/\">It\u2019s a Wrap: Insights from the SOUG Espresso on Oracle Audit<\/a><time datetime=\"2024-01-26T09:20:31+01:00\" class=\"wp-block-latest-posts__post-date\">26. January 2024<\/time><div class=\"wp-block-latest-posts__post-excerpt\">In my latest SOUG Espresso session, Easy Audit Data Analysis with SQL Developer Reports, I focused on Oracle Unified Audit Analysis. This was an opportunity to share my experience and insights into database security and audit data workflow enhancement. Event Highlights Based on my considerable experience with Oracle databases, I emphasized the critical importance of\u2026 <a class=\"wp-block-latest-posts__read-more\" href=\"https:\/\/www.oradba.ch\/wordpress\/2024\/01\/its-a-wrap-insights-from-the-soug-espresso-on-oracle-audit\/\" rel=\"noopener noreferrer\">Read more<span class=\"screen-reader-text\">: It\u2019s a Wrap: Insights from the SOUG Espresso on Oracle Audit<\/span><\/a><\/div><\/li>\n<li><a class=\"wp-block-latest-posts__post-title\" href=\"https:\/\/www.oradba.ch\/wordpress\/2024\/01\/latest-critical-patch-updates-from-oracle-january-2024\/\">Latest Critical Patch Updates from Oracle &#8211; January 2024<\/a><time datetime=\"2024-01-18T08:27:44+01:00\" class=\"wp-block-latest-posts__post-date\">18. January 2024<\/time><div class=\"wp-block-latest-posts__post-excerpt\">On January 18, Oracle unveiled its first quarterly Critical Patch Update Advisory of the year. This advisory, a pivotal resource for Oracle users, details an array of 389 new security patches across various Oracle product families. This update includes several high-severity vulnerabilities, notably those that can be exploited remotely over the network, with some having\u2026 <a class=\"wp-block-latest-posts__read-more\" href=\"https:\/\/www.oradba.ch\/wordpress\/2024\/01\/latest-critical-patch-updates-from-oracle-january-2024\/\" rel=\"noopener noreferrer\">Read more<span class=\"screen-reader-text\">: Latest Critical Patch Updates from Oracle &#8211; January 2024<\/span><\/a><\/div><\/li>\n<\/ul>\n\n\n<p><\/p>\n<\/div><\/div>\n<\/div>\n<\/div>\n\n\n\n<p>Want to see more blog posts? Just go to <a href=\"https:\/\/www.oradba.ch\/wordpress\/blog\">blogs<\/a> or browse the <a href=\"https:\/\/www.oradba.ch\/wordpress\/blog\/archives\/\">archives<\/a>.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>My name is Stefan Oehrli. I&#8217;m a Swiss electrical engineer working since several years as an Oracle DBA and consultant. My main interests are backup &amp; recovery, database internals, database security, infrastructure management and other stuff coming across my daily work as a DBA and Tech Architecture Manager at Trivadis part of Accenture. For a [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"page-templates\/front-page.php","meta":{"_exactmetrics_skip_tracking":false,"_exactmetrics_sitenote_active":false,"_exactmetrics_sitenote_note":"","_exactmetrics_sitenote_category":0,"jetpack_post_was_ever_published":false,"footnotes":""},"class_list":["post-69","page","type-page","status-publish","hentry"],"jetpack_shortlink":"https:\/\/wp.me\/P1aErb-17","jetpack_sharing_enabled":true,"jetpack-related-posts":[{"id":71,"url":"https:\/\/www.oradba.ch\/wordpress\/about\/","url_meta":{"origin":69,"position":0},"title":"About","author":"Stefan","date":"31. October 2010","format":false,"excerpt":"Stefan Oehrli is a Tech Architecture Manager and trainer at Accenture. After studying electrical engineering and several years of experience as project engineer in the microelectronic and computer science, he began to work with database systems in the late 1998. Since this time he could gain substantial experience in physical\u2026","rel":"","context":"Similar post","block_context":{"text":"Similar post","link":""},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/www.oradba.ch\/wordpress\/wp-content\/uploads\/ST1_ACEDirector_rgb.png?resize=350%2C200&ssl=1","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/www.oradba.ch\/wordpress\/wp-content\/uploads\/ST1_ACEDirector_rgb.png?resize=350%2C200&ssl=1 1x, https:\/\/i0.wp.com\/www.oradba.ch\/wordpress\/wp-content\/uploads\/ST1_ACEDirector_rgb.png?resize=525%2C300&ssl=1 1.5x, https:\/\/i0.wp.com\/www.oradba.ch\/wordpress\/wp-content\/uploads\/ST1_ACEDirector_rgb.png?resize=700%2C400&ssl=1 2x, https:\/\/i0.wp.com\/www.oradba.ch\/wordpress\/wp-content\/uploads\/ST1_ACEDirector_rgb.png?resize=1050%2C600&ssl=1 3x"},"classes":[]},{"id":945,"url":"https:\/\/www.oradba.ch\/wordpress\/links\/","url_meta":{"origin":69,"position":1},"title":"Links","author":"Stefan","date":"3. January 2013","format":false,"excerpt":"A few links to topics that are frequently discussed here. My own stuff My own GitHub repositories oehrlisTrivadis GitHub organisation Trivadis GitHub Gists oehrlisMy stuff on Docker hub oehrlisTrivadis team repositories on Docker hubTrivadis modules in the Terraform Registry Documentation Oracle Unified Directory 12.2.1.4.0 booksOracle Database 21c booksOracle Database 19c\u2026","rel":"","context":"Similar post","block_context":{"text":"Similar post","link":""},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":13124,"url":"https:\/\/www.oradba.ch\/wordpress\/talks\/","url_meta":{"origin":69,"position":2},"title":"Talks","author":"Stefan","date":"5. April 2023","format":false,"excerpt":"Here you will find planned public appearances as well as handouts of my talks and presentations from conferences, user group meetings, and other public events. Scheduled 2024-05-10 Maximizing Oracle Database Security: Key Strategies and Insights DOAG Webinar 2024-08 Oracle Cloud Infrastructure - from Console to Automation - Kickstart! DOAG Expert\u2026","rel":"","context":"Similar post","block_context":{"text":"Similar post","link":""},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":127,"url":"https:\/\/www.oradba.ch\/wordpress\/publications\/tools\/","url_meta":{"origin":69,"position":3},"title":"Tools","author":"Stefan","date":"31. October 2010","format":false,"excerpt":"Here you find links to some Tools I regularly use. The tools are written by others, therefore I can not accept any responsibility for them.\u00a0Please review the tools before running them especially on\u00a0production system. Date Title Language","rel":"","context":"Similar post","block_context":{"text":"Similar post","link":""},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":14162,"url":"https:\/\/www.oradba.ch\/wordpress\/howtos\/","url_meta":{"origin":69,"position":4},"title":"Howto&#8217;s","author":"Stefan","date":"13. October 2023","format":false,"excerpt":"As my grandmother used to say, \" kid, you need to write this down\". With that in mind, I've started creating a series of special how-to blogposts. These contain clear step-by-step instructions on a particular topic without much fuss. The commands or scripts provided should be executable in any environment\u2026","rel":"","context":"Similar post","block_context":{"text":"Similar post","link":""},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":123,"url":"https:\/\/www.oradba.ch\/wordpress\/publications\/scripts\/","url_meta":{"origin":69,"position":5},"title":"Scripts","author":"Stefan","date":"31. October 2010","format":false,"excerpt":"Here you find some Scripts I wrote or co-authored. The scripts are available free to anyone to use. I do not accept any responsibility\u00a0for any damage, errors or anything whatsoever caused by running or using these scripts. The scripts have been tested thoroughly but as there are many platforms, oracle\u2026","rel":"","context":"Similar post","block_context":{"text":"Similar post","link":""},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]}],"_links":{"self":[{"href":"https:\/\/www.oradba.ch\/wordpress\/wp-json\/wp\/v2\/pages\/69","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.oradba.ch\/wordpress\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/www.oradba.ch\/wordpress\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/www.oradba.ch\/wordpress\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.oradba.ch\/wordpress\/wp-json\/wp\/v2\/comments?post=69"}],"version-history":[{"count":35,"href":"https:\/\/www.oradba.ch\/wordpress\/wp-json\/wp\/v2\/pages\/69\/revisions"}],"predecessor-version":[{"id":14139,"href":"https:\/\/www.oradba.ch\/wordpress\/wp-json\/wp\/v2\/pages\/69\/revisions\/14139"}],"wp:attachment":[{"href":"https:\/\/www.oradba.ch\/wordpress\/wp-json\/wp\/v2\/media?parent=69"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}