Database Tutorials MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux

Error: [crayon-6780d99c344c2417106495/] Environment variable ORACLE_UNQNAME not defined. Please set ORACLE_UNQNAME to database unique name. Solution: It should be set as follows. ORACLE_UNQN average = XXXX …

  If you want to make a change in more than one session database at the same time, the control to prevent sessions from adversely …

HADOOP MULTI NODE INSTALLATION PROCESS [ Note: I am creating multi node in most easiest way by creating and using everything in root mode on …

  You can get the below error when you run the ADDR AWR report in the Oracle Standard edition database. “ORA-13716: Diagnostic Package License is …

  Lock Compatibility provides the necessary control when multiple transactions have the same lock request (row, page). If the resource is previously locked by a …

  Some time we are facing issue like we forgot the MySQL root password. So here we are providing just some simple steps to reset …

  SQL Server implements different types of locks that determine how concurrent query requests access the data. For example, imagine that one user wants to …

Problem: If a disk previously included in an ASM disk group is attempted to be used for another disk group, it will fail with the …

  Adding Space to Sybase IQ server Little background about IQ space. In IQ 15.0 Dbspace != dbfile Under one dbspace we can have many dbfiles …

  Master-Master Replication setup Replication makes data highly available for applications and websites, master-master replication is an active-active cluster kind of solution which can be …