I followed the instructions provided at:
https://docs.oracle.com/en/database/oracle/oracle-database/18/xeinw/exporting-and-importing-data-oracle-database-xe-11.2…
I experienced no problem with the data export, shutdown of 11gXE, install of 18cXE - but when I attempt to import the 11.2 data it fails.
This is the command:
impdp system/(mypassword)@localhost/xepdb1 full=Y REMAP_DIRECTORY="D:\oraclexe\app\oracle\oradata\XE\":"\install_dir\oradata\XE\" directory=DUMP_DIR dumpfile=DB11G.dmp logfile=impdpDB11G.log
Here is the logfile:
Import: Release 18.0.0.0.0 - Production on Mon May 20 15:35:02 2019
Version 18.4.0.0.0
Copyright (c) 1982, 2019, Oracle and/or its affiliates. All rights reserved.
Connected to: Oracle Database 18c Express Edition Release 18.0.0.0.0 - Production
Master table "SYSTEM"."SYS_IMPORT_FULL_01" successfully loaded/unloaded
Starting "SYSTEM"."SYS_IMPORT_FULL_01": system/********@localhost/xepdb1 full=Y REMAP_DIRECTORY=D:\oraclexe\app\oracle\oradata\XE":\install_dir\oradata\XE" directory=DUMP_DIR dumpfile=DB11G.dmp logfile=impdpDB11G.log
Processing object type DATABASE_EXPORT/TABLESPACE
ORA-39126: Worker unexpected fatal error in KUPW$WORKER.PUT_DDLS [TABLESPACE:"SYSAUX"]
ORA-01403: no data found
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95
ORA-06512: at "SYS.KUPW$WORKER", line 12372
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95
ORA-06512: at "SYS.KUPW$WORKER", line 25745
ORA-06512: at "SYS.KUPW$WORKER", line 25283
----- PL/SQL Call Stack -----
object line object
handle number name
00007FFA0D3EFB28 32868 package body SYS.KUPW$WORKER.WRITE_ERROR_INFORMATION
00007FFA0D3EFB28 12400 package body SYS.KUPW$WORKER.DETERMINE_FATAL_ERROR
00007FFA0D3EFB28 25809 package body SYS.KUPW$WORKER.PUT_DDLS
00007FFA0D3EFB28 5248 package body SYS.KUPW$WORKER.LOAD_METADATA
00007FFA0D3EFB28 13488 package body SYS.KUPW$WORKER.DISPATCH_WORK_ITEMS
00007FFA0D3EFB28 2410 package body SYS.KUPW$WORKER.MAIN
00007FFA0AAD9F50 2 anonymous block
KUPW: l_valid: -3 - Not Loading DBA with type JOB
KUPW: l_valid : 1 - Loading SOURCE_VERSION with type NULL
KUPW:
KUPW: In procedure BUILD_OBJECT_STRINGS - non-base info
DBMS_METADATA.CONVERT
DBMS_METADATA.CONVERT
KUPW: l_cur = 1
KUPW: l_pos = 0
KUPW:
KUPW: In procedure DETERMINE_FATAL_ERROR with ORA-01403: no data found
ORA-06512: at "SYS.KUPW$WORKER", line 25745
ORA-06512: at "SYS.KUPW$WORKER", line 25283
ORA-39126: Worker unexpected fatal error in KUPW$WORKER.PUT_DDLS [TABLESPACE:"SYSAUX"]
ORA-01403: no data found
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95
ORA-06512: at "SYS.KUPW$WORKER", line 12372
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95
ORA-06512: at "SYS.KUPW$WORKER", line 25745
ORA-06512: at "SYS.KUPW$WORKER", line 25283
----- PL/SQL Call Stack -----
object line object
handle number name
00007FFA0D3EFB28 32868 package body SYS.KUPW$WORKER.WRITE_ERROR_INFORMATION
00007FFA0D3EFB28 12400 package body SYS.KUPW$WORKER.DETERMINE_FATAL_ERROR
00007FFA0D3EFB28 25809 package body SYS.KUPW$WORKER.PUT_DDLS
00007FFA0D3EFB28 5248 package body SYS.KUPW$WORKER.LOAD_METADATA
00007FFA0D3EFB28 13488 package body SYS.KUPW$WORKER.DISPATCH_WORK_ITEMS
00007FFA0D3EFB28 2410 package body SYS.KUPW$WORKER.MAIN
00007FFA0AAD9F50 2 anonymous block
KUPW: l_valid : 1 - Loading SOURCE_VERSION with type NULL
KUPW: l_valid: -3 - Not Loading DBA with type JOB
KUPW:
KUPW: In procedure BUILD_OBJECT_STRINGS - non-base info
DBMS_METADATA.CONVERT
DBMS_METADATA.CONVERT
KUPW: l_cur = 1
KUPW: l_pos = 0
KUPW:
KUPW: In procedure DETERMINE_FATAL_ERROR with ORA-01403: no data found
ORA-06512: at "SYS.KUPW$WORKER", line 25745
ORA-06512: at "SYS.KUPW$WORKER", line 25283
Job "SYSTEM"."SYS_IMPORT_FULL_01" stopped due to fatal error at Mon May 20 15:35:12 2019 elapsed 0 00:00:08
Any idea what the problem might be?
APEX is not installed in 18c (by default) and the instructions did not indicate that needed to be done first...
EDIT: the old 11gXE Apex was version 5.1.4, the minimum required
Rich