How to migrate Oracle 11gR2 to Oracle 12cR1

Dear Experts,

I have an Oracle 11gR2 EE Database on Windows 2008 R2 Server. There is no RAC, and the size of database is 55 GB. I would like to migrate this Database to Oracle 12cR1 EE as a pluggable database on Windows 2012 R2. Nothing (data, users, permissions, tablespaces etc.) should change.

What is the best and painless way to do this? Could you please provide me necessary directions as well as documentation?

BR
GurcanKAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

DavidSenior Oracle Database AdministratorCommented:
BR, this process is documented, overview and step-by-step, under repositories such as https://docs.oracle.com/database/121/nav/portal_11.htm.  

High level advice is to install a new db home so that your existing system is not corrupted -- and of course experiment with a non-production server if you can.

dvz
0
GurcanKAuthor Commented:
Rather than installation, I would like to get  information (focus on) for migration of database to a database on another server with higher version of Oracle. For example can I do this using Data Pump Export and how, what can be the other ways?
0
sdstuberCommented:
you can use data pump to copy your old users, objects and data to the new db.

the steps are fairly straightforward

create new 12c cdb
create pdb inside the cdb  (if using dbca to create the cdb, you can include this step along with it, or do it afterward)

Once you have the new db ready, just export and import as you would between any other dbs

expdp FULL=Y     from the old db
impdp FULL=Y  into the new pdb


alternatively, you could create a dblink from the new pdb into the old 11g db,  then use the data pump pl/sql api to import directly.  Using files gives you a little bit of a safety net though, if something goes wrong on the import you don't need to do the export again, just reimport the existing file.
0
GurcanKAuthor Commented:
Will impdp also create tablespace, sequence, user and schema objects in target database?
0
sdstuberCommented:
>>>> Will impdp also create tablespace, sequence, user and schema objects in target database?

if you did a full export, and you do a full import it will try to

I say "try" because if you old database had datafiles in
     /this/path  
but your new server only has
    /that/path  

then the data file creation will fail for the tablespaces.
if that happens, then simply create the tablespaces yourself in the new database and import with IGNORE=Y  and then the create will try, it will fail because they already exist and the rest of the import will proceed as normal.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Oracle Database

From novice to tech pro — start learning today.