Welcome to my site

My name is Stefan Oehrli. I’m a Swiss electrical engineer working since several years as an Oracle DBA. My main interests are backup & recovery, database internals, database security, infrastructure management and other stuff coming across my daily work as a DBA. On this website I share my experience and some of my thoughts in these areas with you. Among other things, you find my blog, a few scripts, links to some papers and presentations I have written or co-authored, list of public appearances as well links to other interesting web resources.  


Recent Posts

A list of the 5 most recent posts. To see a full list go to the Blogs.

  • 15 July 2016 : Oracle CPU / PSU Pre-Release Announcement July 2016
    Oracle has published the Pre-Release Announcement for the July 2016 Critical Patch Update. It's quite a huge update with not less than 276 security vulnerability fixes across the Oracle products. For the Oracle Database itself are 9 security fixes available. Dies ist wiederum eines der größeren Critical Patch Update for databases. It does contain bug fix for some major security [Read more...]

  • 14 July 2016 : Trivadis Schwaben Gipfel – Top 10 Database Threads and Risk Management
    Just finished my second presentation at the Trivadis Schwaben-Gipfel in Stuttgart. It is about Database Threads and Risk assessment and a few considerations on Database classification. The slides are available for download .

  • 14 July 2016 : Trivadis Schwaben Gipfel – Die neue EU Datenschutzverordnung
    Just finished my first presentation at the Trivadis Schwaben-Gipfel in Stuttgart together with Florian van Keulen and Aleksander Widera. It is about the new European General Data Protection Regulation (EU GDPR) and some few considerations on its impact on Databases. The slides are available for download . Some impression for the event and my presentation.

  • 14 July 2016 : Change LDAPS Port for OUD
    Due to a typo I've configured the wrong port for the LDAPS connection handler on my OUD instance. But this is actually not a problem and can be corrected easily. First let's verify the current settings of the LDAPS connection handler. [cc lang="bash"] oracle@urania:~/ [oud_eus] dsconfig -h localhost -p 4444 -D "cn=Directory Manager" \ -j $ORACLE_HOME/OUD/config/pwd.txt --trustAll --no-prompt \ get-connection-handler-prop --handler-name "LDAPS Connection Handler" Property [Read more...]

  • 12 July 2016 : Change default JAVA_HOME for OUD Instance
    I just had a situation where I had to change the JAVA_HOME for my Oracle Unified Directory (OUD) instance. Although this is quite simple, this blog post serves as my "sticky note". During the setup of my OUD instance I've set the wrong JAVA_HOME. I've used JDK 1.8 instead recommended JRE 1.7. OUD does work well with Java 1.8, but [Read more...]