Database Utilities (MOSC)

MOSC Banner

Questions about migration from 11.1.0.7 to 11.2.0.2 using datapump

edited Sep 7, 2011 9:46AM in Database Utilities (MOSC) 1 comment

I am testing the migration of our PROD database from AIX 5.3 on 11.1.0.7 to Redhat Linux 5.5 64
bit on 11.2.0.2. I am performing the migration using expdp and impdp. There were many missing
SYS grants after the datapump import which was run from the SYSTEM account. I have
restored most of the grants, but there are 4 packages in the DMSYS schema which are invalid,
but since the packages are wrapped, I cannot see the code to figure out the problem.

I have several questions:
---------------------------------
1.  Can the database files simply be copied from the AIX server to the linux server to migrate?
   (I believe the only method to migrate to new O/S is create an empty DB and datapump import. Please confirm.)

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center