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 wi...
How to recreate the lost ASM password in Oracle Clusterware?
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 con...
How to fix permission issues of Oracle RAC?
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 star...
Some issues during the Oracle RAC installation on openSUSE 15.2
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 t...
Install Oracle 11gR2 on RHEL8
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 re...
Archivelog backups were not removed per backup policy
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 simila...
Talking about ‘recovery window of 7 days’
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....
ORA-27102 out of memory on a system with huge memory
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-x...
Maybe a dangerous configuration of ASM diskgroup with Normal Redundancy
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 ...
Key points for Oracle RAC patching
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 sy...