Simple steps for overcoming the “unable to retrieve auth token: invalid username/password: authentication required” message encountered when trying to pull images from container-registry.oracle.com.
Use Caution When Creating Gold Images!
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!
Run Oracle 23c On-Premises NOW
Oracle Database 23c is currently only available on OCI Base Database Service, but that doesn’t mean you need to wait to run in locally!
Critical Issue in AHF 23.4.0 May Delete Remote ORACLE_HOMEs
A critical regression in AHF 23.4.0 may delete the ORACLE_HOME(s) on remote nodes of a RAC cluster. Learn what systems are affected and what you can do to avoid this issue!
Docker Service Startup Failure When Using A Custom Docker Directory on Linux
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!
"Oracle on Docker" is now available!
The day is here at last! My book, “Oracle on Docker: Running Oracle Databases in Linux Containers,” is available for purchase through Apress, Amazon, and Barnes & Noble! Download your free sample chapter on Persistence for Oracle Databases in containers now!
Create a Fast-Start Failover Observer Service on Linux
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!
Find the Gap
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!
Automate My Oracle Support Patch Downloads with curl
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.
Oracle 19c on Docker: Install Oracle via RPM (Part II)
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.
Oracle 19c on Docker: Install Oracle via RPM (Part I)
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!
What's Your Downtime Opportunity?
Are you prepared to convert an unplanned outage into an opportunity to improve your database?
An Oracle Zombie Database Mystery (and a chance to win $25!)
To promote my new YouTube Oracle technology channel I’m giving a $25 Amazon gift card to the first person to solve an Oracle puzzle. Subscribe to my channel and comment on the video with your answer. The first person to post the correct answer wins $25!
Add Certificates to Wallets Automatically with DevOps
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!
Generate Random Passwords for Automated Oracle Installs
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?
Loading Fixed Width Data into ATP/ADW with DBMS_CLOUD
AKA “The Definitive (and perhaps only) Guide to Loading Fixed-Width Data Into an Autonomous Database using DBMS_CLOUD”
Reporting and Automating Across Instances on a Host
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.
Oracle 19c rpm Install on OCI Free Compute Instance
Installing Oracle 18c/19c on the OCI free tier using a compute instance? Want to install a sample database using the automatic configuration tool? It will produce a DBT-11205 warning for an undersized shared pool. How do you get around it?