To deploy Cloudera Manager and CDH on an Google Compute VM instance, begin by creating an environment. The environment defines common settings, like region …
Read More »Point in time recovery on Mongodb Standalone server.
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 …
Read More »Create Server Login(Do not type a password in web config)
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 …
Read More »How to do MySQL binary installation.
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-684c34c7367f8794513574/] 2:- Add OS user [crayon-684c34c7367fb354591092/] 3:- …
Read More »RMAN DBGMISC: ENTERED krmkmrsr
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 …
Read More »Can Not Switch The Partition On SQL Server
If all the indexes in the partition table are not aligned according to the partition, you will get an error like the following during …
Read More »Service Broker In SQL Server
Introduction A service broker is a high availibity technique in SQL Server which was introduced from SQL Server 2005. This is primarily to send …
Read More »RMAN : ORA-01008: not all variables bound
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 …
Read More »How To See Partition Details In Partitioned Table On SQL Server
I explained how to create a partition int the article named “How To Create Partition On SQL Server“. In this article I will share …
Read More »Slow queries on MongoDB
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 …
Read More »