Using LetsEncrypt Certs with Oracle E-Business suite

Oracle Database 18c schema only accounts

One nice new feature of Oracle Database 18c is that schemas can be created without a password. These are called " ...

Orphaned disks in OVM and what to do with them

Some time ago I was doing a maintenance on an OVM and noticed that it had significant number of disks without mapping ...

Oracle GoldenGate microservices architecture - first try.

Three or four months ago Oracle released a new 12.3 version of the Oracle GoldenGate (OGG) software. The release did ...

Sending email from Oracle with utl_smtp via Amazon Simple Email Service (SES)

Note: This article was updated following Symantec Trust issues earlier in 2018.

Tackling time troubles - how to use dates correctly in Oracle

For the Oracle Code series of events I have delivered an older but still relevant talk called "Tackling Time Troubles." ...

Using AI for database administration automation - extracting useful information from log files

When talking about automation for Oracle Database Administration, besides automation of software installation and ...

Oracle database upgrade on RDS AWS and SPM baselines

Introduction A couple of days ago I saw a question posted online asking about how AWS upgrades an RDS Oracle database ...

Oracle 12.2 ASM filter driver installation

Recently I needed to install Oracle 12.2 with the ASM Filter Driver for some research on an upcoming presentation. With ...

Oracle Scheduler fail to send email notifications

Introduction In this blog post I would like to share an interesting issue we encountered couple of months ago related ...

Upgrade existing TDE to use new unified key management in 12c Upgraded Database (non-cdb)

  I'm really excited to be writing this post and I'm hoping it serves as helpful content. When reviewing the new ...

Using Oracle Wallets and SEPS with Perl, JDBC, and ODBC

A few years ago I wrote a couple of popular blog articles on using Secure External Password Stores (SEPS) and ...

Oracle’s Database Security Assessment Tool (DBSAT) Version 2 (2.0.1)

Background Oracle recently released a new version of their Database Security Assessment Tool (DBSAT) - version 2.0.1. ...

Standardizing the Oracle GoldenGate Home Path (OGG_HOME)

Introduction I don't work with Oracle GoldenGate extensively but when I do I find it somewhat remarkable that there ...

gh-ost with Amazon RDS / Aurora

Doing online schema changes in a managed database environment is not as straight-forward as one may think. Using gh-ost ...

Automating password rotation for Oracle databases

Password rotation is not the most exciting task in the world, and that's exactly why it's a perfect candidate for ...

Idempotent and Nullipotent in Cloud

It’s funny how the more things change in tech, the more we end up reaching for those dusty university textbooks. ...

Locating most current record using ROW_NUMBER() vs. Index Full Scan (Min/Max)

Very often when reading data, we need to locate the most current record for a set of conditions. One typical example is ...

Improve Oracle performance with ASM filter driver

Context Sometimes the results found in performance testing can be a bit of a surprise. I have recently been preparing ...

Automation, PowerShell and Word Templates - let the technician do tech

In my work as a Database Consultant, I enjoy technical challenges, but it's always a painful process when I need to ...

Cleaning up PID files when Oracle GRID/RAC upgrades and patches fail

Introduction: Unfortunately is it not all that unusual for a patch or upgrade to Oracle Grid or RAC to fail, requiring ...

Log rotation for Oracle database

Most of you may already know how to configure the log rotation for your database alert log or the listener log etc,. As ...

What you should know about Docker Containers for Oracle Data Integrator

Not long ago, Oracle adopted the Docker engine as one of the accepted platforms for its products and published a set of ...

How Linux Hugepages work to improve Oracle performance

This post is not intended to be an in-depth discussion of how Linux Hugepages work, but rather just a cursory ...

A look at current "Infrastructure as Code" Trends

Unless you have been hiding under a rock, you have probably heard the term “Infrastructure as a Code” thrown around. ...

How to fix an AWR Warehouse after credentials change

We had an AWR Warehouse (AWRW) installation (OEM 12.1.0.5 on Linux) collecting data from +50 databases for a few ...

The importance of Oracle database related kernel parameters (aio-max-nr) (with bonus track)

We tend to configure a server following Oracle best practices for the kernel parameters, but what once was a server of ...