I am working with AWS RDS Oracle 19 and have two EC2 instances running Oracle Linux 8.10 with Java 11.0.24, ORDS 24.2, APEX 23.1, and Tomcat 9.0.91, both behind a load balancer.
However, after updating the entire environment (from Apex 21, ORDS 18, Tomcat 7..), I am facing issues because whenever I configure ORDS and APEX to work with instance one, the configuration of the other instance gets corrupted. If I fix the configuration for instance two, the connection for instance one breaks.
I have manually set the ords_public_user password in the pool.xml file, generated the ORDS script from one instance, and executed it on the other and on both. However, the problem persists: when one instance works, the connection of the other fails.
I would like to know if there are any considerations with the current versions to maintain a high availability environment.
Thanks