SWITCHOVER TO

How to Resolve ORA-01017: invalid username/password; logon denied

by Ed Chen
January 18, 2020March 2, 2023
4 Comments

ORA-01017 ORA-01017 means that you either provided an incorrect pair of username and password, or mismatched authentication protocol, so the database that you tried to… Read More »

How DGMGRL Switchover to Standby

by Ed Chen
August 28, 2019December 10, 2022

DGMGRL Switchover Suppose that you have configured data guard broker for 19c primary and standby databases, we can test switchover by DGMGRL, an interactive broker… Read More »

How to Resolve ORA-12514: TNS:listener does not currently know of service requested in connect

by Ed Chen
February 14, 2019December 10, 2022
28 Comments

ORA-12514 ORA-12514 means that the listener cannot find any matched service with yours, so it cannot establish the connection with the database for you. As… Read More »