Upgrade impossible for Oracle 11.2.0.1 ?

This refers to github project train.oracle12.migration

The Problem

Oracle 11.2.0.1 is said to be impossible to upgrade to Orarcle12c. This is only partially true. There are generally  4 methods to upgrade to Oracle12c

1. manually using the commandline
2. using the GUI tool DBUA
3. plug in using DBMS_PDB
4. full transportable tablespace export / import

Other methods used  in ancient days are mentioned under last, not least, i.e. exporting the data and importing them into an Oracle12c - database.

Several Solutions

 click on the pictures to enlarge

Here is a compensation for  transportable tablespace. It is true, that datapump complains that it cannot recognize the release. But if you call datapump in another way, then it is possible anyway.

Here is my parfile for the export. And here is my parfile for the import.

Datapump is then

called like that.


And here is the proof that the

contents of the tablespace users was completely transported to the Container Database.

We could make it more elegant using a database link instead of using a dumpfile.  Trs y other solutions - that is the aim of my project.

Another approach: I have added an optional non-cdb Oracle12c database, so that one may practice to plugin and to do a Full Transportable export / import.


Other chances to learn upgrading

To get a feeling for this sort of things write a little script e.g. preupgrade.sh, in order to see

what Oracle12 wants us to change in the Oracle11 - database before actually starting to upgrade. Study thouroughly the logfile.