Creating a Gold Image of an Oracle Home with runInstaller -createGoldImage
can leak sensitive information about the source environment! Learn how to identify and eliminate the risks!
All in Scripts and Tools
Creating a Gold Image of an Oracle Home with runInstaller -createGoldImage
can leak sensitive information about the source environment! Learn how to identify and eliminate the risks!
Do you run Docker on Linux? Do you use a custom directory instead of /var/lib/docker
? Did Docker recently stop working? If so, you may have configured your docker.service configuration file with an obsolete parameter. Fortunately, it’s an easy fix! Read on for more!
Learn how to use native Linux services to manage Observers in Data Guard Fast-Start Failover configurations, and build more durable, reliable, and simple solutions than scripting alone!
Finding missing archive logs when gaps are many and random is a tedious exercise. Learn how to use awk to find and generate restore scripts for the missing files! My contribution for #JoelKallmanDay!
Several blog posts describe how to authenticate with My Oracle Support and download patches. Unfortunately, some rely on manual authentication with MOS on one host to generate the cookie file, then copy the cookie to the automation machine. I needed a fully-automated solution that used curl.
This is the second in a multi-part series on building Docker images for Oracle 19c. In the first installment I demonstrated a Dockerfile for building images using the Oracle 19c RPM and applying Release Updates (RU) to the new home. In this post I describe the remaining steps necessary for running Docker images using the RPM-based installation.
The first in a multi-part series on building Docker images for Oracle 19c using the 19c RPM. Part 1 shows the Dockerfile used to create an Oracle 19c database via RPM install, update OPatch and apply the 19.8 Release Update (RU) to the Oracle Home. Part 2 covers the remaining components of the Docker build. Part 3 describes how to take multiple images and merge them to create containers with an older 11g or 12c Oracle home and database running alongside a 19c home, ready for testing and practicing your Oracle 19c upgrades!
Adding certificates to a wallet for SSL/TLS access can be tedious and time consuming, particularly when multiple sites are involved. The answer? Automate it!
Oracle enforces complexity rules for passwords when creating databases. How do you generate random passwords while guaranteeing the rules are met, particularly when automating database creation?
How do you report on all your SIDs, or automate processes to run against everything that’s installed (or just running) on a database server? bash scripting, of course! Here are some scripts I use to generate a variety of output for LInux and Solaris systems.
In RAC, services can be “pinned” to specific, preferred, nodes. This allows DBAs to control activity on individual nodes and even force different types of activity to run on a particular node. How can you tell when they’ve been relocated and need attention? This script will help!