ORACLE

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, 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 …

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 …

While pulling data from services on Oracle Forms & Reports, I got an error with the message “REP-52266: The in-process Reports Server failed to start”. …

In today’s article, I will tell you how to Active Oracle DataGuard Broker. If you have not installed Data Guard before, you can install it …

Oracle recommends a daily incremental backup strategy. In this backup strategy; Day 1: Full backup is taken. Day 2: Incremental backup is taken. (Incremental Level …

I did an Oracle Linux installation. I started getting an error when I tried to connect with putty in a way I didn’t understand. Error: …

In today’s article we will talk about the PING[ARC1]: Heartbeat failed to connect to standby ‘teststby’. Error is 16057. Error: PING[ARC1]: Heartbeat failed to connect …