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

After several days I finally learned that the Flex ASM could just worked in a cluster.When I first got this feature, I tried to build two servers, one is DB server, and another is ASM server, and wa...

In our daily work, one popular question is how to keep our session alive, especially for Oracle session.I know there is a parameter named sqlnet.expire_time in the sqlnet.ora for such function in ...

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

Today our guy got a PLS-00201 error during the schema-level expdp task, and I searched the Oracle Support website but could not find extract answer, then found a similar webpage through Baidu. http:/...

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

These days I was testing some commands of the system parameters and the PFILE/SPFILE, and unfortunately, I encountered a really bad bug in my test environment.My RAC DB is 12.1.0.2.0, and I did be...