I am using Oracle EE 126.96.36.199.8 on Solaris 10.
I have been reading that it is possible to do an insert from my Active Data Guard standby database by redirecting the insert to happen on the primary via a DB link. I have GLOBAL_NAMES set to TRUE and it needs to stay this way. This means I cannot create a DB link that points back to my primary as such:
CREATE DATABASE LINK PROD.WORLD USING 'PROD_PRIM';
How can I get around this to be able to insert data into the primary from my ADG standby?
There's a section on it here by Uwe Hesse:
My understanding is if GLOBAL_NAMES is true then the database link must have the same name as the database to which it connects.