Error: When the database is upgraded to version 10.2.0.4 or 10.2.0.5, the Enterprise Manager configuration ends with an error and fails to start manually. Reason: …
Read More »Set Up AlwaysOn Basic Availability Groups in SQL Server 2016 in Standard Edition OR SQL Server Mirroring in SQL Server 2016 in Standard Edition .
For Always on Perrequisite Refer Document Prerequisite For AlwaysOn Basic Availability Groups in SQL Server 2016 in Standard Edition OR SQL Server Mirroring in …
Read More »How To Get Script of Some Objects in the Database On SQL Server(Generate Script Method)
We explained how to get the create script of all objects belonging to the database in the article titled “How To Get Script of …
Read More »How To Find Partitioned Tables In The Database On SQL Server
I mentioned that we can not get the script of the partitioned tables by right clicking on the SSMS and using the Script To …
Read More »Concurrent MySQL client
CCQL: CCQL is a tool that allow user to connect multiple mysql server node Concurrently at the same time. It comes into picture when a …
Read More »Creating New Replica Set Configuration
Replica set configuration on ‘n’ node Replica: We generally have 3 nodes replica set with 1 Primary and 2 secondaries. Below are the steps we will need to …
Read More »MongoDB Version 3.6 Upgrade Process
Important Note : Following features are deprecated in 3.6 ‘rest = true’ and ‘httpinterface = true’ these options need to be commented in mongod.conf . …
Read More »RMAN : PLS-00201: identifier ‘DBMS_BACKUP_RESTORE.SET_CHARSET’ must be declared
Error: When connecting to rman, “PLS-00201: identifier ‘DBMS_BACKUP_RESTORE.SET_CHARSET’ must be declared” error and connection could not be established. Reason: Problematic DBMS_BACKUP_RESTORE package or invalid sys …
Read More »How To Create Partition On SQL Server
Partition is the process of dividing tables and indexes into parts. For example, I have a table with a size of 1 TB. And …
Read More »Teradata – Architecture
Teradata architecture is based on Massively Parallel Processing (MPP) architecture. The major components of Teradata are Parsing Engine, BYNET and Access Module Processors (AMPs). …
Read More »