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 ...

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 ...

OEM 13c Monitoring Features – Part 3, Reports Based on Metric Data

This is the third in a series of blog posts covering the most important topics you should know to completely monitor ...

Solving an unusual Oracle upgrade issue

Background I recently came across a very unusual situation. During an upgraded review, I noticed the ...

OEM 13c Monitoring Features - Part 2, Extended Metrics

This is the second in a series of blog posts covering the most important topics you should know to completely monitor ...

OEM 13c Monitoring Features - Part 4, Corrective Actions

This is the fourth 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 ...

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 ...

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?

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's Top 5 Commands: ALTER SYSTEM and Managing SYS Objects in RDS

Essential administrative commands for Amazon RDS for Oracle Navigating administrative limitations in RDS We often ...

How to Test Data Guard Fast-Start Failover by Shutting Down Standby Server

This post will demonstrate the procedure for testing Oracle Data Guard Fast-Start Failover by shutting down the server ...

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 fix dbupgrade script issue when upgrading Oracle Database Standard Edition

Objective: Upgrade Oracle database from 11.2.0.4 to 12.2.0.1

How to Test Data Guard Fast-Start Failover by Shutting Down Primary Server

This post will demonstrate the procedure to test Oracle Data Guard Fast-Start Failover by shutting down the server ...

How to Set Up Out Of Band Notifications in OEM 13C

So, after an abnormally quiet weekend, I was being paged: Oracle Management Services (OMS) was down! Well, this ...

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 ...