Database Tutorials MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux 
Users’ passwords are valid for the duration of PASSWORD_LIFE_TIME in their profile. At the end of this period the password expires and must be …
Read More »ORACLE
How To Move OCR and Vote Disks to Different ASM Disk Groups
Generally, for the Oracle Cluster Registry and Vote Disks, the disk group where the database files are stored is used in RAC Systems. The …
Read More »ORA-12012: error on auto execute of job “SYS”.”BSLN_MAINTAIN_STATS_JOB”
When the BSLN_MAINTAIN_STATS_JOB job ends with ORA-12012: error on auto execute of job “SYS”.”BSLN_MAINTAIN_STATS_JOB” and “ORA-06502: PL/SQL: numeric or value error” errors, the baseline …
Read More »How To Check if Oracle instance was started with pfile or spfile
We can learn the parameter file in which the database is opened by querying the spfile and pfile parameter value. If both the spfile and …
Read More »ORA-64307: Exadata Hybrid Columnar Compression is not supported for tablespaces on this storage type
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 »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 »