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

ERROR: In Oracle 11g r2 database rman crashes during exit and gives error like DBGMISC: ENTERED crmkmrsr. REASON: Inconsistency in NLS settings. (This is specified …

  If all the indexes in the partition table are not aligned according to the partition, you will get an error like the following during …

  Introduction A service broker is a high availibity technique in SQL Server which was introduced from SQL Server 2005. This is primarily to send …

Error: When trying to connect with rman “ORA-01008: not all variables bound” error is occured. Reason: Bug 10306699 Solution: You need to set the cursor_sharing …

  I explained how to create a partition int the article named “How To Create Partition On SQL Server“. In this article I will share …

  During a typical revision of mongod’s logs, we could find slow queries, by default, those queries that take more >100ms. You can change this time …

Error : When we logged in to EM, there was an error “java.lang.Exception: Exception in sending Request :: null” and the page was not displayed …

  We can not take the backup of the database and transfer it to the test environment for security reasons. Because the actual data should …

  Every table must have at least one column as the Primary Index. The Primary Index is defined when the table is created.There are two reasons you …

  1)How to Calculate Memory Usage and Disk Space Usage? There are 2 stored procs which help you to calculate the memory size and database …