Skip to Main Content

Breadcrumb

Question and Answer

Connor McDonald

Thanks for the question, steve.

Asked: May 15, 2025 - 3:59 pm UTC

Last updated: May 23, 2025 - 8:05 am UTC

Version: 24.1

Viewed 1000+ times

You Asked

I"m looking for guidelines on how to architect a
new APEX solution for migrating legacy
Oracle reports to APEX.

We have 67 seperate municipal government entities
in 67 seperate Oracle instances. Some are 12c some
are 19c. They are spread across 4 servers.
Table structures are identical across all 67
instances.

Do we need to install APEX in all 67 instances?
How would we configure ORDS?



Can anyone point me to any whitepapers and/or
use cases for how to architect the best
APEX framework for this ?

and Connor said...

APEX does not span instances by default, so a "normal" installation would be 1 APEX per database instance. I've seen customers use database links and/or REST services to let an APEX instance access other databases, but it sounds to me like these 67 government would be expecting some isolation between them, ie, they are standalone entities.

However, given you have 4 servers have you given some thought to perhaps running pluggable databases instead of full blown instances? Even if you didn't want to cough up a multitenant license, you can have up to 3 free pluggables, which might get from 67 instances to (say) 25.

Pluggable then gives you some more APEX options because it can be at the CDB level or each pluggable.

When it comes to ORDS, you have plenty of flexibility because a single ORDS can manage multiple databases. So assuming you have "n" application servers, a common setup would an ORDS instance per server, each handling multiple databases. See chapter 3 "Configuring Oracle REST Data Services for Multiple Databases" in https://docs.oracle.com/en/database/oracle/oracle-rest-data-services/25.1/ordig/oracle-rest-data-services-installation-and-configuration-guide.pdf

Hoever, some times its business demands that drive the ORDS architecture. If ORDS is serving more then 1 municipality, then things like patching/upgrade/etc require coordination between them. Only you can know if that is workable. If each municipality expects total independence, then they'd naturally expect their own ORDS instance

Rating

  (1 rating)

Comments

thanks

A reader, May 19, 2025 - 12:27 pm UTC

Hi Connor,

thanks for your reply. it gives us a starting point.

steveb
Connor McDonald
May 23, 2025 - 8:05 am UTC

Hope it was useful.

More to Explore

Multitenant

Need more information on Multitenant? Check out the Multitenant docs for the Oracle Database