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.

  • 14 September 2016 : Losing the Oracle Wallet for Enterprise User Security
    Having a reliable backup solution for your Transparent Data Encryption (TDE) or Enterprise User Security (EUS) Wallets, is beyond discussion. Nevertheless it can happen that you lose or corrupt the Oracle Wallet. With Transparent Data Encryption (TDE), this is really bad luck, because you can not access your encrypted data. Losing an EUS wallet is on the other side not [Read more...]

  • 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...]