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

  Total Time to perform Activity is:  2hr The following are the high level Steps from DB side: Step 1: Disable Auto-Failover Remove node which …

  Before you read this article, you need to know what the concept of partition is and how can we create partition for  a table. …

  To deploy Cloudera Manager and CDH on an Google Compute VM instance, begin by creating an environment. The environment defines common settings, like region …

  1:- Enable oplog using –master option while starting mongod service [Version 3.2]. And later version (3.2 +) need to put replSetName=rs0 into the mongo.conf file in …

  As a high-level security measure in SQL Server, if you do not want application developers to know the application’s user password, this article will …

  You can download the MySQL binary files from below link. https://downloads.mysql.com/archives/get/file/mysql-5.7.21-el7-x86_64.tar.gz 1:- Add OS group [crayon-673fb96060e75772414036/]   2:- Add OS user [crayon-673fb96060e78160465403/]   3:- …

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 …