Author: Michael Dinh

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. Let’s see how grid and database homes can be found from oratab. $ sort -u -t : -k 2,2 /etc/oratab | grep -v…

Read More >

How To Rename Interval Partition with More Meaningful Name

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 –…

Read More >

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 >
Page 1 of 812345...Last Page »