Month: March 2022

ORA-16766: Redo Apply is stopped

If you see this ORA error "ORA-16766: Redo Apply is stopped" when you check your dataguard configuration in Data Guard command-line interface (DGMGRL) DGMGRL> show configuration; Configuration - DG_PROD Protection Mode: MaxPerformance Databases: PROD1 - Primary database PROD2 - Physical standby database Error: ORA-16766: Redo Apply is stopped Fast-Start Failover: DISABLED Configuration Status: ERROR And … Continue reading ORA-16766: Redo Apply is stopped →

Advertisement

Linux grep a string within a ZIP file containing multiple files — zgrep or zipgrep?

From time to time, you might need to search certain strings within an archive file in the zip format which contains multiple files on a Linux system. If you have never done this, you might ask -- what tools to use? Are there existing commands which can be used instead of writing your own script … Continue reading Linux grep a string within a ZIP file containing multiple files — zgrep or zipgrep? →

Listener — Linux Error: 2: No such file or directory

The other day I was working on a system and noticed an interesting thing -- while the listener was stopped, if I ran "lsnrctl status" and I got the following errors: TNS-12541: TNS:no listener TNS-12560: TNS:protocol adapter error TNS-00511: No listener Linux Error: 2: No such file or directory It said "No listener" was expected, … Continue reading Listener — Linux Error: 2: No such file or directory →

Unhandled datatype (-25) found in kxsbndinf — capturing bind variables

When dealing with a performance issue of a query, it's important to know what bind variables are being used because Oracle's bind variable peeking feature will make the optimizer to choose a different exeuction plan for different bind variables expecially with the adaptive cursor sharing feature introduced in 11g. There are many ways to check … Continue reading Unhandled datatype (-25) found in kxsbndinf — capturing bind variables →