With Oracle Database 19c being the long term release, makes sense to start planning the upgrade of the DBs running on previous releases. Even better, what about converting Non-CDB databases into PDBs at the same time?
Using Oracle Enterprise Manager (EM) 13c, we can kill two birds with one stone. That is upgrade our DBs to 19c and migrate them into a PDB at the same time.
How this works? First of all, this functionality is part of the Database Lifecycle Management Pack. You can find the documentation for this feature along with all the pre-reqs below:
Let me guide you through this process.
In this environment I have a single instance database “orders”. As you can see on the screenshot below, is currently running version 18.10.
Let’s now navigate to Enterprise -> Provisioning and Patching -> Database Provisioning
Locate the Provision Pluggable Databases link under Related Links section
This will open the Provision Pluggable Database dashboard.
Select the Container Database which is out target. Click on Migrate Existing Databases and then click the Launch button.
Select the desired migration method. You can choose between Data Pump Full Transportable Export and Import or Plug as a PDB. There are cons and pros on each method. Review the documentation previously shared so you can choose the best option for your migration.
For the purpose of this example we are going to choose Data Pump Full Transportable Export and Import.
Now add the source DBs to be migrated.
Add or select the required Named Credentials and provide the path for the Export Directory.
Provide the required Destination Information and click Next.
EM will execute compatibility and validation checks. If there are no errors click Close to proceed.
Type a name for the EM job and select the desired schedule for it to run.
Review all the information provided and click Submit.
Wait for the Confirmation pop-up window and click View Job.
Monitor the progress of the deployment procedure until it completes.
Confirm that the db19c container DB now has the ORDERS PDB.
Click on the ORDERS PDB and verify the version information.
We now have migrated our orders DB into the db19c container running 19.3 version.
I also recommend to take a look at MOS Doc ID 2694986.1 before attempting the migration.
Hope this helps to ease the migration process for your DBs.
Thanks,
Alfredo