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 …
Read More »SQL Server Disk Latency
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 …
Read More »ORA-01422: Exact Fetch Returns More Than Requested Number Of Rows
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 …
Read More »Start PostgreSQL Cluster
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, …
Read More »Failover Using DGMGRL
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 …
Read More »Upgrade With Physical Standby
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 …
Read More »Weblogic Boot.Properties Decrypt
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 …
Read More »Migrate Azure SQL Database To Managed Instance
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 …
Read More »PostgreSQL Installation (initdb)
The initdb command is one of the important steps for starting PostgreSQL. Cluster is created when initdb is made, and template, template1 and postgres databases …
Read More »Recovering a Datafile Deleted in Primary with Standby
We can recover a datafile that is corrupted or deleted in the Primary Database, or from a datafile in the Standby Database, which is briefly …
Read More »