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.
A list of the 5 most recent posts. To see a full list go to the Blogs.
- 16 June 2017 : GDPR and Database Security Speeches
The new EU GDPR and Database Security in general keeps me busy. I've updated the list of speeches and events for the next couple of month. It's an interesting mix between GDPR, Oracle Database Security and MS SQL Server 2016 security. Depending on the feedback of the Call For Papers for the DOAG Conference and the Oracle OpenWorld there will [Read more...]
- 12 June 2017 : DOAG Webinar Oracle 12.2 New Security Features
A couple of days ago I've successfully finished the DOAG Webinar on Oracle 12c Release 2 new Security Feature. It was a great opportunity to discuss the security enhancements in the latest Oracle database release. This release introduces some new security features that simplify the secure operation of on-premises or cloud-based databases. Especially the online encryption of tablespaces with TDE. Based [Read more...]
- 16 May 2017 : Start OUD Servers on Boot using systemd
Starting Oracle Unified Directory on system boot is essential for production environment. Unfortunately OUD just provides a script to create the init.d script. But newer system in general use systemd initialise and startup. Nevertheless, creating a custom unit file for OUD is simple and straightforward. First, let's create a regular init.d script with the create-rc-script from oud. The created custom [Read more...]
- 21 April 2017 : EU GDPR, MS SQL Server 2016 and Oracle Security
I've just updated the list of my public appearances and planned events. For once, no just Oracle Events 🙂 I'll speak about the new EU GDPR and its impact on databases in a Trivadis regional customer event together with my colleague Stephan Hurni. Beside this two events I'll hold a webinar on Oracle 12c Release 2 new security features. This [Read more...]
- 19 April 2017 : Oracle CPU / PSU Announcement April 2017
Last night Oracle released there new Critical Patch Update. From the DB perspective it is a rather small patch update. It just includes 2 fixes for security vulnerabilities on Oracle database 18.104.22.168 and 22.214.171.124. None of the vulnerabilities are remote exploitable without authentication but one fix is also for client only installations. The highest CVSS Base Score of vulnerabilities affecting [Read more...]