Author: Michael Dinh

I’m currently reviewing an environment that has been upgraded to 19c based on information from oratab. The reason for the review is to remove previously installed versions of the software.     Oracle software is installed to ORACLE_HOME, with variables…

EM CLI (Enterprise Manager Command Line Interface) allows users to access Enterprise Manager functionality from the operating system instead of from a browser. Why would you use EM CLI instead of a browser? It’s more efficient to execute commands from…

I’ve been working on a simple method to clean up audit and trace files for multiple homes. Let’s see how grid and database homes can be found from oratab. $ sort -u -t : -k 2,2 /etc/oratab | grep -v…

When using interval partitioning, the database automatically creates partitions for a specified interval. Unfortunately, the database creates partitions with non-meaningful names, e.g. SYS_P35714. It would be better if the partition was named using some sort of format, e.g. PYYYYMM –…

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…

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

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…

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…

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…

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…