One of my application is currently running on unsupported HW & Oracle version (Solaris 9 & Oracle 10g) with ADG between primary & DR and as part of platform uplift plan is to move to private enterprise cloud (OEL 6/7 with Oracle 12c). Management ask here is to replace ADG with OGG primarily to ensure no downtime and not looking for any load balance at DB level with active-active setup.
This application is completely sitting in the DB including presentation layer (in mod_plsql which is getting hosted with the help of OHS) and business logic in the form of oracle jobs (pl/sql code). Query here is would OGG suite for this kind of an application where OGG will ensure data sync up between both nodes and at the same time it will ensure business logic & presentation layer logic should not run both DBs at same time.
Thanks
Capri72
Oracle GoldenGate can do active/active (bi-directional) with no issues. From reading your description, the problem you will have is with the embedded PL/SQL and MOD_PLSQL.
Oracle GoldenGate 12.3 (12.3.0.1.x) introduced Procedural Replication. Procedural Replication will replicate executed stored procedures and packages stored within the Oracle Database; however, this functionally is limited to the procedures and packages within the SYS schema. User defined procedures and packages cannot be replicated at this time.
If you want to see what SYS Procedures and Packages are supported, you can find them quickly here:
https://dbasolved.com/2017/10/26/procedural-replication-support-2017/