Database Tutorials MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux 
This error can be received from databases in Oracle 12.2 and later. This error causes Instance to restart. This is due to bug 27162390. The …
Read More »
ORACLE
ORA-00600: internal error code, arguments: [kdza_check_eq not in dictionary]
This error can be received when the HCC tables are queried or processed on databases in Oracle database 11.2.0.3 and above. It is seen because …
Read More »
Failed voting file relocation on diskgroup DBFS_DG
If access to cellnodes with voting files is not available, relocation errors can be received as follows, even if access is possible later. This error …
Read More »
How To Find Oracle Database Memory Usage(SGA and PGA)
The following query can be used to determine the memory usage rates in Oracle databases. If there is an increase in the memory values from …
Read More »
How To Find Current Open Cursors in Oracle
In Oracle, you can find the open cursors with the following query. The following error occurs when the number of open cursors reaches the open_cursors …
Read More »
How To Find Last Refresh Time of Materialized Views
The following queries can be used to determine when materialized views were last refreshed. For all times: [crayon-6742a51499444132937413/] For a specific time interval: [crayon-6742a51499448558019147/] or …
Read More »
Setting Thresholds for metrics on Exadata Database Servers Using DBMCLI
On Exadata database servers, it is also possible to set thresholds for metrics and send notifications when they reach these threshold values. With DBMCLI, we …
Read More »
Using the DBMCLI Utility
DBMCLI is the command-line management tool used for the Exadata storage server to configure Exadata database servers and manage objects in the server environment. With …
Read More »
CELL-02583: The operation is not permitted on this cell disk
When a new griddisk is created over the celldisk, this error is received in the images before the 11.2.3.2 image version. This error can occur …
Read More »
How To View and Clean Hardware Faults on Exadata db node and cell node using Oracle ILOM cli
Hardware issues that occur in the Exadata db node and cell nodes need to be manually detected and cleaned in some cases. Even in temporary …
Read More »