DB Migration from the 11G in AIX to 12C R2 in Windows

I am migrating DB which contains Two Databases in Oracle 11G(AIX) to 12C R2 in Windows. I am facing difficulty  while full Transportable export, Because the EXPD command in AIX(Big Endien) doesn't support Transportable=always parameter.
I have decided to use approach where I  will create tablespaces and users first in Target DB and then import the Schemas one by one using parfile.

I have done below steps:
1. Exported the DB from the 11G using below command
         expdp system/password@VPMDB1 full=Y directory=xxxx logfile=xxxx
         expdp system/password@VPMDB2 full=Y directory=xxxx logfile=xxxx
2. Created Container DB in 12C and added pluggable DB
3. Executing SQL file to create table spaces, users in to pluggable DB but Pluggable DB has max limit of datafiles. But source db contains datafiles which exceeds max limit.

Is it possible to increase max limit or do I need install Oracle patch?
For second approach I used existing exported dump,So please let me know If above expdp queries will work or not?
Is there any other fastest way to export db. I need export databases from around ~30 Sites

Many Thanks In Advance
vinayak yAsked:
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.

johnsoneSenior Oracle DBACommented:
You can use transportable tablespaces.  You just need to add a step to convert the Endian.

I will point you to the RMAN documentation that describes the whole process here.  I highly recommend reading the whole section, as moving data like this is pretty important and you shouldn't skim over it.  The specific pieces that you are looking for should be in this section.

Another approach would be to get everything running in Windows on 11g using an RMAN backup and convert.  Then do the upgrade as a second step.
1

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
Mark GeerlingsDatabase AdministratorCommented:
It should work to do DataPump exports and imports as you tried.  And yes, creating the tablespace and users in advance in the new database should make this process *MUCH* more likely to succeed.

If you have the tablespaces pre-created, it shouldn't matter how many data files the old system had.  This assumes that you created the tablespaces large enough to accommodate the data you need to import, or manually added enough additional data files to accommodate the data.
1
vinayak yAuthor Commented:
Thank you Johnson and Mark
0
Seth SimmonsSr. Systems AdministratorCommented:
No comment has been added to this question in more than 21 days, so it is now classified as abandoned.

I have recommended this question be closed as follows:

Split:
-- johnsone (https:#a42446236)
-- Mark Geerlings (https:#a42446621)


If you feel this question should be closed differently, post an objection and the moderators will review all objections and close it as they feel fit. If no one objects, this question will be closed automatically the way described above.

seth2740
Experts-Exchange Cleanup Volunteer
0
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
AIX

From novice to tech pro — start learning today.