Glenn Hill
Member
Has anyone tried configuring E1 using SQL Server Always On Availability Groups (AOAG)?
The official line from Oracle is that it is not supported yet – because they have not tested it. (It was only released five years ago!)
But we cannot see why it should not work.
Perhaps we would have to avoid configuring a listener (although it would be nice if it worked) – but we can see no reason why the standard “database mirroring” and manual failover functionality within AOAG would not work; the CNC configuration and JDE middleware would surely be unaware that AOAG was configured beneath the covers?
(We are currently in the design process of a new installation of E1 9.2 on either SQL 2014 or SQL 2016 – and AOAG offers by far the best options for HA, DR and real-time reporting.)
The official line from Oracle is that it is not supported yet – because they have not tested it. (It was only released five years ago!)
But we cannot see why it should not work.
Perhaps we would have to avoid configuring a listener (although it would be nice if it worked) – but we can see no reason why the standard “database mirroring” and manual failover functionality within AOAG would not work; the CNC configuration and JDE middleware would surely be unaware that AOAG was configured beneath the covers?
(We are currently in the design process of a new installation of E1 9.2 on either SQL 2014 or SQL 2016 – and AOAG offers by far the best options for HA, DR and real-time reporting.)