101 Series of Oracle in Google Cloud - Part I : Building ASM and Database

Introduction to Oracle on Google Cloud About a year ago, I worked on a project with some amazing teammates (Simon Pane ...

Services [not] Starting Automatically with CRS after Reboot?

Hello all! So, a client asked me to check why his database was not starting with CRS after a reboot. I started ...

Oracle RAC: Network Performance with Jumbo Frames

Introduction When working with Oracle RAC, it's strongly advised to use Jumbo Frames for the network that provides the ...

OEM 13c Monitoring Features - Part 5, Best Practices and Automatic Incident Creation

T his is the fifth in a series of blog posts covering the most important topics you should know to completely monitor ...

Use RMAN KEEP Backup To Roll Back From an Upgrade

There is a requirement to back up a database before an application upgrade to be able to rollback. Guarantee Restore ...

Using FreeRadius to Authorize Oracle Connections

Introduction This article will show how to configure the FreeRadius RADIUS server for use in authorizing Oracle ...

Trace on Standby: Tracing MRP Process

Sounds simple, right? And it really is, although it might not seem obvious. Recently, I ran into an issue when trying ...

While Upgrading from GI 12c to 19c, +asm1(19c) Cannot Detect +asm2(12c)

A few weeks ago, I was working on a GI upgrade from 12.2 to 19.6. After running ...

A few weeks ago, I was working on a GI upgrade from 12.2 to 19.6. After running the upgrade on Node 1, an issue ...

Automating Oracle Startup/ Shutdown on Linux (Non-Restart)

We have all set up automatic startup and shutdown of an Oracle Database on Linux at some point. I, myself, have made ...

19c Auto-Indexing: ORA-65532: Cannot Alter or Drop Automatically Created Indexes

It’s one of those classic "Oracle knows best" moments, isn't it? You try to take back control of your own schema, and ...

How to Read Oracle Traces from SQL*Plus

Situation Let's say you need to read trace files from Amazon Relational Database Service (RDS). How do you do it?

Datapatch Failing on ORA-65108 (PDB$SEED): Applying Datapatch Manually

Problem In a new 12c environment (which actually includes 18c and 19c, as per the 12c family), the datapatch failed on ...

Installing OCI Command Line Utilities in Linux and Windows

As part of a recent project, I installed the Oracle Cloud command line utilities (oci) on the following Linux systems:

Extracting DML Stats/Workload With GoldenGate

Quantifying data movement across the environment After setting up GoldenGate in your environment, you might ask ...

How to Stop All Database Instances Running From ORACLE_HOME

At times, there may be a requirement to stop database instances, for example, to perform patching. When there is only ...

Data Guard Listener Networking

I am currently reviewing an environment to create a third standby database. One of the primary challenges I’ve ...

Automatic Graceful Shutdown and Consistent Startup Method for Oracle DB on Linux

Having questions about automatic startup and shutdown is quite common when dealing with new environments or ...

AWS RDS: 5 Must-Know Actions for Oracle DBAs

Managing Oracle on AWS has some twists. Here are five daily DBA activities that have changed on AWS:

IPv6 Formatting for JDBC and SQLPlus

Does IPv6 formatting for JDBC and SQLPlus seem new to you well, it's been available since 11gR2. You're familiar with ...

Let DataGuard Broker Do ALL The Work

Why bother implementing the Oracle Data Guard Broker? The short answer is that it handles the heavy lifting of ...

How to Quickly Ignore ORA Error on Agent Layer

I had a very specific situation where I wanted to ignore an error from a specific agent. It turns out that it is easier ...