'ORA-39006 And ORA-06512' Signalled When RCU Attempts To Create ODI Repositories Using The impdp Datapump Import Command (Doc ID 1581023.1)

Last updated on JUNE 06, 2016

Applies to:

Oracle Data Integrator - Version 11.1.1.3.0 and later
Information in this document applies to any platform.

Symptoms

The Oracle Repository Creation Utility (RCU) fails creating the Oracle Data Integrator (ODI) repositories, and receives ORA-39006 and ORA-06512 messages when executing the Datapump impdp import command:

2013-08-30 17:36:50.992 NOTIFICATION rcu: oracle.biapps.rcu.dbinstall.DataPumpUtils::importSchema: importSchema starting. Datapump messages will be in E:\Softwares\OBIEE11.1.1.7.0\Bus_Analytics_Apps_Suite_RCU_Win64\/rcu/log\logdir.2013-08-30_17-23/biapps_odi_runimport.log.
2013-08-30 17:36:50.992 NOTIFICATION rcu: oracle.biapps.rcu.dbinstall.DataPumpUtils::importSchema: importSchema: directory name is ODI_DBINSTALL_DUMP_DIR.
2013-08-30 17:36:50.992 NOTIFICATION rcu: oracle.biapps.rcu.dbinstall.DataPumpUtils::importSchema: importSchema: dumpfile is obia_odi.dmp.
2013-08-30 17:36:50.992 NOTIFICATION rcu: oracle.biapps.rcu.dbinstall.DataPumpUtils::importSchema: importSchema: tablespace remapping from BIAPPS_REP to BIAPPS_BIA_ODIREPO
2013-08-30 17:36:50.992 NOTIFICATION rcu: oracle.biapps.rcu.dbinstall.DataPumpUtils::importSchema: importSchema: tablespace remapping from TEMP to BIAPPS_BIA_ODIREPO_TEMP
2013-08-30 17:36:51.008 NOTIFICATION rcu: oracle.biapps.rcu.dbinstall.DataPumpUtils::getDumpfileInfo: Trying to get info about dir=ODI_DBINSTALL_DUMP_DIR dump file=obia_odi.dmp
2013-08-30 17:36:51.133 NOTIFICATION rcu: oracle.biapps.rcu.dbinstall.DataPumpUtils::getDumpfileInfo: Dumpfile Info 1 3.1
2013-08-30 17:36:51.133 NOTIFICATION rcu: oracle.biapps.rcu.dbinstall.DataPumpUtils::getDumpfileInfo: Dumpfile Info 15 11.02.00.00.00
2013-08-30 17:36:51.133 NOTIFICATION rcu: oracle.biapps.rcu.dbinstall.DataPumpUtils::getDumpfileInfo: Dumpfile Info 2 1
2013-08-30 17:36:51.133 NOTIFICATION rcu: oracle.biapps.rcu.dbinstall.DataPumpUtils::getDumpfileInfo: Dumpfile Info 7 6
2013-08-30 17:36:51.133 NOTIFICATION rcu: oracle.biapps.rcu.dbinstall.DataPumpUtils::getDumpfileInfo: Dumpfile Info 3 DA6CF4E29179951FE040F00A396F132F
2013-08-30 17:36:51.133 NOTIFICATION rcu: oracle.biapps.rcu.dbinstall.DataPumpUtils::getDumpfileInfo: Dumpfile Info 5 873
2013-08-30 17:36:51.133 NOTIFICATION rcu: oracle.biapps.rcu.dbinstall.DataPumpUtils::getDumpfileInfo: Dumpfile Info 4 1
2013-08-30 17:36:51.133 NOTIFICATION rcu: oracle.biapps.rcu.dbinstall.DataPumpUtils::getDumpfileInfo: Dumpfile Info 8 "SYSTEM"."SYS_EXPORT_SCHEMA_01"
2013-08-30 17:36:51.133 NOTIFICATION rcu: oracle.biapps.rcu.dbinstall.DataPumpUtils::getDumpfileInfo: Dumpfile Info 9 x86_64/Linux 2.4.xx
2013-08-30 17:36:51.133 NOTIFICATION rcu: oracle.biapps.rcu.dbinstall.DataPumpUtils::getDumpfileInfo: Dumpfile Info 10 slcae144
2013-08-30 17:36:51.133 NOTIFICATION rcu: oracle.biapps.rcu.dbinstall.DataPumpUtils::getDumpfileInfo: Dumpfile Info 11 AL32UTF8
2013-08-30 17:36:51.133 NOTIFICATION rcu: oracle.biapps.rcu.dbinstall.DataPumpUtils::getDumpfileInfo: Dumpfile Info 6 Mon Apr 15 13:19:56 2013
2013-08-30 17:36:51.133 NOTIFICATION rcu: oracle.biapps.rcu.dbinstall.DataPumpUtils::getDumpfileInfo: Dumpfile Info 12 4096
2013-08-30 17:36:51.133 NOTIFICATION rcu: oracle.biapps.rcu.dbinstall.DataPumpUtils::getDumpfileInfo: Dumpfile Info 14 1
2013-08-30 17:36:51.133 NOTIFICATION rcu: oracle.biapps.rcu.dbinstall.DataPumpUtils::getDumpfileInfo: Dumpfile Info 18 1
2013-08-30 17:36:51.133 NOTIFICATION rcu: oracle.biapps.rcu.dbinstall.DataPumpUtils::getDumpfileInfo: Dumpfile Info 19 0
2013-08-30 17:36:51.133 NOTIFICATION rcu: oracle.biapps.rcu.dbinstall.DataPumpUtils::getDumpfileInfo: Dumpfile Info 20 0
2013-08-30 17:36:51.133 NOTIFICATION rcu: oracle.biapps.rcu.dbinstall.DataPumpUtils::getDumpfileInfo: Dumpfile Info 21 0
2013-08-30 17:36:51.133 NOTIFICATION rcu: oracle.biapps.rcu.dbinstall.DataPumpUtils::getDumpfileInfo: Dumpfile Info 22 2
2013-08-30 17:36:51.133 NOTIFICATION rcu: oracle.biapps.rcu.dbinstall.DataPumpUtils::getDumpfileInfo: Dumpfile Info 16 1
2013-08-30 17:36:51.133 NOTIFICATION rcu: oracle.biapps.rcu.dbinstall.DataPumpUtils::getDumpfileInfo: Dumpfile Info 17 1
2013-08-30 17:36:52.507 NOTIFICATION rcu: oracle.biapps.rcu.dbinstall.DataPumpUtils::importSchema: importSchema done.
2013-08-30 17:36:52.507 INCIDENT_ERROR rcu: oracle.sysman.assistants.rcu.backend.action.ActionThread::run: Failed to execute method:  Excepton:
java.lang.reflect.InvocationTargetException
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
    at java.lang.reflect.Method.invoke(Method.java:597)
    at oracle.sysman.assistants.rcu.backend.action.ActionThread.run(JavaAction.java:510)
    at java.lang.Thread.run(Thread.java:662)
Caused by: java.sql.SQLException: ORA-39006: internal error
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 79
ORA-06512: at "SYS.DBMS_DATAPUMP", line 3507
ORA-06512: at "SYS.DBMS_DATAPUMP", line 5296
ORA-06512: at line 1
    at ...

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms