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.
- 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 188.8.131.52, 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 184.108.40.206 and 220.127.116.11 databases I do also have a 18.104.22.168 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...]
- 3 September 2015 : Memory Leak in Network Checksum with new SHA-2 Functions
I've just stumbled over an issue with the new checksum algorithm introduced with Oracle 12c. It seams that in certain situation the new SHA-2 function cause a memory leak. A search on My Oracle Support revealed that there is a Bug on AIX. See Bug 19451972 MEMEORY LEAKS WITH SHA512, SHA384, SHA256 ENTRIES IN SQLNET.CRYPTO_CHECKSUM and the corresponding Note 1919000.1 [Read more...]