Oracle – Page 2 – Database & Cloud

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/2019Oracle134 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,744 viewsComments

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/2021Oracle275 viewsComments

One ORA-12520 issue in Oracle RAC

Several days ago I helped to fix one ORA-12520 issue in RAC database, and from this issue I learned that special care should be taken when the listener.ora is modified in RAC database.The issue wa...

28/01/2018Oracle1,557 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,554 viewsComments

NFS Lock issue in NetApp NAS Server

On Jan 16, one Linux server crashed and the Oracle database could not be opened after server reboot, the prompt was the file was used by other process. It was surprising as we had restarted the serve...

24/01/20152,962 viewsComments

ORA-01180: can not create datafile 1

Last night I prepared one restore guide for a friend, and I found when I restored the full database, I always got below error: creating datafile file number=1 name=+DATA/ORATEST/datafile/system01.dbf...

07/05/2017Oracle2,461 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/2019Oracle233 viewsComments

Got Oracle 12c RAC Expert certificate

I almost cannot believe I passed the 1Z0-068 test!I failed on July 5 as the passing score for RAC part was 66%, while these days I got a email and found the passing score has been lowered to 60%, ...

16/09/2016Oracle123 viewsComments

Pass the 1Z0-060 today

Today I took the 1Z0-060 test and passed it finally.I did feel great pressure before the test, as I still had so many things to learn until last night. I spent the whole last night to confirm some...

18/01/2016Oracle85 viewsComments

Register

Login

Retrieve password