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...
Today I failed the test, while I thought it is good for me.I didn't prepare well for the test, and the timeline was too urgent for me. I tried to learn all the things but in fact I almost lost all t...
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 ...
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...
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 ...
To accelerate my reading speed, I bought a translated book of 'Oracle Core - Essential Internals for DBAs and Developers', while I found many times I had to read the original English version to know s...
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%, ...
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...
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...
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...