Shared SPFILE is recommended strongly in RAC environment, and I want to tell you the reason in this post.The test environment is Oracle 12c 12.1.0.2, and the installed PSU is 21948354.
SQL> se...
I tried to find a perfect SQL format tool for a long long time, while all the attempts failed until I found this one: SQL Pretty Printer.The online edition is here. It has many options and I think...
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 got this issue and wanted to know the reason, so I built a test VM to verify it.The dbss scirpt was used to start their instances and he found if he run 'dbss start' then he could get th...
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 ...
In last week I upgraded my laptop from T420s to E485 to get maximum 32G memory also because the T420s was so old and the cooling system worked inefficiently, so during the summer it would become slowe...
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....
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...
Suddenly our support guys found some archivelog backups were not deleted even they were not needed by the backup policy ( recover window of 7 days).At the beginning I thought maybe it was a simila...
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%, ...