{"id":13131,"date":"2023-04-05T11:59:45","date_gmt":"2023-04-05T09:59:45","guid":{"rendered":"https:\/\/www.oradba.ch\/wordpress\/?p=13131"},"modified":"2023-05-21T07:12:34","modified_gmt":"2023-05-21T05:12:34","slug":"get-oracle-database-23c-for-free-on-your-mac-m1","status":"publish","type":"post","link":"https:\/\/www.oradba.ch\/wordpress\/2023\/04\/get-oracle-database-23c-for-free-on-your-mac-m1\/","title":{"rendered":"Get Oracle Database 23c for free on your Mac M1"},"content":{"rendered":"\n<p>Oracle Database 23c Free &#8211; Developer Release is all over since Oracle released it yesterday. See the Official Oracle pages <a rel=\"noreferrer noopener\" href=\"https:\/\/www.oracle.com\/database\/free\/\" target=\"_blank\">Oracle Database Free<\/a> or the blog post by Gerald Venzl <em><a rel=\"noreferrer noopener\" href=\"https:\/\/blogs.oracle.com\/database\/post\/oracle-database-23c-free\" target=\"_blank\">Introducing Oracle Database 23c Free \u2013 Developer Release<\/a><\/em>. Connor McDonald even got a <a rel=\"noreferrer noopener\" href=\"https:\/\/t.co\/vmvlOvM1TI\" target=\"_blank\">special delivery<\/a> from Oracle.<\/p>\n\n\n\n<p>A few important web pages related to Oracle Database 23c Free.<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Landing page for <a rel=\"noreferrer noopener\" href=\"https:\/\/www.oracle.com\/database\/free\/\" data-type=\"URL\" data-id=\"https:\/\/www.oracle.com\/database\/free\/\" target=\"_blank\">Oracle Database Free<\/a><\/li>\n\n\n\n<li>Download page for <a href=\"https:\/\/www.oracle.com\/database\/technologies\/free-downloads.html\" target=\"_blank\" rel=\"noreferrer noopener\">Oracle Database Free<\/a><\/li>\n\n\n\n<li>Documentation Library <a href=\"https:\/\/docs.oracle.com\/en\/database\/oracle\/oracle-database\/23\/index.html\" target=\"_blank\" rel=\"noreferrer noopener\">Oracle Database 23c Free &#8211; Developer Release<\/a><\/li>\n\n\n\n<li>Oracle\u00ae Database &#8211; <a href=\"https:\/\/docs.oracle.com\/en\/database\/oracle\/oracle-database\/23\/rnrdm\/index.html\" target=\"_blank\" rel=\"noreferrer noopener\">Database Release Notes 23c<\/a><\/li>\n\n\n\n<li>Oracle\u00ae Database &#8211; <a rel=\"noreferrer noopener\" href=\"https:\/\/docs.oracle.com\/en\/database\/oracle\/oracle-database\/23\/nfcoa\/index.html\" target=\"_blank\">Oracle Database New Features Release 23c<\/a><\/li>\n<\/ul>\n\n\n\n<p>Ok, so what do we do now in order to be able to use Oracle Database 23c Free on a Mac with Apple Silicon? Setup a Vagrant VM, Docker Container or rather use a cloud based solution? Below I show you how to do this relatively easily using a Docker container that runs reasonably well.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Requirements<\/h2>\n\n\n\n<p>Basically, x86-64 based Docker containers also run on Apple Silicon \/ ARM. <s>However, these are emulated with Rosetta2 and are not as stable \/ performant.<\/s>  But the whole thing is a bit more complex than described there. <em>Docker<\/em> and <em>colima<\/em> can both use <em>Rosetta 2<\/em>, although <em>Rosetta 2<\/em> is always slower than native ARM code but faster than <em>QEMU<\/em>. Because <em>Rosetta 2<\/em> does not know or provide all instructions, it can lead to problems depending on the container. Therefore certain containers are less stable. <em>QEMU<\/em> on the other hand interprets every instruction. Thus it is more stable but slower.&nbsp;Therefore things are somewhat better when using <em>colima<\/em> with <em>x86-64<\/em>. In the end, the performance is not that great. However, it is sufficient for simple tests on the road. Maybe I will find some time to go deeper into the topics of ARM\/x86-64 with Rosetta 2, QEMU etc. <\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><a rel=\"noreferrer noopener\" href=\"https:\/\/brew.sh\/\" target=\"_blank\">Homebrew<\/a> package manager for MacOS. Not mandatory, but makes life much easier<\/li>\n\n\n\n<li><a href=\"https:\/\/docs.docker.com\/desktop\/install\/mac-install\/\" target=\"_blank\" rel=\"noreferrer noopener\">Docker<\/a> Desktop for MacOS<\/li>\n\n\n\n<li><a rel=\"noreferrer noopener\" href=\"https:\/\/github.com\/abiosoft\/colima\" target=\"_blank\">Colima<\/a> a container runtimes for macOS (and Linux) with minimal setup<\/li>\n\n\n\n<li><a rel=\"noreferrer noopener\" href=\"https:\/\/container-registry.oracle.com\/ords\/f?p=113:4:114152202829809:::4:P4_REPOSITORY,AI_REPOSITORY,AI_REPOSITORY_NAME,P4_REPOSITORY_NAME,P4_EULA_ID,P4_BUSINESS_AREA_ID:1863,1863,Oracle%20Database%20Free,Oracle%20Database%20Free,1,0&amp;cs=3iy2jXwB96IFJe9XrwkE6gbRI5msgtY1C0IWjcEBLYMwKNk_XE3lMo5nj8moH97dtfCe8COyCX9mgng41VfNaQA\" target=\"_blank\">Oracle Database 23c Free<\/a> Docker image from the <a rel=\"noreferrer noopener\" href=\"https:\/\/container-registry.oracle.com\/\" target=\"_blank\">Oracle Container Registry<\/a><\/li>\n\n\n\n<li>Oracle SQL Developer or SQLCli to access the database <\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\">Setup and Run<\/h2>\n\n\n\n<p>You can either configure all the stuff mentioned above manual or use brew. I do prever brew whenever possible. So let&#8217;s install brew first <\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"bash\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">\/bin\/bash -c \"$(curl -fsSL https:\/\/raw.githubusercontent.com\/Homebrew\/install\/HEAD\/install.sh)\"<\/pre>\n\n\n\n<p>Update and upgrade your <em>brew<\/em> installation<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">brew update\nbrew upgrade<\/pre>\n\n\n\n<p>Install <em>colima<\/em> and <em><em>Docker<\/em><\/em> for MacOS<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">brew install colima docker<\/pre>\n\n\n\n<p>We are now ready to start colima. See GitHub repository <a rel=\"noreferrer noopener\" href=\"https:\/\/github.com\/abiosoft\/colima\" target=\"_blank\">abiosoft\/colima<\/a> for full usage<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">colima start --arch x86_64 --memory 4<\/pre>\n\n\n\n<p>Start up the Oracle Database 23c Free <em>Docker<\/em> container. As <em>Docker<\/em> has to pull about 3GB, it will take a while depending on the networkspeed.<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">docker run -d --name db23c -P container-registry.oracle.com\/database\/free<\/pre>\n\n\n\n<p>As usual, you have to wait a month for an Oracle database to be created. With <em>Docker<\/em> logs you can check when the database is available.<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">docker logs -f db23c<\/pre>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">Starting Oracle Net Listener.\nOracle Net Listener started.\nStarting Oracle Database instance FREE.\nOracle Database instance FREE started.\n\nThe Oracle base remains unchanged with value \/opt\/oracle\n#########################\nDATABASE IS READY TO USE!\n#########################\nThe following output is now a tail of the alert.log:\n===========================================================\nDumping current patch information\n===========================================================\nNo patches have been applied\n===========================================================\n2023-04-05T06:35:33.856200+00:00\nFREEPDB1(3):Opening pdb with Resource Manager plan: DEFAULT_PLAN\n2023-04-05T06:35:40.175165+00:00\nCompleted: Pluggable database FREEPDB1 opened read write \nCompleted: ALTER DATABASE OPEN<\/pre>\n\n\n\n<p>Set a new SYS password using <em>setPassword.sh<\/em><\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">docker exec db23c .\/setPassword.sh &lt;PASSWORD><\/pre>\n\n\n\n<p>And here we go let&#8217;s connect via <em>sqlplus<\/em> as SYSDBA<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">docker exec -it db23c sqlplus \/ as sysdba<\/pre>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">SQL*Plus: Release 23.0.0.0.0 - Developer-Release on Wed Apr 5 09:11:04 2023\nVersion 23.2.0.0.0\n\nCopyright (c) 1982, 2023, Oracle.  All rights reserved.\n\n\nConnected to:\nOracle Database 23c Free, Release 23.0.0.0.0 - Developer-Release\nVersion 23.2.0.0.0\n\nSQL> select sysdate;\n\nSYSDATE\n---------\n05-APR-23\n\nSQL><\/pre>\n\n\n\n<p>If you prefer, you can also use SQL Developer. Just login to localhost, port and service name. If you started the container with -P like me, <em>docker ps<\/em> or <em>docker ports<\/em> shows the corresponding port.<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">docker port db23c<\/pre>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">1521\/tcp -> 0.0.0.0:49153\n1521\/tcp -> :::49153<\/pre>\n\n\n\n<p>SQL Developer configuration for the local Docker container. Port must be adjusted accordingly.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"625\" height=\"401\" src=\"https:\/\/i0.wp.com\/www.oradba.ch\/wordpress\/wp-content\/uploads\/Screenshot-2023-04-05-at-12.11.24.png?resize=625%2C401&#038;ssl=1\" alt=\"\" class=\"wp-image-13140\" srcset=\"https:\/\/i0.wp.com\/www.oradba.ch\/wordpress\/wp-content\/uploads\/Screenshot-2023-04-05-at-12.11.24.png?w=779&amp;ssl=1 779w, https:\/\/i0.wp.com\/www.oradba.ch\/wordpress\/wp-content\/uploads\/Screenshot-2023-04-05-at-12.11.24.png?resize=300%2C193&amp;ssl=1 300w, https:\/\/i0.wp.com\/www.oradba.ch\/wordpress\/wp-content\/uploads\/Screenshot-2023-04-05-at-12.11.24.png?resize=768%2C493&amp;ssl=1 768w, https:\/\/i0.wp.com\/www.oradba.ch\/wordpress\/wp-content\/uploads\/Screenshot-2023-04-05-at-12.11.24.png?resize=624%2C401&amp;ssl=1 624w\" sizes=\"auto, (max-width: 625px) 100vw, 625px\" \/><\/figure>\n<\/div>\n\n\n<p>And here we go&#8230;<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"528\" height=\"294\" src=\"https:\/\/i0.wp.com\/www.oradba.ch\/wordpress\/wp-content\/uploads\/Screenshot-2023-04-05-at-11.26.07.png?resize=528%2C294&#038;ssl=1\" alt=\"\" class=\"wp-image-13136\" srcset=\"https:\/\/i0.wp.com\/www.oradba.ch\/wordpress\/wp-content\/uploads\/Screenshot-2023-04-05-at-11.26.07.png?w=528&amp;ssl=1 528w, https:\/\/i0.wp.com\/www.oradba.ch\/wordpress\/wp-content\/uploads\/Screenshot-2023-04-05-at-11.26.07.png?resize=300%2C167&amp;ssl=1 300w\" sizes=\"auto, (max-width: 528px) 100vw, 528px\" \/><\/figure>\n<\/div>\n\n\n<h2 class=\"wp-block-heading\">First Steops<\/h2>\n\n\n\n<p>Installation of the SCOTT schema. But first update the script to connect to the pluggable database.<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">docker exec db23c sed -i \"s|CONNECT SCOTT\/tiger$|CONNECT SCOTT\/tiger@freepdb1|\" \\\n\/opt\/oracle\/product\/23c\/dbhomeFree\/rdbms\/admin\/utlsampl.sql<\/pre>\n\n\n\n<p>Run SQLPlus to create the SCOTT schema<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">docker exec -it db23c sqlplus \/ as sysdba<\/pre>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"sql\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">ALTER SESSION SET CONTAINER=freepdb1;\n@?\/rdbms\/admin\/utlsampl.sql<\/pre>\n\n\n\n<p>Create a new user and grant him read access to the tables of the SCOTT schema.<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">ALTER SESSION SET CONTAINER=freepdb1;\nCREATE USER king IDENTIFIED BY tiger;\nGRANT CREATE SESSION TO king;\nGRANT READ ANY TABLE ON SCHEMA scott TO king;<\/pre>\n\n\n\n<p>And test it as KING<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"sql\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">CONNECT king\/tiger@freepdb1\nSET PAGESIZE 200\nSET LINESIZE 120\nSET PAGESIZE 200\nSELECT * FROM scott.emp;<\/pre>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">     EMPNO ENAME      JOB\t       MGR HIREDATE\t    SAL       COMM     DEPTNO\n---------- ---------- --------- ---------- --------- ---------- ---------- ----------\n      7369 SMITH      CLERK\t      7902 17-DEC-80\t    800 \t\t   20\n      7499 ALLEN      SALESMAN\t      7698 20-FEB-81\t   1600        300\t   30\n      7521 WARD       SALESMAN\t      7698 22-FEB-81\t   1250        500\t   30\n      7566 JONES      MANAGER\t      7839 02-APR-81\t   2975 \t\t   20\n      7654 MARTIN     SALESMAN\t      7698 28-SEP-81\t   1250       1400\t   30\n      7698 BLAKE      MANAGER\t      7839 01-MAY-81\t   2850 \t\t   30\n      7782 CLARK      MANAGER\t      7839 09-JUN-81\t   2450 \t\t   10\n      7788 SCOTT      ANALYST\t      7566 19-APR-87\t   3000 \t\t   20\n      7839 KING       PRESIDENT \t   17-NOV-81\t   5000 \t\t   10\n      7844 TURNER     SALESMAN\t      7698 08-SEP-81\t   1500 \t 0\t   30\n      7876 ADAMS      CLERK\t      7788 23-MAY-87\t   1100 \t\t   20\n      7900 JAMES      CLERK\t      7698 03-DEC-81\t    950 \t\t   30\n      7902 FORD       ANALYST\t      7566 03-DEC-81\t   3000 \t\t   20\n      7934 MILLER     CLERK\t      7782 23-JAN-82\t   1300 \t\t   10\n\n14 rows selected.<\/pre>\n\n\n\n<p>Excellent, full READ access to a schema respectively the tables of a schema with only one statement.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Conclusion<\/h2>\n\n\n\n<p>The Developer Release of Oracle Database 23c is great. A unique opportunity to test various Oracle features very early without having to join the Oracle Beta Program. But be aware, do not expect light speed when runing an Oracle Database Container on Apple Silicon. This workaround is ideal when you are on the road and want to test nes stuff. For reliable speed, there is no way around running Oracle Database 23c on an x86-64 system. Either you have an old Mac lying around or you build a small environment in the cloud. But who knows, maybe Oracle will surprise us with an ARM version of Oracle Database 23c\u2026<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Oracle Database 23c Free &#8211; Developer Release is all over since Oracle released it yesterday. See the Official Oracle pages Oracle Database Free or the blog post by Gerald Venzl Introducing Oracle Database 23c Free \u2013 Developer Release. Connor McDonald even got a special delivery from Oracle. A few important web pages related to Oracle [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_exactmetrics_skip_tracking":false,"_exactmetrics_sitenote_active":false,"_exactmetrics_sitenote_note":"","_exactmetrics_sitenote_category":0,"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":true,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2}},"categories":[227,177,175,30],"tags":[],"class_list":["post-13131","post","type-post","status-publish","format-standard","hentry","category-23c","category-docker","category-howto","category-mac-os-x"],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"","jetpack_shortlink":"https:\/\/wp.me\/p1aErb-3pN","jetpack_sharing_enabled":true,"jetpack-related-posts":[{"id":14769,"url":"https:\/\/www.oradba.ch\/wordpress\/2024\/01\/dive-into-the-latest-enhancements-of-dbsat-3-1-0\/","url_meta":{"origin":13131,"position":0},"title":"Dive into the Latest Enhancements of DBSat 3.1.0","author":"Stefan","date":"16. January 2024","format":false,"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\u2026","rel":"","context":"In &quot;23c&quot;","block_context":{"text":"23c","link":"https:\/\/www.oradba.ch\/wordpress\/category\/oracle-database\/23c\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/www.oradba.ch\/wordpress\/wp-content\/uploads\/DBSat_3.1.0.png?resize=350%2C200&ssl=1","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/www.oradba.ch\/wordpress\/wp-content\/uploads\/DBSat_3.1.0.png?resize=350%2C200&ssl=1 1x, https:\/\/i0.wp.com\/www.oradba.ch\/wordpress\/wp-content\/uploads\/DBSat_3.1.0.png?resize=525%2C300&ssl=1 1.5x, https:\/\/i0.wp.com\/www.oradba.ch\/wordpress\/wp-content\/uploads\/DBSat_3.1.0.png?resize=700%2C400&ssl=1 2x, https:\/\/i0.wp.com\/www.oradba.ch\/wordpress\/wp-content\/uploads\/DBSat_3.1.0.png?resize=1050%2C600&ssl=1 3x"},"classes":[]},{"id":16071,"url":"https:\/\/www.oradba.ch\/wordpress\/2024\/09\/its-a-wrap-soug-day-in-zurich-and-romandie\/","url_meta":{"origin":13131,"position":1},"title":"It\u2019s a Wrap: SOUG Day in Zurich and Romandie","author":"Stefan","date":"24. September 2024","format":false,"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\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\/soug2024-zurich.jpeg?resize=350%2C200&ssl=1","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/www.oradba.ch\/wordpress\/wp-content\/uploads\/soug2024-zurich.jpeg?resize=350%2C200&ssl=1 1x, https:\/\/i0.wp.com\/www.oradba.ch\/wordpress\/wp-content\/uploads\/soug2024-zurich.jpeg?resize=525%2C300&ssl=1 1.5x, https:\/\/i0.wp.com\/www.oradba.ch\/wordpress\/wp-content\/uploads\/soug2024-zurich.jpeg?resize=700%2C400&ssl=1 2x, https:\/\/i0.wp.com\/www.oradba.ch\/wordpress\/wp-content\/uploads\/soug2024-zurich.jpeg?resize=1050%2C600&ssl=1 3x"},"classes":[]},{"id":14472,"url":"https:\/\/www.oradba.ch\/wordpress\/2023\/11\/doag-2023-debrief-a-speakers-perspective\/","url_meta":{"origin":13131,"position":2},"title":"DOAG 2023 Debrief: A Speaker&#8217;s Perspective","author":"Stefan","date":"24. November 2023","format":false,"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\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\/IMG_3152.jpg?resize=350%2C200&ssl=1","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/www.oradba.ch\/wordpress\/wp-content\/uploads\/IMG_3152.jpg?resize=350%2C200&ssl=1 1x, https:\/\/i0.wp.com\/www.oradba.ch\/wordpress\/wp-content\/uploads\/IMG_3152.jpg?resize=525%2C300&ssl=1 1.5x, https:\/\/i0.wp.com\/www.oradba.ch\/wordpress\/wp-content\/uploads\/IMG_3152.jpg?resize=700%2C400&ssl=1 2x, https:\/\/i0.wp.com\/www.oradba.ch\/wordpress\/wp-content\/uploads\/IMG_3152.jpg?resize=1050%2C600&ssl=1 3x, https:\/\/i0.wp.com\/www.oradba.ch\/wordpress\/wp-content\/uploads\/IMG_3152.jpg?resize=1400%2C800&ssl=1 4x"},"classes":[]},{"id":14374,"url":"https:\/\/www.oradba.ch\/wordpress\/2023\/11\/what-you-need-to-know-about-oracle-db-sat-release-3-0\/","url_meta":{"origin":13131,"position":3},"title":"What You Need to Know About Oracle DB SAT Release 3.0","author":"Stefan","date":"16. November 2023","format":false,"excerpt":"The wait is over! After a long break, Oracle has launched a major update for its Database Security Assessment Tool, DBSAT. The latest version, DBSAT 3.0, includes a number of new features and enhancements, all aimed at increasing database security and optimizing compliance processes. In this post, I'll look at\u2026","rel":"","context":"Similar post","block_context":{"text":"Similar post","link":""},"img":{"alt_text":"DBSat","src":"https:\/\/i0.wp.com\/www.oradba.ch\/wordpress\/wp-content\/uploads\/DBSat.png?resize=350%2C200&ssl=1","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/www.oradba.ch\/wordpress\/wp-content\/uploads\/DBSat.png?resize=350%2C200&ssl=1 1x, https:\/\/i0.wp.com\/www.oradba.ch\/wordpress\/wp-content\/uploads\/DBSat.png?resize=525%2C300&ssl=1 1.5x, https:\/\/i0.wp.com\/www.oradba.ch\/wordpress\/wp-content\/uploads\/DBSat.png?resize=700%2C400&ssl=1 2x, https:\/\/i0.wp.com\/www.oradba.ch\/wordpress\/wp-content\/uploads\/DBSat.png?resize=1050%2C600&ssl=1 3x, https:\/\/i0.wp.com\/www.oradba.ch\/wordpress\/wp-content\/uploads\/DBSat.png?resize=1400%2C800&ssl=1 4x"},"classes":[]},{"id":14785,"url":"https:\/\/www.oradba.ch\/wordpress\/2024\/01\/latest-critical-patch-updates-from-oracle-january-2024\/","url_meta":{"origin":13131,"position":4},"title":"Latest Critical Patch Updates from Oracle &#8211; January 2024","author":"Stefan","date":"18. January 2024","format":false,"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\u2026","rel":"","context":"In &quot;19c&quot;","block_context":{"text":"19c","link":"https:\/\/www.oradba.ch\/wordpress\/category\/oracle-database\/19c\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/www.oradba.ch\/wordpress\/wp-content\/uploads\/CPU-Patch-Jan-2024.png?resize=350%2C200&ssl=1","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/www.oradba.ch\/wordpress\/wp-content\/uploads\/CPU-Patch-Jan-2024.png?resize=350%2C200&ssl=1 1x, https:\/\/i0.wp.com\/www.oradba.ch\/wordpress\/wp-content\/uploads\/CPU-Patch-Jan-2024.png?resize=525%2C300&ssl=1 1.5x, https:\/\/i0.wp.com\/www.oradba.ch\/wordpress\/wp-content\/uploads\/CPU-Patch-Jan-2024.png?resize=700%2C400&ssl=1 2x, https:\/\/i0.wp.com\/www.oradba.ch\/wordpress\/wp-content\/uploads\/CPU-Patch-Jan-2024.png?resize=1050%2C600&ssl=1 3x"},"classes":[]},{"id":14847,"url":"https:\/\/www.oradba.ch\/wordpress\/2024\/01\/its-a-wrap-insights-from-the-soug-espresso-on-oracle-audit\/","url_meta":{"origin":13131,"position":5},"title":"It\u2019s a Wrap: Insights from the SOUG Espresso on Oracle Audit","author":"Stefan","date":"26. January 2024","format":false,"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\u2026","rel":"","context":"In &quot;19c&quot;","block_context":{"text":"19c","link":"https:\/\/www.oradba.ch\/wordpress\/category\/oracle-database\/19c\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/www.oradba.ch\/wordpress\/wp-content\/uploads\/SOUG2024_expresso_audit_oehrli.png?resize=350%2C200&ssl=1","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/www.oradba.ch\/wordpress\/wp-content\/uploads\/SOUG2024_expresso_audit_oehrli.png?resize=350%2C200&ssl=1 1x, https:\/\/i0.wp.com\/www.oradba.ch\/wordpress\/wp-content\/uploads\/SOUG2024_expresso_audit_oehrli.png?resize=525%2C300&ssl=1 1.5x, https:\/\/i0.wp.com\/www.oradba.ch\/wordpress\/wp-content\/uploads\/SOUG2024_expresso_audit_oehrli.png?resize=700%2C400&ssl=1 2x"},"classes":[]}],"_links":{"self":[{"href":"https:\/\/www.oradba.ch\/wordpress\/wp-json\/wp\/v2\/posts\/13131","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.oradba.ch\/wordpress\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.oradba.ch\/wordpress\/wp-json\/wp\/v2\/types\/post"}],"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=13131"}],"version-history":[{"count":6,"href":"https:\/\/www.oradba.ch\/wordpress\/wp-json\/wp\/v2\/posts\/13131\/revisions"}],"predecessor-version":[{"id":13339,"href":"https:\/\/www.oradba.ch\/wordpress\/wp-json\/wp\/v2\/posts\/13131\/revisions\/13339"}],"wp:attachment":[{"href":"https:\/\/www.oradba.ch\/wordpress\/wp-json\/wp\/v2\/media?parent=13131"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.oradba.ch\/wordpress\/wp-json\/wp\/v2\/categories?post=13131"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.oradba.ch\/wordpress\/wp-json\/wp\/v2\/tags?post=13131"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}