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

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 …

In today’s article, we will solve the problem of preventing our java application server from asking us for a password again and again with the …

In this article, I will be answering the question of how you can migrate an existing database backup to Arc Managed Instance. You will be …