I have an Oracle 12C database with Root Container
CDB$ROOT, Seed Container
PDB$SEEDand 2 PDBs, namely APEX42PDB and APEX50PDB. I have setup 2 versions of APEX, namely V4.2 and V5 in the 2 separate pluggable databases, APEX42PDB and APEX50PDB respectively. I now need to know where to install and configure Oracle REST Data services V 3.0.1 (hopefully they have fixed the URL mapping bug in this version) to be able to service both APEX instances. Do I install it in the ROOT container or in one PDB or both of the PDBs?
Have you installed different versions of Oracle APEX in different PDBs?
For Oracle 12c installation of Oracle APEX in PDB, consider a PDB in which you have installed APEX as one DB instance.
Configure a PDB instance with ORDS while installing ORDS 3.0, and then configure the another PDB using "Add New Database" option for ORDS.
The whole details are given in the earlier thread and following blogs/documentation:
- Re: Help on installing multiple versions of APEX4.2+ and APEX 5.0 in Oracle 12c Multitenant DB
- Single ORDS Install-Multiple Databases
Do I install it in the ROOT container or in one PDB or both of the PDBs?
No, do not install and configure ORDS for ROOT container. Install ORDS 3.0 and while installing configure one PDB and later add the next PDB as given in the documentation above and configure the URL mapping for each database added.