Author: Michael Dinh

Detect and Notify Linux Server Restart

When Oracle support performs maintenance for Exadata Cloud there is minimal communication. Typically, Oracle support restarts the host during maintenance. Since the application is not RAC aware, the application team needs a way of knowing they have to restart the…

Read More >

Using Sed For Search and Replace

I recently had a requirement to change the email for all shell scripts from personal (me@gmail.com) to a DBA list (dba@gmail.com). Typically, directories for shell scripts are scheduled using crontab. If shell scripts aren’t scheduled with crontab, then we’d need…

Read More >

How To Easily Purge Logs for GI and DB

With a total of 33 directories for GI (Grid Infrastructure) and DB (database) homes, what’s the easiest method to remove files older than 90 days for all directories? Luckily, Oracle Support does offer purgeLogs; a one-button automation script, which can…

Read More >

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 the past. We originally published today’s post on September 9, 2019. One method to prepare for a Grid Infrastructure…

Read More >

Using ADRCI to Review Recurrent Issues

Reviewing recurrent issues for database systems is generally a monthly task. If there were only one system and one database, it would be a simple exercise, however, there are many systems and many databases per system. This is where ADRCI…

Read More >

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

Editor’s Note: Because our bloggers have lots of useful tips, every now and then we update and bring forward a popular post from the past. We originally published today’s post on August 14, 2019. In reviewing the Grid Infrastructure Installation…

Read More >

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 create a backup of all transactions and allow recovery to any point in time. Since the 19c database did…

Read More >

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 useful to understand the Data Guard command-line interface (DGMGRL) which enables you to control and monitor a Data Guard configuration from the DGMGRL prompt…

Read More >

CreateGoldImage Followup – Is CreateGoldImage Required for Cloning Oracle Home?

On October 31, 2019, I blogged about How To Use CreateGoldImage For Cloning In 19c. CreateGoldImage seems like a nice new feature; however, it’s also very buggy. Here are a few bugs: 2641469.1 27432355.8 27432338.8 I received a suggestion to use tar…

Read More >

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 database files such as sqlnet.ora, tnsnames.ora, and listener.ora from the source home to the target home. After these actions are complete,…

Read More >
Page 1 of 812345...Last Page »