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

SQL Server 2017 and SQL Server 2019 can run on Linux operating system, and SQL Server Always On Availability Groups can be Setup without the …

In today’s article, we will connect to postgresql and use the Postgres user and the psql command while doing this. We need to switch to …

We get the error ORA-01438 when data larger than the specified length is entered into the table. Error Received: ORA-01438: value larger than specified precision …

After installing Data Guard, we may need to make some adjustments for it to work effectively. For example, Let’s assume that we have a network …

While doing a test on weblogic today, I encountered the BEA-090892 error. The error comes when the services are restarting in the cluster structure. The …

There are actually several ways to control disk latency in SQL Server. But in this article, I will be explaining the most frequently used DMV …

ORA-01422: exact fetch returns more than requested number of rows error when SELECT INTO statement returns more than one value. Error Received: ORA-01422: exact fetch …

In today’s article, we will start the PostgreSQL Cluster with the Pg_ctl command. What is the pg_ctl command? PG_CTL is the command required to start, …

In today’s article, I will talk about how we can perform failover using DGMGRL. If we cannot reach the primary database, we connect to the …

The database upgrade stages with almost zero interruption from the current Data Guard configuration Single Node Primary and Physical Standby are as follows. 1. We …