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 »ORACLE
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 »SCM0 process Consumes High CPU in 12.2 RAC Databases
The DLM Statistics Collection and Management slave (SCM0) background process is responsible for collecting and managing statistics on global enqueue service (GES) and global cache …
Read More »ORA-39126 ORA-04063 Errors When Running expdp in Oracle 12c
The process is terminated as follows when running expdp in 12C databases. ORA-39126: Worker unexpected fatal error in KUPW$WORKER.FETCH_XML_OBJECTS [ORA-04063: view “SYS.KU$_RADM_FPTM_VIEW” has errors The …
Read More »How To See Compilation Errors in sqlplus
When an object is incorrectly compiled, it is necessary to determine what this error is and to correct the error. You can view this error …
Read More »ORA-39142: incompatible version number 5.1
This error is received when trying to import a Data Pump export of the 12c r2 database to a lower version. The error content is …
Read More »Index Quality in Oracle Databases
Index quality is a factor that directly affects all database performance. The quality of an index is measured by the rate of clustering_factor / num_rows. …
Read More »How To Change AWR Retention and Interval Values
If Tuning and Diagnostic Packs is installed, automatic snapshots can be created with AWR and we can get information about the database performance among the …
Read More »