Oracle – Database & Cloud

Could I ignore the SID clause in command ‘alter system’?

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...

26/08/2021Oracle179 viewsComments

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...

04/07/2021Oracle1,081 viewsComments

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...

10/11/2020Oracle4,421 viewsComments

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...

17/08/2020Oracle297 viewsComments

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...

09/07/2020Oracle2,693 viewsComments

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...

30/11/2019Oracle128 viewsComments

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....

05/10/2019Oracle170 viewsComments

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...

23/07/2019Oracle1,485 viewsComments

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 ...

11/07/2019Oracle165 viewsComments

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...

16/06/2019Oracle112 viewsComments

Register

Login

Retrieve password