Michael Dinh

Why It's Good Practice to Run Datapatch -prereq after Creating Database

Starting with Oracle 12c, running datapatch may be required after creating a database, depending on the version and the ...

Using MDBUtil To Create Grid Infrastructure Management Repository Database

Whether Grid Infrastructure Management Repository (GIMR) database MGMTDB is required or not depends on the version of ...

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

Testing the 19c Grid Infrastructure by Performing a Dry-Run Upgrade

Testing oracle grid infrastructure upgrades Editor’s Note: Because our bloggers have lots of useful tips, every now and ...

Conventions Make for Easy Automation

How to Find Clusterware Configuration Details Using srvctl

At times, you may be required to gather information about Oracle Clusterware configuration details. Instead of running ...

How to use createGoldImage For Cloning in 19c

According to the Oracle Database Upgrade Guide, the traditional clone.pl script has been officially deprecated. The ...

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

How To Fix ASM Disk Header Status from "FORMER" To "MEMBER"

I made an error when creating an Oracle ASM disk group which resulted in not being able to drop or mount the disk group ...

Caution: Using AutoUpgrade with Multiple Databases from the Same ORACLE_HOME

Here's a short and sweet post. "In Deploy mode, AutoUpgrade also confirms that the upgrade has succeeded, and moves ...

How To Downgrade Grid 19c Clusterware to 12.1

There may be many reasons for downgrading from Grid 19c to 12.1; however, the reason I am downgrading is to rerun a ...

CreateGoldImage Followup - Is CreateGoldImage Required for Cloning Oracle Home?

Comparing CreateGoldImage and Traditional Tar Cloning On October 31, 2019, I blogged about How To Use CreateGoldImage ...

Data Guard Listener Networking

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

How To Reclaim ASM Disks

The project I have been working on is migrating GoldenGate trails from DBFS and ACFS. Now that the migration has ...

How reliable is autoupgrade.jar analyze mode?

It sounds like you hit one of those classic Oracle "gotchas" where the tool tells you everything is fine until the ...

Create 19c Database in Archive Mode Using DBCA Silent

I wanted to export 11.2 database schema and import it into a 19c database; creating the database in archive mode to ...

How To Resolve Database Software Install To Incorrect Location

We were recently required to install database software to /u01/app/oracle/12.2/db1. However, when using GUI to install ...

Management and Troubleshooting Features: Data Guard Command-Line Interface (DGMGRL) 19c

With Oracle Data Guard promising high availability, data protection and disaster recovery for enterprise data, it's ...

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

Do Not Mix Different Patch Types

I was preparing to apply a July 2019 path for a single instance database without ASM. Here are the available patch ...

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 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 Clean up Trace and Audit Files for Multiple Homes

I’ve been working on a simple method to clean up audit and trace files for multiple homes. Identifying Grid and ...

Using ADRCI to Review Recurrent Issues

Managing diagnostic data across multiple systems with ADRCI Reviewing recurrent issues for database systems is ...

How To Easily Purge Logs for GI and DB

Simplifying log management with purgeLogs With a total of 33 directories for GI (Grid Infrastructure) and DB (database) ...

How to Use EM CLI to Verify Data Guard Configurations

EM CLI (Enterprise Manager Command Line Interface) allows users to access Enterprise Manager functionality from the ...

Detect and Notify Linux Server Restart

When Oracle support performs maintenance for Exadata Cloud, communication can sometimes be a bit sparse. Typically, ...

How To Rename Interval Partition with More Meaningful Name

Renaming oracle interval partitions for better readability When using interval partitioning, the database automatically ...

How to Execute 19c runcluvfy.sh With Root and Sudo Method

Editor’s Note: Because our bloggers have lots of useful tips, every now and then we bring forward a popular post from ...