This category includes most popular database technologies used almost everywhere to store the data.
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
In this Tutorial, I will take you through the steps to create a database in Oracle DB 12c. Oracle 12c has many new features over older versions of database like full database Caching, in-memory aggregation, attribute clustering, json support etc. You can refer Oracle 12c features to know about all such features. Every database has ... Read more
In this article, I will take you through the steps to install Oracle Database 12c. Oracle database is the most widely used database across the world due to its multiple features capability. Some of its features are:- a)Cluster Creation: Provides Real Application Cluster(RAC) Performance. b)Performance and Scalability: Provides LOB(Large Object) Performance. c)Database Security: Uses standard ... Read more