How to fix “DROPPED” griddisk in Cell

You may encounter a situation where a grid disk is in a dropped status in oracle exadata cell storage. This issue can be identified using the following command: Additionally, the ASM alert log may show errors like: This error indicates that the grid disks do not have the same size, which is causing issues inContinue reading “How to fix “DROPPED” griddisk in Cell”

Benefits of Zstandard Compression in Oracle 23ai HCC

In Oracle Database 23ai, significant improvements have been made to Hybrid Columnar Compression (HCC), with the default compression method now utilizing Zstandard (Zstd) instead of the previous algorithms, zlib and bzip2. But what exactly is Zstandard, and how does it differ from zlib and bzip2? Zstandard is a lossless data compression algorithm developed by YannContinue reading “Benefits of Zstandard Compression in Oracle 23ai HCC”

What should we do if the Flash Cache is degraded in an Exadata cell

Flash cache plays a critical role in Exadata performance. When issues arise, it’s crucial to understand the symptoms and resolution steps. Typically, each flash cache comprises four flash disks. If one flash disk fails, the cell service automatically removes it while continuing to operate with the remaining three disks. In most cases, immediate intervention isContinue reading “What should we do if the Flash Cache is degraded in an Exadata cell”

ZDLRA ERROR: Filesystem label ESP is found more than once.

Recently, while patching a ZDLRA X7-2 full stack to version 21.1.202405, I encountered an error during the dbnode precheck. This blog post details the issue and its resolution. The Error During the precheck, the following error was encountered: 2024-09-17 15:13:11 +0200 :ERROR : dbnodeupdate.sh precheck failed on one or more nodes SUMMARY OF WARNINGS ANDContinue reading “ZDLRA ERROR: Filesystem label ESP is found more than once.”