There is a very handy new command available in Oracle Data Guard Broker 18c. Too bad I discovered it AFTER I solved my problem 😉
This quick blog post demonstrates what can be easily spotted with this new
VALIDATE NETWORK CONFIGURATION command.
In this example, I have 2 sites, each with a 2-node Oracle 18.6 Grid Infrastructure cluster. On both clusters, there is an Oracle 18.6 RAC database.
The primary database on site 1 is called
tool, and the standby database on site 2 is called
opeth. Both RAC databases have 2 instances.
I had trouble setting a correct Oracle Data Guard configuration between database
tool and database