Database Tutorials MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux 
When you try to import the export from a database on Exadata to a database that is not on Exadata storage, Pillar Axiom storage …
Read More »ORACLE
ORA-08104 error received during index rebuild process
During the process of an online index rebuild operation, when the related session is unexpectedly interrupted, even though there is no rebuild process, it …
Read More »Hybrid Columnar Compression
Hybrid Columnar Compression (HCC) introduced with Oracle Database 11g Release 2. HCC is a feature that can be used with Exadata storage, Pillar Axiom …
Read More »Learn the Cause of the Error and View the Suggestions with the OERR Utility
We can display the cause of an error that we received and troubleshooting suggestions, with the OERR Utility. It is located under the $ORACLE_HOME/bin directory. …
Read More »ORA-15064 ORA-03133 ASMB terminating
The database instances can be closed with an “ASMB terminating” error due to a bug. The error codes are ORA-15064 and ORA-03113. Possible errors …
Read More »waiting for snapshot control file enqueue
Rman creates a control file snapshot file or a consistent control file image in the control file backups. While a rman process taking a …
Read More »How to Find Locks on Library Cache Objects
We can see the locks on Library cache objects in V$ACCESS (GV$ACCESS on RAC systems). The dependency on objects is managed by library locks. …
Read More »How To Change the Cluster interconnect and public interface in RAC databases
In RAC databases, serious cluster wait events are seen, usually due to the low speed of interconnect interfaces. Therefore, after the installation, faster hardware interfaces …
Read More »ORA-00313: open failed for members of log group Error on Standby Database
ORA-00313 error can be received depending on any problem in redo log files in standby database. The possible error message will be as follows. …
Read More »How To Set Password Policy in Oracle
The password of Oracle database users is usually set to the same as the user name. Or passwords are set very simply. That means …
Read More »