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.

  • 22 July 2014 : Oracle Patchset released
    Oracle has released the first patchset for Oracle 12c Release 1. Or at least partially released on Oracle Software Delivery Cloud eDelivery.oracle.com. So far the patch set is only available for Linux x86-64bit, Oracle Solaris on SPARC 64bit and Oracle Solaris on x86-64bit. I will update this post and provide more information as soon as the patch set or [Read more...]

  • 22 July 2014 : Secure External Password Store for RMAN
    The draft version of this blog post is lying around for some time in my inbox. I've never found time to finish it. But due to a task in a project it's about time to finish my notes on Oracle's Secure External Password Store. Ludovico, a work colleague has already written a blog post about Removing passwords from Oracle scripts [Read more...]

  • 11 July 2014 : Oracle CPU / PSU Pre-Release Announcement July 2014
    Oracle has published the Pre-Release Announcement for the July 2014 Critical Patch Update. It looks like that the next Critical Patch Update is somewhat more extensive from the database point of view. It does contain six bug fix for some major security issues. Some of the vulnerabilities may be remotely exploitable without authentication. The security bug fixes are for the [Read more...]

  • 2 July 2014 : Release of Audit Vault and Database Firewall 12.1.2 Bundle Patch 1
    Earlier today, Oracle has released the first Bundle Patch for Audit Vault and Database Firewall 12.1.2. The patch can be downloaded on Oracle Metalink as Patchset 18728905 for existing installations or on Oracle eDelivery as full installation image for new installations. The installation image is split in two parts which need to be merged before use. A short description on [Read more...]

  • 12 June 2014 : Oracle passwords and special characters
    As commonly known passwords should have a certain complexity. Thereby it is common to use special characters, numbers, lower and uppercase characters. Depending on the type of special characters Oracle require that the password is enclosed in double quotation marks. Oracle does provide a guideline for Securing Passwords in the Oracle® Database Security Guide. So far so well, depending on [Read more...]