{"id":13431,"date":"2023-06-13T12:03:55","date_gmt":"2023-06-13T10:03:55","guid":{"rendered":"https:\/\/www.oradba.ch\/wordpress\/?page_id=13431"},"modified":"2023-06-14T09:00:03","modified_gmt":"2023-06-14T07:00:03","slug":"list-of-posts","status":"publish","type":"page","link":"https:\/\/www.oradba.ch\/wordpress\/list-of-posts\/","title":{"rendered":"List of Posts"},"content":{"rendered":"\n<div class=\"wp-block-query is-layout-flow wp-block-query-is-layout-flow\"><ul class=\"wp-block-post-template is-layout-flow wp-block-post-template-is-layout-flow\"><li class=\"wp-block-post post-16381 post type-post status-publish format-standard hentry category-uncategorized\">\n<h2 class=\"wp-block-post-title\"><a href=\"https:\/\/www.oradba.ch\/wordpress\/2024\/11\/its-a-wrap-doag-conference\/\" target=\"_blank\" >It\u2019s a Wrap: DOAG Conference<\/a><\/h2>\n\n\n\n<div class=\"wp-block-post-excerpt\"><p class=\"wp-block-post-excerpt__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<\/p><p class=\"wp-block-post-excerpt__more-text\"><a class=\"wp-block-post-excerpt__more-link\" href=\"https:\/\/www.oradba.ch\/wordpress\/2024\/11\/its-a-wrap-doag-conference\/\">Read more&#8230;<\/a><\/p><\/div>\n\n\n<hr class=\"wp-block-separator has-css-opacity\"\/>\n\n\n<div class=\"wp-block-post-date\"><time datetime=\"2024-11-22T21:05:46+01:00\">22. November 2024<\/time><\/div>\n<\/li><li class=\"wp-block-post post-16071 post type-post status-publish format-standard hentry category-uncategorized\">\n<h2 class=\"wp-block-post-title\"><a href=\"https:\/\/www.oradba.ch\/wordpress\/2024\/09\/its-a-wrap-soug-day-in-zurich-and-romandie\/\" target=\"_blank\" >It\u2019s a Wrap: SOUG Day in Zurich and Romandie<\/a><\/h2>\n\n\n\n<div class=\"wp-block-post-excerpt\"><p class=\"wp-block-post-excerpt__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<\/p><p class=\"wp-block-post-excerpt__more-text\"><a class=\"wp-block-post-excerpt__more-link\" href=\"https:\/\/www.oradba.ch\/wordpress\/2024\/09\/its-a-wrap-soug-day-in-zurich-and-romandie\/\">Read more&#8230;<\/a><\/p><\/div>\n\n\n<hr class=\"wp-block-separator has-css-opacity\"\/>\n\n\n<div class=\"wp-block-post-date\"><time datetime=\"2024-09-24T17:34:50+02:00\">24. September 2024<\/time><\/div>\n<\/li><li class=\"wp-block-post post-16030 post type-post status-publish format-standard hentry category-23ai category-docker category-howto category-mac-os-x category-uncategorized\">\n<h2 class=\"wp-block-post-title\"><a href=\"https:\/\/www.oradba.ch\/wordpress\/2024\/09\/building-oracle-23ai-free-on-arm64\/\" target=\"_blank\" >Building Oracle 23ai Free on ARM64<\/a><\/h2>\n\n\n\n<div class=\"wp-block-post-excerpt\"><p class=\"wp-block-post-excerpt__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<\/p><p class=\"wp-block-post-excerpt__more-text\"><a class=\"wp-block-post-excerpt__more-link\" href=\"https:\/\/www.oradba.ch\/wordpress\/2024\/09\/building-oracle-23ai-free-on-arm64\/\">Read more&#8230;<\/a><\/p><\/div>\n\n\n<hr class=\"wp-block-separator has-css-opacity\"\/>\n\n\n<div class=\"wp-block-post-date\"><time datetime=\"2024-09-18T00:39:07+02:00\">18. September 2024<\/time><\/div>\n<\/li><li class=\"wp-block-post post-14847 post type-post status-publish format-standard hentry category-19c category-23c category-audit category-good-practice category-oracle-database category-oradba category-security category-soug-events category-sql-developer category-uncategorized category-unified-audit\">\n<h2 class=\"wp-block-post-title\"><a href=\"https:\/\/www.oradba.ch\/wordpress\/2024\/01\/its-a-wrap-insights-from-the-soug-espresso-on-oracle-audit\/\" target=\"_blank\" >It\u2019s a Wrap: Insights from the SOUG Espresso on Oracle Audit<\/a><\/h2>\n\n\n\n<div class=\"wp-block-post-excerpt\"><p class=\"wp-block-post-excerpt__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<\/p><p class=\"wp-block-post-excerpt__more-text\"><a class=\"wp-block-post-excerpt__more-link\" href=\"https:\/\/www.oradba.ch\/wordpress\/2024\/01\/its-a-wrap-insights-from-the-soug-espresso-on-oracle-audit\/\">Read more&#8230;<\/a><\/p><\/div>\n\n\n<hr class=\"wp-block-separator has-css-opacity\"\/>\n\n\n<div class=\"wp-block-post-date\"><time datetime=\"2024-01-26T09:20:31+01:00\">26. January 2024<\/time><\/div>\n<\/li><li class=\"wp-block-post post-14785 post type-post status-publish format-standard hentry category-19c category-23c category-bp category-cpu category-oracle-database category-oracle-metalink category-patches category-ru category-security category-uncategorized\">\n<h2 class=\"wp-block-post-title\"><a href=\"https:\/\/www.oradba.ch\/wordpress\/2024\/01\/latest-critical-patch-updates-from-oracle-january-2024\/\" target=\"_blank\" >Latest Critical Patch Updates from Oracle &#8211; January 2024<\/a><\/h2>\n\n\n\n<div class=\"wp-block-post-excerpt\"><p class=\"wp-block-post-excerpt__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<\/p><p class=\"wp-block-post-excerpt__more-text\"><a class=\"wp-block-post-excerpt__more-link\" href=\"https:\/\/www.oradba.ch\/wordpress\/2024\/01\/latest-critical-patch-updates-from-oracle-january-2024\/\">Read more&#8230;<\/a><\/p><\/div>\n\n\n<hr class=\"wp-block-separator has-css-opacity\"\/>\n\n\n<div class=\"wp-block-post-date\"><time datetime=\"2024-01-18T08:27:44+01:00\">18. January 2024<\/time><\/div>\n<\/li><li class=\"wp-block-post post-14769 post type-post status-publish format-standard hentry category-23c category-best-practice category-good-practice category-security category-security-audit category-uncategorized\">\n<h2 class=\"wp-block-post-title\"><a href=\"https:\/\/www.oradba.ch\/wordpress\/2024\/01\/dive-into-the-latest-enhancements-of-dbsat-3-1-0\/\" target=\"_blank\" >Dive into the Latest Enhancements of DBSat 3.1.0<\/a><\/h2>\n\n\n\n<div class=\"wp-block-post-excerpt\"><p class=\"wp-block-post-excerpt__excerpt\">Today, my initial plan was simply to finalize my article on DBSat 3.0.0 for the Oraworld Magazine. However, while checking the links to the DBSat documentation, Oracle Support Notes, and download sources, I discovered that Oracle has, almost simultaneously, released the latest version 3.1.0 of the Oracle Database Security Assessment Tool (DBSAT). Once again, this<\/p><p class=\"wp-block-post-excerpt__more-text\"><a class=\"wp-block-post-excerpt__more-link\" href=\"https:\/\/www.oradba.ch\/wordpress\/2024\/01\/dive-into-the-latest-enhancements-of-dbsat-3-1-0\/\">Read more&#8230;<\/a><\/p><\/div>\n\n\n<hr class=\"wp-block-separator has-css-opacity\"\/>\n\n\n<div class=\"wp-block-post-date\"><time datetime=\"2024-01-16T06:41:14+01:00\">16. January 2024<\/time><\/div>\n<\/li><li class=\"wp-block-post post-13876 post type-post status-publish format-standard has-post-thumbnail hentry category-19c category-23c category-audit category-good-practice category-security category-security-audit category-unified-audit tag-sql-developer\">\n<h2 class=\"wp-block-post-title\"><a href=\"https:\/\/www.oradba.ch\/wordpress\/2023\/12\/easy-audit-data-analysis-with-sql-developer-reports\/\" target=\"_blank\" >Easy Audit Data Analysis with SQL Developer Reports<\/a><\/h2>\n\n<figure class=\"alignwide wp-block-post-featured-image\"><a href=\"https:\/\/www.oradba.ch\/wordpress\/2023\/12\/easy-audit-data-analysis-with-sql-developer-reports\/\" target=\"_self\"  ><img loading=\"lazy\" decoding=\"async\" width=\"624\" height=\"476\" src=\"https:\/\/i0.wp.com\/www.oradba.ch\/wordpress\/wp-content\/uploads\/ChartAuditEventsDay-1.png?fit=624%2C476&amp;ssl=1\" class=\"attachment-post-thumbnail size-post-thumbnail wp-post-image\" alt=\"Easy Audit Data Analysis with SQL Developer Reports\" style=\"object-fit:cover;\" srcset=\"https:\/\/i0.wp.com\/www.oradba.ch\/wordpress\/wp-content\/uploads\/ChartAuditEventsDay-1.png?w=2427&amp;ssl=1 2427w, https:\/\/i0.wp.com\/www.oradba.ch\/wordpress\/wp-content\/uploads\/ChartAuditEventsDay-1.png?resize=300%2C229&amp;ssl=1 300w, https:\/\/i0.wp.com\/www.oradba.ch\/wordpress\/wp-content\/uploads\/ChartAuditEventsDay-1.png?resize=1024%2C782&amp;ssl=1 1024w, https:\/\/i0.wp.com\/www.oradba.ch\/wordpress\/wp-content\/uploads\/ChartAuditEventsDay-1.png?resize=768%2C586&amp;ssl=1 768w, https:\/\/i0.wp.com\/www.oradba.ch\/wordpress\/wp-content\/uploads\/ChartAuditEventsDay-1.png?resize=1536%2C1173&amp;ssl=1 1536w, https:\/\/i0.wp.com\/www.oradba.ch\/wordpress\/wp-content\/uploads\/ChartAuditEventsDay-1.png?resize=2048%2C1564&amp;ssl=1 2048w, https:\/\/i0.wp.com\/www.oradba.ch\/wordpress\/wp-content\/uploads\/ChartAuditEventsDay-1.png?resize=624%2C476&amp;ssl=1 624w, https:\/\/i0.wp.com\/www.oradba.ch\/wordpress\/wp-content\/uploads\/ChartAuditEventsDay-1.png?w=1250&amp;ssl=1 1250w, https:\/\/i0.wp.com\/www.oradba.ch\/wordpress\/wp-content\/uploads\/ChartAuditEventsDay-1.png?w=1875&amp;ssl=1 1875w\" sizes=\"auto, (max-width: 624px) 100vw, 624px\" \/><\/a><\/figure>\n\n<div class=\"wp-block-post-excerpt\"><p class=\"wp-block-post-excerpt__excerpt\">In one of my last blog post SQL Toolbox for simplified Oracle Unified Audit Data Analysis, I introduced a set of scripts designed to streamline Oracle Unified Audit data analysis. These scripts, now available on my GitHub repository oehrlis\/oradba, have received positive feedback. Building on that, I&#8217;d like to explore an alternative approach to augment<\/p><p class=\"wp-block-post-excerpt__more-text\"><a class=\"wp-block-post-excerpt__more-link\" href=\"https:\/\/www.oradba.ch\/wordpress\/2023\/12\/easy-audit-data-analysis-with-sql-developer-reports\/\">Read more&#8230;<\/a><\/p><\/div>\n\n\n<hr class=\"wp-block-separator has-css-opacity\"\/>\n\n\n<div class=\"wp-block-post-date\"><time datetime=\"2023-12-21T15:29:16+01:00\">21. December 2023<\/time><\/div>\n<\/li><li class=\"wp-block-post post-14472 post type-post status-publish format-standard hentry category-uncategorized\">\n<h2 class=\"wp-block-post-title\"><a href=\"https:\/\/www.oradba.ch\/wordpress\/2023\/11\/doag-2023-debrief-a-speakers-perspective\/\" target=\"_blank\" >DOAG 2023 Debrief: A Speaker&#8217;s Perspective<\/a><\/h2>\n\n\n\n<div class=\"wp-block-post-excerpt\"><p class=\"wp-block-post-excerpt__excerpt\">It\u2019s a wrap. The DOAG database conference has come to an end. As I sit on the train, I reflect on a week full of excitement and variety. In addition to the many fascinating technical presentations, I had the opportunity to catch up with old friends and colleagues. The conference started on Monday afternoon when<\/p><p class=\"wp-block-post-excerpt__more-text\"><a class=\"wp-block-post-excerpt__more-link\" href=\"https:\/\/www.oradba.ch\/wordpress\/2023\/11\/doag-2023-debrief-a-speakers-perspective\/\">Read more&#8230;<\/a><\/p><\/div>\n\n\n<hr class=\"wp-block-separator has-css-opacity\"\/>\n\n\n<div class=\"wp-block-post-date\"><time datetime=\"2023-11-24T22:06:54+01:00\">24. November 2023<\/time><\/div>\n<\/li><\/ul><\/div>\n","protected":false},"excerpt":{"rendered":"","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","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-13431","page","type-page","status-publish","hentry"],"jetpack_shortlink":"https:\/\/wp.me\/P1aErb-3uD","jetpack_sharing_enabled":true,"jetpack-related-posts":[{"id":69,"url":"https:\/\/www.oradba.ch\/wordpress\/","url_meta":{"origin":13431,"position":0},"title":"Welcome to my site","author":"Stefan","date":"31. October 2010","format":false,"excerpt":"My name is Stefan Oehrli. I'm a Swiss electrical engineer working since several years as an Oracle DBA and consultant. My main interests are backup & recovery, database internals, database security, infrastructure management and other stuff coming across my daily work as a DBA and Tech Architecture Manager at Trivadis\u2026","rel":"","context":"Similar post","block_context":{"text":"Similar post","link":""},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":105,"url":"https:\/\/www.oradba.ch\/wordpress\/blog\/archives\/","url_meta":{"origin":13431,"position":1},"title":"Archive","author":"Stefan","date":"31. October 2010","format":false,"excerpt":"Here you will find a list of all the posts from the past.","rel":"","context":"Similar post","block_context":{"text":"Similar post","link":""},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":95,"url":"https:\/\/www.oradba.ch\/wordpress\/contact\/","url_meta":{"origin":13431,"position":2},"title":"Contact","author":"Stefan","date":"31. October 2010","format":false,"excerpt":"To send questions or comments not related to blog posts please use this form:","rel":"","context":"Similar post","block_context":{"text":"Similar post","link":""},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":129,"url":"https:\/\/www.oradba.ch\/wordpress\/publications\/","url_meta":{"origin":13431,"position":3},"title":"Publications","author":"Stefan","date":"31. October 2010","format":false,"excerpt":"Her you find scripts, papers and publications I wrote or co-authored. Papers and Presentations What else... Scripts Stuff that I mentioned in my posts... Tools Ok, not really my stuff but tools I regularly used...","rel":"","context":"Similar post","block_context":{"text":"Similar post","link":""},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":1300,"url":"https:\/\/www.oradba.ch\/wordpress\/public-appearances\/","url_meta":{"origin":13431,"position":4},"title":"Public Appearances","author":"Stefan","date":"29. July 2013","format":false,"excerpt":"Here you will find a list of planned and past presentations, seminars and classes.","rel":"","context":"Similar post","block_context":{"text":"Similar post","link":""},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":945,"url":"https:\/\/www.oradba.ch\/wordpress\/links\/","url_meta":{"origin":13431,"position":5},"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":[]}],"_links":{"self":[{"href":"https:\/\/www.oradba.ch\/wordpress\/wp-json\/wp\/v2\/pages\/13431","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=13431"}],"version-history":[{"count":5,"href":"https:\/\/www.oradba.ch\/wordpress\/wp-json\/wp\/v2\/pages\/13431\/revisions"}],"predecessor-version":[{"id":13453,"href":"https:\/\/www.oradba.ch\/wordpress\/wp-json\/wp\/v2\/pages\/13431\/revisions\/13453"}],"wp:attachment":[{"href":"https:\/\/www.oradba.ch\/wordpress\/wp-json\/wp\/v2\/media?parent=13431"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}