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.
- 1 April 2016 : DOAG SIG Security Mannheim 2016
Bit more than two weeks ago I finished my presentation about Security Probleme und deren Risikobewertung at the DOAG SIG Security in Mannheim. It is about Database and Data Classification, Risk Assessment and how Risks could be minimized. The slides are available for download .
- 22 December 2015 : Audit Vault and Database Firewall 12.2
Oracle has just released a new major Release of its Oracle Audit Vault and Database Firewall. The new release is immediately available on Oracle's Software Delivery Cloud. But the OTN website have not been updated. Beside the upgrade of the OS and embedded Oracle Database to 22.214.171.124, Oracle added a bunch of Enterprise-Grade Features. Starting with this Release all new [Read more...]
- 9 November 2015 : Release of Audit Vault and Database Firewall 12.1.2 Bundle Patch 7
Today Oracle released the new Bundle Patch for Audit Vault and Database Firewall 12.1.2. The patch can be downloaded as usual on Oracle Metalink as Patchset 21920205 for existing installations. The full installation image for new installations is not yet available on Oracle eDelivery. I guess this will follow in a couple of days. Beside the Bundle Patch, Oracle will [Read more...]
- 31 October 2015 : WALLET_LOCATION in sqlnet.ora for Container Databases
Recently I've setup Oracle Enterprise User Security (EUS) with Oracle Unified Directory (OUD) on my favorite linux test system. Among regular 126.96.36.199 and 188.8.131.52 databases I do also have a 184.108.40.206 Container Database. EUS work like a charm on the regular databases but not on the PDB. [cc lang="sql"] SQL> conn soe Enter password: ERROR: ORA-28305: WALLET_LOCATION in sqlnet.ora file for container database [Read more...]
- 30 October 2015 : OPatch silent and unattended
In general I use Oracle OPatch interactively in command line mode to install patch set updates. But recently I did patch a system cloud based system, with a confusing network timeout. As expected I did get a broken pipe while executing OPatch. Ok, the system is also damn slow, which is not exactly helpful. Never mind, this was the time [Read more...]