This question is coming up from time to time – and currently not covered in the official Oracle documentation as far as I know: “Can you simply switch from SE2 to EE with Oracle Multitenant?”
Yes, you can!
First of all, the switch is possible and tested. But you’ll have to satisfy a few requirements:
- Both database versions must be the same
- Both databases must have the same character set (in Oracle Database 12.1)
That’s it. Simply unplug your Standard Edition 2 PDB and plug it into your Enterprise Edition CDB.
In addition you may have to run several component … [ Read more ]