This category includes most popular database technologies used almost everywhere to store the data.
In this article, we will see how to manually remove liquibase lock from database using few simple steps. liquibase is a free and open source database version control tool which keeps track of all database modifications and allow us to undo a change just like git tool in case we would like to rollback from ... Read more
In this article, we will see how to query data from MongoDB using IntelliShell in Studio 3T Free Version. This article focuses more on capability which users are having to query data from MongoDB in sql format but as soon as user either switches to free version from Pro or Ultimate editions or trial version ... Read more
In this article, we will see how to solve "ORA-12154: TNS:could not resolve the connect identifier specified" in case you are also facing the same error. The ORA-12154 error, "TNS:could not resolve the connect identifier specified," is a common error encountered in Oracle Database environments. This error occurs when a client application is unable to ... Read more
The ORA-12203 error in Oracle Database is typically associated with an inability to connect to the database, with the full error message usually being "ORA-12203: TNS:unable to connect to destination." This error indicates that the client is unable to establish a connection to the Oracle server through Oracle Net Services (formerly known as SQL*Net). This ... Read more
The Oracle Database error ORA-12163 typically indicates a problem with the network connection, often related to the Oracle Net Services configuration. The full error message is usually "ORA-12163: TNS:connect descriptor is too long," which suggests an issue with the TNS (Transparent Network Substrate) connect descriptor used in the connection string. A connect descriptor provides the ... Read more
In this article, we will see how to solve "pg_restore: error: input file appears to be a text format dump. Please use psql". As you might be aware that pg_dump and pg_restore are the most widely used utilities to backup and restore PostgreSQL databases. So it is not very uncommon to face an error like ... Read more
Do you want to know the steps to Backup and Restore MariaDB Database on RHEL/CentOS 7/8 ? If yes, then you have come to the right place. If you are using MariaDB Database in your Organization then it is very important for you to understand how to take backup and restore mariadb data. There are ... Read more
Are you looking for the Steps to Reset MariaDB root password on RHEL/CentOS 7/8 ? Have you forgotten the MariaDB root password ? If you are looking for the answer to these questions then you came to the right place. There is always a possibility that one can forget the root password which will further ... Read more
In this article, I will take you through 6 Simple and Easy Steps to Install MariaDB Server on Linux(RHEL/CentOS 7/8). MariaDB is an open source MySQL based relational database management system. It is probably the most popular database currently in use on Linux Based Platforms due to its various features over other databases. It offers ... Read more
In this article, I will take you through the steps to Set MariaDB root password in Linux using mysql_secure_installation tool. If you are familiar with MySQL DB in Linux then you must be aware that MariaDB has now replaced MySQL DB in Latest RHEL/CentOS Based Systems. After installing MariaDB in your server you might wonder ... Read more