Skip to Main Content
Forums

Database Software

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!

Job "SYSTEM"."SYS_IMPORT_FULL_01" completed with 15834 error(s)

2924251Apr 6 2015 — edited Apr 9 2015

Hello everyone,

I am trying to import dmp file with this command "impdp system/Admin123 directory=dpimport dumpfile=biapps_SA406.dmp logfile=biapps_SA406.log;"

and i am getting error:-

Import: Release 12.1.0.1.0 - Production on Mon Apr 6 01:32:35 2015

Copyright (c) 1982, 2013, Oracle and/or its affiliates.  All rights reserved.

;;;

Connected to: Oracle Database 12c Enterprise Edition Release 12.1.0.1.0 - 64bit Production

With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options

Master table "SYSTEM"."SYS_IMPORT_FULL_01" successfully loaded/unloaded

Starting "SYSTEM"."SYS_IMPORT_FULL_01":  system/******** directory=dpimport dumpfile=biapps_SA406.dmp logfile=biapps_SA406.log

Processing object type SCHEMA_EXPORT/USER

ORA-39083: Object type USER:"OBIACOMP" failed to create with error:

ORA-65096: invalid common user or role name

Failing sql is:

CREATE USER "OBIACOMP" IDENTIFIED BY VALUES 'S:894F6F9EBCF11409EA3B843D2631B16951C15F536DCBE5CC4FADF850F9C8;H:B46C0365387C6054A2F8368402CF1C8B;B3E1A7AF497FC916' DEFAULT TABLESPACE "OBIACOMP" TEMPORARY TABLESPACE "TEMP"

ORA-39083: Object type USER:"OBIA11GSIA" failed to create with error:

ORA-65096: invalid common user or role name

Failing sql is:

CREATE USER "OBIA11GSIA" IDENTIFIED BY VALUES 'S:008191B0C06976A8020E7F6C824CBBD126A5AF399ABF6AAB33EB79F283AD;H:37DC54EAE7E7800301A056C0F327FD14;DF189CCA4165E308' DEFAULT TABLESPACE "OBIA11GSIA" TEMPORARY TABLESPACE "TEMP"

ORA-39083: Object type USER:"OBIA11GFIN" failed to create with error:

ORA-65096: invalid common user or role name

Failing sql is:

CREATE USER "OBIA11GFIN" IDENTIFIED BY VALUES 'S:652CFBE2321B6D58F7B4978009D178487FE3E623835FC346084AD20412ED;H:F7947C97F26E694FE7CF39E0E7763B33;B432F1D6424B60EC' DEFAULT TABLESPACE "OBIA11GFIN" TEMPORARY TABLESPACE "TEMP"

ORA-39083: Object type USER:"OBIA11GDGT" failed to create with error:

ORA-65096: invalid common user or role name

Failing sql is:

CREATE USER "OBIA11GDGT" IDENTIFIED BY VALUES 'S:5DED7FF37E8A9C1F79A4E5E7E5131795B8EEA3A207EA1A2ECC6484173794;H:861AB6B323B8240F6066CB5A777FB44E;943C057D60EA6874' DEFAULT TABLESPACE "OBIA11GDGT" TEMPORARY TABLESPACE "TEMP"

ORA-39083: Object type USER:"OBIACONFIG" failed to create with error:

ORA-65096: invalid common user or role name

Failing sql is:

CREATE USER "OBIACONFIG" IDENTIFIED BY VALUES 'S:6BF5AB938C46FDD75430C58F62411E2096D017B4134E29EAEAE3463E0618;H:4BECDB4615ACE2C3797B6C6D45C22525;DAAEDF1C4BC03E3A' DEFAULT TABLESPACE "OBIACONFIG" TEMPORARY TABLESPACE "TEMP"

ORA-39083: Object type USER:"OBIADGT2" failed to create with error:

ORA-65096: invalid common user or role name

Failing sql is:

CREATE USER "OBIADGT2" IDENTIFIED BY VALUES 'S:AFEA67EA024494A9B83FAF3B745721D667CA5DA6F05D838D83667745ACB5;H:98A25AC425BC554C114F1DEF08B32AAD;94AE7454A245A0F0' DEFAULT TABLESPACE "OBIADGT2" TEMPORARY TABLESPACE "TEMP"

ORA-39083: Object type USER:"OBIADGT" failed to create with error:

ORA-65096: invalid common user or role name

Failing sql is:

CREATE USER "OBIADGT" IDENTIFIED BY VALUES 'S:01AAA8EA8251E8FD3A42DF98DCA5FBCE65C5DDE49F26C3504C0CF996D178;H:2AFCF7A23BB164EE95A7BCF060DDCF10;3B2E8E6D4E62024D' DEFAULT TABLESPACE "OBIADGT" TEMPORARY TABLESPACE "TEMP"

Processing object type SCHEMA_EXPORT/SYSTEM_GRANT

ORA-39083: Object type SYSTEM_GRANT failed to create with error:

ORA-01917: user or role 'OBIA11GDGT' does not exist

Failing sql is:

GRANT UNLIMITED TABLESPACE TO "OBIA11GDGT"

ORA-39083: Object type SYSTEM_GRANT failed to create with error:

ORA-01917: user or role 'OBIA11GFIN' does not exist

Failing sql is:

GRANT UNLIMITED TABLESPACE TO "OBIA11GFIN"

ORA-39083: Object type SYSTEM_GRANT failed to create with error:

ORA-01917: user or role 'OBIA11GSIA' does not exist

Failing sql is:

GRANT UNLIMITED TABLESPACE TO "OBIA11GSIA"

ORA-39083: Object type SYSTEM_GRANT failed to create with error:

ORA-01917: user or role 'OBIACOMP' does not exist

Failing sql is:

GRANT UNLIMITED TABLESPACE TO "OBIACOMP"

ORA-39083: Object type SYSTEM_GRANT failed to create with error:

ORA-01917: user or role 'OBIACONFIG' does not exist

Failing sql is:

GRANT UNLIMITED TABLESPACE TO "OBIACONFIG"

ORA-39083: Object type SYSTEM_GRANT failed to create with error:

ORA-01917: user or role 'OBIADGT' does not exist

Failing sql is:

GRANT CREATE ANY CONTEXT TO "OBIADGT"

ORA-39083: Object type SYSTEM_GRANT failed to create with error:

ORA-01917: user or role 'OBIADGT' does not exist

Failing sql is:

GRANT EXECUTE ANY PROCEDURE TO "OBIADGT"

ORA-39083: Object type SYSTEM_GRANT failed to create with error:

ORA-01917: user or role 'OBIADGT' does not exist

Failing sql is:

GRANT UNLIMITED TABLESPACE TO "OBIADGT"

ORA-39083: Object type SYSTEM_GRANT failed to create with error:

ORA-01917: user or role 'OBIADGT2' does not exist

Failing sql is:

GRANT CREATE ANY CONTEXT TO "OBIADGT2"

ORA-39083: Object type SYSTEM_GRANT failed to create with error:

ORA-01917: user or role 'OBIADGT2' does not exist

Failing sql is:

GRANT UNLIMITED TABLESPACE TO "OBIADGT2"

Processing object type SCHEMA_EXPORT/ROLE_GRANT

ORA-39083: Object type ROLE_GRANT failed to create with error:

ORA-01917: user or role 'OBIA11GDGT' does not exist

Failing sql is:

GRANT "DBA" TO "OBIA11GDGT"

ORA-39083: Object type ROLE_GRANT failed to create with error:

ORA-01917: user or role 'OBIA11GFIN' does not exist

Failing sql is:

GRANT "DBA" TO "OBIA11GFIN"

ORA-39083: Object type ROLE_GRANT failed to create with error:

ORA-01917: user or role 'OBIA11GSIA' does not exist

Failing sql is:

GRANT "DBA" TO "OBIA11GSIA"

ORA-39083: Object type ROLE_GRANT failed to create with error:

ORA-01917: user or role 'OBIACOMP' does not exist

Failing sql is:

GRANT "DBA" TO "OBIACOMP"

ORA-39083: Object type ROLE_GRANT failed to create with error:

ORA-01917: user or role 'OBIACONFIG' does not exist

Failing sql is:

GRANT "DBA" TO "OBIACONFIG"

ORA-39083: Object type ROLE_GRANT failed to create with error:

ORA-01917: user or role 'OBIADGT' does not exist

Failing sql is:

GRANT "DBA" TO "OBIADGT"

ORA-39083: Object type ROLE_GRANT failed to create with error:

ORA-01917: user or role 'OBIADGT2' does not exist

Failing sql is:

GRANT "DBA" TO "OBIADGT2"

Processing object type SCHEMA_EXPORT/DEFAULT_ROLE

ORA-39083: Object type DEFAULT_ROLE:"OBIA11GDGT" failed to create with error:

ORA-01918: user 'OBIA11GDGT' does not exist

Failing sql is:

ALTER USER "OBIA11GDGT" DEFAULT ROLE ALL

ORA-39083: Object type DEFAULT_ROLE:"OBIA11GFIN" failed to create with error:

ORA-01918: user 'OBIA11GFIN' does not exist

Failing sql is:

ALTER USER "OBIA11GFIN" DEFAULT ROLE ALL

ORA-39083: Object type DEFAULT_ROLE:"OBIA11GSIA" failed to create with error:

ORA-01918: user 'OBIA11GSIA' does not exist

Failing sql is:

ALTER USER "OBIA11GSIA" DEFAULT ROLE ALL

ORA-39083: Object type DEFAULT_ROLE:"OBIACOMP" failed to create with error:

ORA-01918: user 'OBIACOMP' does not exist

Failing sql is:

ALTER USER "OBIACOMP" DEFAULT ROLE ALL

ORA-39083: Object type DEFAULT_ROLE:"OBIACONFIG" failed to create with error:

ORA-01918: user 'OBIACONFIG' does not exist

Failing sql is:

ALTER USER "OBIACONFIG" DEFAULT ROLE ALL

ORA-39083: Object type DEFAULT_ROLE:"OBIADGT" failed to create with error:

ORA-01918: user 'OBIADGT' does not exist

Failing sql is:

ALTER USER "OBIADGT" DEFAULT ROLE ALL

ORA-39083: Object type DEFAULT_ROLE:"OBIADGT2" failed to create with error:

ORA-01918: user 'OBIADGT2' does not exist

Failing sql is:

ALTER USER "OBIADGT2" DEFAULT ROLE ALL

Processing object type SCHEMA_EXPORT/PRE_SCHEMA/PROCACT_SCHEMA

ORA-39083: Object type PROCACT_SCHEMA failed to create with error:

ORA-31625: Schema OBIA11GDGT is needed to import this object, but is unaccessible

ORA-01435: user does not exist

Failing sql is:

BEGIN

sys.dbms_logrep_imp.instantiate_schema(schema_name=>SYS_CONTEXT('USERENV','CURRENT_SCHEMA'), export_db_name=>'PDBORCL', inst_scn=>'13383845659503');COMMIT; END;

ORA-39083: Object type PROCACT_SCHEMA failed to create with error:

ORA-31625: Schema OBIADGT2 is needed to import this object, but is unaccessible

ORA-01435: user does not exist

Failing sql is:

BEGIN

sys.dbms_logrep_imp.instantiate_schema(schema_name=>SYS_CONTEXT('USERENV','CURRENT_SCHEMA'), export_db_name=>'PDBORCL', inst_scn=>'13383845659503');COMMIT; END;

ORA-39083: Object type PROCACT_SCHEMA failed to create with error:

ORA-31625: Schema OBIADGT is needed to import this object, but is unaccessible

ORA-01435: user does not exist

Failing sql is:

BEGIN

sys.dbms_logrep_imp.instantiate_schema(schema_name=>SYS_CONTEXT('USERENV','CURRENT_SCHEMA'), export_db_name=>'PDBORCL', inst_scn=>'13383845659503');COMMIT; END;

ORA-39083: Object type PROCACT_SCHEMA failed to create with error:

ORA-31625: Schema OBIACONFIG is needed to import this object, but is unaccessible

ORA-01435: user does not exist

Failing sql is:

BEGIN

sys.dbms_logrep_imp.instantiate_schema(schema_name=>SYS_CONTEXT('USERENV','CURRENT_SCHEMA'), export_db_name=>'PDBORCL', inst_scn=>'13383845659503');COMMIT; END;

ORA-39083: Object type PROCACT_SCHEMA failed to create with error:

ORA-31625: Schema OBIACOMP is needed to import this object, but is unaccessible

ORA-01435: user does not exist

Failing sql is:

BEGIN

sys.dbms_logrep_imp.instantiate_schema(schema_name=>SYS_CONTEXT('USERENV','CURRENT_SCHEMA'), export_db_name=>'PDBORCL', inst_scn=>'13383845659503');COMMIT; END;

ORA-39083: Object type PROCACT_SCHEMA failed to create with error:

ORA-31625: Schema OBIA11GSIA is needed to import this object, but is unaccessible

ORA-01435: user does not exist

Failing sql is:

BEGIN

sys.dbms_logrep_imp.instantiate_schema(schema_name=>SYS_CONTEXT('USERENV','CURRENT_SCHEMA'), export_db_name=>'PDBORCL', inst_scn=>'13383845659503');COMMIT; END;

ORA-39083: Object type PROCACT_SCHEMA failed to create with error:

ORA-31625: Schema OBIA11GFIN is needed to import this object, but is unaccessible

ORA-01435: user does not exist

Failing sql is:

BEGIN

sys.dbms_logrep_imp.instantiate_schema(schema_name=>SYS_CONTEXT('USERENV','CURRENT_SCHEMA'), export_db_name=>'PDBORCL', inst_scn=>'13383845659503');COMMIT; END;

Processing object type SCHEMA_EXPORT/SYNONYM/SYNONYM

ORA-39083: Object type SYNONYM:"OBIADGT2"."W_GL_REVN_GRPACCT_FSCLYR_A" failed to create with error:

ORA-01917: user or role '' does not exist

Failing sql is:

CREATE EDITIONABLE SYNONYM "OBIADGT2"."W_GL_REVN_GRPACCT_FSCLYR_A" FOR "OBIADGT"."W_GL_REVN_GRPACCT_FSCLYR_A"

ORA-39083: Object type SYNONYM:"OBIADGT2"."W_GL_REVN_GIU_FS" failed to create with error:

ORA-01917: user or role '' does not exist

Failing sql is:

CREATE EDITIONABLE SYNONYM "OBIADGT2"."W_GL_REVN_GIU_FS" FOR "OBIADGT"."W_GL_REVN_GIU_FS"

ORA-39083: Object type SYNONYM:"OBIADGT2"."W_GL_REVN_GRPACCOUNT_A_TMP" failed to create with error:

ORA-01917: user or role '' does not exist

Failing sql is:

CREATE EDITIONABLE SYNONYM "OBIADGT2"."W_GL_REVN_GRPACCOUNT_A_TMP" FOR "OBIADGT"."W_GL_REVN_GRPACCOUNT_A_TMP"

ORA-39083: Object type SYNONYM:"OBIADGT2"."W_GL_REVN_PE_TS" failed to create with error:

ORA-01917: user or role '' does not exist

Failing sql is:

CREATE EDITIONABLE SYNONYM "OBIADGT2"."W_GL_REVN_PE_TS" FOR "OBIADGT"."W_GL_REVN_PE_TS"

ORA-39083: Object type SYNONYM:"OBIADGT2"."W_GL_SEGMENT_D" failed to create with error:

ORA-01917: user or role '' does not exist

Failing sql is:

CREATE EDITIONABLE SYNONYM "OBIADGT2"."W_GL_SEGMENT_D" FOR "OBIADGT"."W_GL_SEGMENT_D"

ORA-39083: Object type SYNONYM:"OBIADGT2"."W_GL_SEGMENT_DS" failed to create with error:

ORA-01917: user or role '' does not exist

Failing sql is:

CREATE EDITIONABLE SYNONYM "OBIADGT2"."W_GL_SEGMENT_DS" FOR "OBIADGT"."W_GL_SEGMENT_DS"

ORA-39083: Object type SYNONYM:"OBIADGT2"."W_GL_SEGMENT_D_BK" failed to create with error:

ORA-01917: user or role '' does not exist

Failing sql is:

CREATE EDITIONABLE SYNONYM "OBIADGT2"."W_GL_SEGMENT_D_BK" FOR "OBIADGT"."W_GL_SEGMENT_D_BK"

ORA-39083: Object type SYNONYM:"OBIADGT2"."W_GROUP_ACCT_FIN_STMT_D_TMP" failed to create with error:

ORA-01917: user or role '' does not exist

Failing sql is:

CREATE EDITIONABLE SYNONYM "OBIADGT2"."W_GROUP_ACCT_FIN_STMT_D_TMP" FOR "OBIADGT"."W_GROUP_ACCT_FIN_STMT_D_TMP"

ORA-39083: Object type SYNONYM:"OBIADGT2"."W_HHOLD_PARTY" failed to create with error:

ORA-01917: user or role '' does not exist

Failing sql is:

CREATE EDITIONABLE SYNONYM "OBIADGT2"."W_HHOLD_PARTY" FOR "OBIADGT"."W_HHOLD_PARTY"

ORA-39083: Object type SYNONYM:"OBIADGT2"."W_HIERARCHY_D" failed to create with error:

ORA-01917: user or role '' does not exist

Failing sql is:

CREATE EDITIONABLE SYNONYM "OBIADGT2"."W_HIERARCHY_D" FOR "OBIADGT"."W_HIERARCHY_D"

ORA-39083: Object type SYNONYM:"OBIADGT2"."W_HIERARCHY_DS" failed to create with error:

ORA-01917: user or role '' does not exist

Failing sql is:

CREATE EDITIONABLE SYNONYM "OBIADGT2"."W_HIERARCHY_DS" FOR "OBIADGT"."W_HIERARCHY_DS"

ORA-39083: Object type SYNONYM:"OBIADGT2"."W_HIERARCHY_D_DEL" failed to create with error:

ORA-01917: user or role '' does not exist

Failing sql is:

CREATE EDITIONABLE SYNONYM "OBIADGT2"."W_HIERARCHY_D_DEL" FOR "OBIADGT"."W_HIERARCHY_D_DEL"

ORA-39083: Object type SYNONYM:"OBIADGT2"."W_HLDNG_PARTY" failed to create with error:

ORA-01917: user or role '' does not exist

Failing sql is:

CREATE EDITIONABLE SYNONYM "OBIADGT2"."W_HLDNG_PARTY" FOR "OBIADGT"."W_HLDNG_PARTY"

ORA-39083: Object type SYNONYM:"OBIADGT2"."W_HOUR_OF_DAY_D" failed to create with error:

ORA-01917: user or role '' does not exist

Failing sql is:

CREATE EDITIONABLE SYNONYM "OBIADGT2"."W_HOUR_OF_DAY_D" FOR "OBIADGT"."W_HOUR_OF_DAY_D"

ORA-39083: Object type SYNONYM:"OBIADGT2"."W_HOUSEHOLD_D" failed to create with error:

ORA-01917: user or role '' does not exist

Failing sql is:

CREATE EDITIONABLE SYNONYM "OBIADGT2"."W_HOUSEHOLD_D" FOR "OBIADGT"."W_HOUSEHOLD_D"

ORA-39083: Object type SYNONYM:"OBIADGT2"."W_HOUSEHOLD_DS" failed to create with error:

ORA-01917: user or role '' does not exist

Failing sql is:

CREATE EDITIONABLE SYNONYM "OBIADGT2"."W_HOUSEHOLD_DS" FOR "OBIADGT"."W_HOUSEHOLD_DS"

ORA-39083: Object type SYNONYM:"OBIADGT2"."W_HOUSEHOLD_DSX" failed to create with error:

ORA-01917: user or role '' does not exist

Failing sql is:

CREATE EDITIONABLE SYNONYM "OBIADGT2"."W_HOUSEHOLD_DSX" FOR "OBIADGT"."W_HOUSEHOLD_DSX"

ORA-39083: Object type SYNONYM:"OBIADGT2"."W_HOUSEHOLD_DX" failed to create with error:

ORA-01917: user or role '' does not exist

like this i am getting 15834 error, can anyone help me out. Thanks
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 7 2015
Added on Apr 6 2015
#database-key-features, #export-import-sql-loader-external-tables
3 comments
2,239 views