Need help on 10.1 DB migrate / upgrade using DataPump and Traditional EXP / IMP.
I have to migrate a 10.1.0.5 DB on 32 bit RHL AS 2.1 to 11.2.0.2 on 64 bit OEL 5.5
10.1 DB information:
DB size ~ 600GB
Objects count : 53523
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
sga_max_size big integer 1744M
sga_target big integer 0
pga_aggregate_target big integer 1G
OS limit
[dmdb] /home19/oracle >ulimit -a
core file size (blocks) 0
data seg size (kbytes) unlimited
file size (blocks) unlimited
max locked memory (kbytes) unlimited
max memory size (kbytes) unlimited
open files 1024
pipe size (512 bytes) 8
stack size (kbytes) unlimited
cpu time (seconds) unlimited
max user processes 2047
virtual memory (kbytes) unlimited
I have tried to migrate the DB using Data Pump in the first place, but I hit ORA-4030 during the expdp with FULL=Y CONTENT=METADATA_ONLY EXCLUDE=(system created schemas).