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

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

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

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

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

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