When we change the parameters in the RAC systems, I always recommend to specify the SID clause clearly, which means you know which or all instances will be modified. If you ignore it, the result will ...

Last night my friend called me to check the network service issue after she added two SCAN IPs to one RAC system. She added these two IPs to resolve load balance issue as the customer found the connec...

In last month, one engineer of our customers made a mistake and changed the file permissions of the whole RAC database wrongly, including GI and DB home. Of course the clusterware could not be started...

In last week, I installed an Oracle RAC on openSUSE 15.2 and got some issues. Although the installation was successful finally, it still took me much more time than the same thing on RHEL. I list them...

First of all, I do not recommend to install Oracle 11gR2 on RHEL8, especially in the production environments. While if you have to do such installation for test or data migration, then you could refer...

Suddenly our support guys found some archivelog backups were not deleted even they were not needed by the backup policy ( recover window of 7 days). At the beginning I thought maybe it was a similar i...

Sometimes we will keep the database backup for one week and set the retention policy to 'recovery window of 7 days'. So we will only keep the database backup for 7 days, right? In fact, it depends. If...

Today one customer said the data sync of Oracle Dataguard had issue and our guys checked the alert log then sent below errors to me: ORA-01034: ORACLE not available ORA-27102: out of memory Linux-x86_...

These days my friend Zhiguo discussed with me about the vote disk issue of Normal Redundancy ASM disk group and I found maybe I made a big mistake. Nowadays more and more customers install two SSD dis...

Several weeks ago I patched a 12.2 Oracle RAC and got several issues, I realized there were some key points I should follow during the RAC patching and list them here. 1. When patching the whole syste...