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.  

Enjoy…

Recent Posts

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

  • 27 January 2017 : Oracle 12.2.0.1 On-Premises soon available
    It seems that Oracle brings us the new release with the first "spring rays". Tonight Oracle has Updates the MOS Note 742060.1 Release Schedule of Current Database Releases. It now includes as well sections for Oracle public cloud releases, on-premises engineered systems as well on-premises server releases. In particular the section on-premises server release has now a release date for [Read more...]

  • 18 January 2017 : Oracle CPU / PSU Announcement January 2017
    Oracle has published the first Critical Patch Update in 2017. It's quite a huge update with not less than 270 new security vulnerability fixes across the Oracle products. For the Oracle Database itself are 5 security fixes available respectively 2 security fixes for the Oracle Database Server and 3 security fixes for Oracle Secure Backup and Oracle Big Data Graph. Neither [Read more...]

  • 10 January 2017 : Using TouchID for sudo on macOS Sierra
    A couple of days ago, I've received my new 15" Mac Book Pro. So far I'm quite happy. Ok the the circumstance, that I have to carry around a bunch of adapters. I'm waiting for the first projector at customers with USB-C connection. But thats an other story. Initially I thought, that I will not use the new Touch Bar [Read more...]

  • 18 November 2016 : Environment Scripts for OUD
    At Trivadis we do have the TVD-BasEnv™ to standardizes and simplifies the handling of environments for Oracle database and application server landscapes. This inspired me to create something similar for Oracle Unified Directory environments. Although current versions of TVD-BasEnv™ already support OUD and OID environment. I've had the situation, where I need some small and slimmed down environment scripts for [Read more...]

  • 8 November 2016 : Oracle 12 Release 2 Documentation available
    Oracle just released the documentation for Oracle 12c Release 2. It seems that most of the new security features are available as discussed in my presentation at DOAG SIG Security in Düsseldorf on the 18th of october. See docs.oracle.com for the documentation bookshelf. Yet a short summary of new security features Encryption TDE Tablespace Live Conversion Fully Encrypted Database Support for ARIA, [Read more...]