Oracle Database Express Edition (XE)

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Import Datapump from 19c into XE18c

Matthias E.Apr 23 2020 — edited Jun 2 2020

Hello,

i try to import a datapump, exported from 19c, into 18cXE.

I always get the eroor ORA-39002

The Export Command : "SYSTEM"."GTH_GEWERBE_EXP_JOB": system/******** DUMPFILE=GTH_GEWERBE.dmp SCHEMAS=(GTH_GEWERBE) DIRECTORY=DATAPUMP_EXPORT LOGFILE=GTH_GEWERBE_exp.log JOB_NAME=GTH_GEWERBE_exp_job VERSION=18.0

The Import Command: IMPDP system/*******@KOMVOR SCHEMAS=(GTH_GEWERBE) DUMPFILE=GTH_GEWERBE.DMP LOGFILE=GTH_GEWERBE.log DIRECTORY=IMP_DIR JOB_NAME=GTH_GEWERBE_job

IMPORT LOG :

Import: Release 18.0.0.0.0 - Production on Do Apr 23 07:26:51 2020

Version 18.4.0.0.0

;;;

Angemeldet bei: Oracle Database 18c Express Edition Release 18.0.0.0.0 - Production

Mastertabelle "SYSTEM"."GTH_GEWERBE_JOB" erfolgreich geladen/entladen

Job "SYSTEM"."GTH_GEWERBE_JOB" erfolgreich um Do Apr 23 07:26:54 2020 elapsed 0 00:00:01 abgeschlossen

Compatible Parameter in 18cXE is : "18.0.0"

Grants of the DIRECTORY's are correct.

Datapump Import from "older" Versions like 12.1. .... are succesfull.

Does anyone have a similar problem or suggested solution.

MfG

Matthias

Nachricht geändert durch Matthias E. prpblem ist the "DST_PRIMARY_TT_VERSION';" parameter. Why ? When the DST_PRIMARY_TT_VERSION' ist set to 32 it works. MfG Matthias

Srini Chavali-Oracle

Win Home versions are not certified for Oracle database installs - Oracle Database Preinstallation Tasks

so expect such issues. Is there a reason you cannot use a supported OS version ?

After powering up the laptop, is the database up and running ? You will have to start up the database and listener before you can access the EM Express page - Getting Started with Database Administration

HTH
Srini

user6880652

Hi Srini,

I have also installed Weblogic 12C, and the Weblogic em is working fine as expected. Not sure why the issue comes with Oracle EM only

Srini Chavali-Oracle

Possibly because you are using an unsupported version of the OS

Srini

TSharma-0racle

user6880652 wrote:

I installed 12C Enterprise on my laptop that has Windows 7 Home .The installation process went fine and I was able to connect to http://localhost:5500/em (even used). But, once I powered down my laptop and brought it back up the next day, I couldn't connect ('the page cannot be displayed'). So, I uninstalled oracle and then tried the process again. I could initially connect to 5500/em but after rebooting or powering down the machine, I could not find http://localhost:5500/em.

Can anyone direct me to some specific documentation with this or has anyone conclusively solved this problem to the end????? Thanks for any help.

Shouldn't you be in connecting to HTTPS instead of HTTP(http://localhost:5500/em) OR it is just a typo?

What if you try

https://localhost:5500/em

1 person found this helpful

1 - 4

Added on Apr 23 2020

1 comment

1,581 views

Oracle Database Express Edition (XE)

Import Datapump from 19c into XE18c

Comments

Post Details