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

  From the Security tab, right-click on Logins and click on new login. In the window that opens, we give a name to Login from …

  Below is the simple script for monitoring mysql error logs. You can set the cron jobs as per your need(eg. daily,hourly) [crayon-684bffc9e17b8447086910/] Hope this …

  Teradata 15.0 has come up with many new exciting features and enhanced capabilities  . Teradata Query Grid is one of them. Teradata database now able …

  Logical replication was introduced in PostgreSQL 10 and it is different from streaming replication in many ways as described below:  Logical replication works at …

  In the era of digitization, information availability online has witnessed an exponential surge. The internet is brimming with textual content—be it emails, web pages, …

Error: [crayon-684bffc9e58a6318603778/] 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 …