I never thought mounting a shared filesystem maybe cause server reboot! One node in a three-node RAC database was rebooted without any reason, and I was contacted to find the possible reason. I checke...

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

Such issues happen rarely, while sometimes we have to do such things. If you can access the Oracle Support website, please read below notes: How to Apply a Grid Infrastructure Patch Before root script...

My friend told me his team installed Oracle 11.2.0.4 on a new SLES12 system while could not create the database, even could not use the sqlplus. SLES is also a famous Linux distribution, so I thought ...

Several days ago I got this error when I wanted to start a Listener: TNSLSNR for Linux: Version 11.2.0.4.0 - Production System parameter file is /u01/app/oracle/product/11.2.0/network/admin/listener.o...

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

These days I needed to export some tables to CSV files, and usually I could finish such task using SQLcl, but this time the table is too big (more than 120G) so although I still could export it with S...

On the day before last day, my client told me the resource of EC2 instance had been increased, so I decided to increase memory setting for Oracle instance. The total memory was 4G, so I changed the me...

On the day before last day, I helped my friend to handle an Oracle block corruption issue of her SAP system. From the alert log file, I found many error messages of corrupted blocks, and I tried to sc...

Last day I took a task to fix a network issue about Oracle 12c on Windows. At the beginning, I though it was a misconfiguration issue, and could be fixed within one hour, or in some special situations...