-
Errors while trying to import a Full Database export
The problem what I am facing is with installation of new oracle tool called OSM, guess you must have heard of it. Well this tool uses weblogic and oracle 10g as the database at the backend. So there seems to be some issue during installation of this tool, esp when it comes to the database creation during installation time. So as a work around we decided to exp the tablespace from the system where the tool has been properly installed using expdp and then import into the required system.
Well this worked on a couple of systems and which lead to the successful installation of the tool too, but on few other system(exception cases), where while trying to import the database was getting the error “ORA-01918: user 'ORDERMGMT' does not exist” , whr ordermgmt and ordermgmt_rule are the 2 users that are created during installation of OSM.
Can you please suggest on how to go forward here, because I have reached the end of my wits, tryin to solve it, as to why it works on some systems and not others.
Hoping towards a positive reply from your end.
Ps- I have used the same dumpfile to import into every system.
;;;
Import: Release 10.2.0.1.0 - Production on Tuesday, 24 February, 2009 11:59:13
Copyright (c) 2003, 2005, Oracle. All rights reserved.
;;;
Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
Master table "SCOTT"."SYS_IMPORT_TABLESPACE_01" successfully loaded/unloaded
Starting "SCOTT"."SYS_IMPORT_TABLESPACE_01": scott/******** directory=new_dump dumpfile=osm.dmp tablespaces=osm_tablespace
Processing object type TABLE_EXPORT/TABLE/TABLE
ORA-39083: Object type TABLE failed to create with error:
ORA-01918: user 'ORDERMGMT' does not exist
Failing sql is:
CREATE TABLE "ORDERMGMT"."OM_HIST$FALLOUT" ("ORDER_SEQ_ID" NUMBER(18,0) NOT NULL ENABLE, "COMPENSATION_ID" NUMBER(18,0) NOT NULL ENABLE, "INITIATOR_HIST_ID" NUMBER(18,0) NOT NULL ENABLE, "FALLOUT_ID" NUMBER(18,0) NOT NULL ENABLE) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 STORAGE( BUFFER_POOL DEFAULT) TABLESPACE "OSM_TABLESPACE" PARTITION BY RANGE ("ORDER_SEQ_ID") SUBPARTITION BY HASH
ORA-39083: Object type TABLE failed to create with error:
ORA-01918: user 'ORDERMGMT' does not exist
Failing sql is:
CREATE TABLE "ORDERMGMT"."OM_HIST$FLOW" ("ORDER_SEQ_ID" NUMBER(18,0) NOT NULL ENABLE, "HIST_SEQ_ID" NUMBER(18,0) NOT NULL ENABLE, "HIST_SEQ_ID_FROM" NUMBER(18,0) NOT NULL ENABLE, "CARTRIDGE_ID" NUMBER(6,0) NOT NULL ENABLE) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 STORAGE( BUFFER_POOL DEFAULT) TABLESPACE "OSM_TABLESPACE" PARTITION BY RANGE ("ORDER_SEQ_ID") SUBPARTITION BY HASH ("ORDE
ORA-39083: Object type TABLE failed to create with error:
ORA-01918: user 'ORDERMGMT' does not exist
Failing sql is:
CREATE TABLE "ORDERMGMT"."OM_ORDER_FLOW" ("ORDER_SEQ_ID" NUMBER(18,0) NOT NULL ENABLE, "HIST_SEQ_ID" NUMBER(18,0) NOT NULL ENABLE, "PROCESS_ID" NUMBER(9,0) NOT NULL ENABLE, "PROCESS_POSITION_ID" NUMBER(9,0) NOT NULL ENABLE, "PROCESS_STATUS_ID" NUMBER(9,0) NOT NULL ENABLE, "STATE_ID" NUMBER(9,0) NOT NULL ENABLE, "DATE_POS_STARTED" DATE NOT NULL ENABLE, "USERNAME" VARCHAR2(32 CHAR) NOT NULL E
ORA-39083: Object type TABLE failed to create with error:
ORA-01918: user 'ORDERMGMT' does not exist
Failing sql is:
CREATE TABLE "ORDERMGMT"."OM_ORDER_HEADER" ("ORDER_SEQ_ID" NUMBER(18,0) NOT NULL ENABLE, "PROCESS_STATUS_ID" NUMBER(9,0) NOT NULL ENABLE, "PROCESS_ID" NUMBER(9,0) NOT NULL ENABLE, "ORDER_TYPE_ID" NUMBER(9,0) NOT NULL ENABLE, "ORDER_SOURCE_ID" NUMBER(9,0) NOT NULL ENABLE, "REFERENCE_NUMBER" VARCHAR2(255) NOT NULL ENABLE, "FILE_NAME" VARCHAR2(255) NOT NULL ENABLE, "ORD_CREATION_DATE" DATE DEF
ORA-39083: Object type TABLE failed to create with error:
ORA-01918: user 'ORDERMGMT' does not exist
Failing sql is:
CREATE TABLE "ORDERMGMT"."OM_ORDER_INSTANCE" ("ORDER_SEQ_ID" NUMBER(18,0) NOT NULL ENABLE, "ORDER_NODE_INDEX" NUMBER(18,0) NOT NULL ENABLE, "ORDER_NODE_ID" NUMBER(9,0) NOT NULL ENABLE, "ORDER_NODE_TYPE" VARCHAR2(20) NOT NULL ENABLE, "DATA_DICTIONARY_ID" NUMBER(9,0) NOT NULL ENABLE, "ORDER_TYPE_ID" NUMBER(9,0) NOT NULL ENABLE, "ORDER_SOURCE_ID" NUMBER(9,0) NOT NULL ENABLE, "DML_ACTION" CHAR(
ORA-39083: Object type TABLE failed to create with error:
ORA-01918: user 'ORDERMGMT' does not exist
Failing sql is:
CREATE TABLE "ORDERMGMT"."OM_HIST$ORDER_HEADER" ("ORDER_SEQ_ID" NUMBER(18,0) NOT NULL ENABLE, "HIST_SEQ_ID" NUMBER(18,0) NOT NULL ENABLE, "HIST_PROCESS_ID" NUMBER(9,0) NOT NULL ENABLE, "HIST_POSITION_ID" NUMBER(9,0) NOT NULL ENABLE, "HIST_ORDER_STATE_ID" NUMBER(9,0) NOT NULL ENABLE, "HIST_ORDER_STATUS_ID" NUMBER(9,0) NOT NULL ENABLE, "HIST_REPORTING_STATUS_ID" NUMBER(9,0) NOT NULL ENABLE, "
ORA-39083: Object type TABLE failed to create with error:
ORA-01918: user 'ORDERMGMT' does not exist
Failing sql is:
CREATE TABLE "ORDERMGMT"."OM_HIST$ORDER_STATE" ("ORDER_SEQ_ID" NUMBER(18,0) NOT NULL ENABLE, "HIST_STATE_SEQ_ID" NUMBER(18,0) NOT NULL ENABLE, "STATE_ID" NUMBER(9,0) NOT NULL ENABLE, "ORD_TXN_START_DATE" DATE NOT NULL ENABLE, "ORD_TXN_COMPLETION_DATE" DATE NOT NULL ENABLE, "ORD_TXN_AUTHOR" VARCHAR2(30 CHAR), "ORD_TXN_REASON" VARCHAR2(1000)) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 STO
ORA-39083: Object type TABLE failed to create with error:
ORA-01918: user 'ORDERMGMT' does not exist
Failing sql is:
CREATE TABLE "ORDERMGMT"."OM_ORDER_FLOW_REMARKS" ("ORDER_SEQ_ID" NUMBER(18,0) NOT NULL ENABLE, "HIST_SEQ_ID" NUMBER(18,0) NOT NULL ENABLE, "ORDER_FLOW_REMARK_ID" NUMBER(9,0) NOT NULL ENABLE, "USERNAME" VARCHAR2(32 CHAR) NOT NULL ENABLE, "REMARKS_TYPE_ID" NUMBER(9,0) NOT NULL ENABLE, "REMARK_DATE" DATE DEFAULT NULL NOT NULL ENABLE, "REMARK" VARCHAR2(4000) NOT NULL ENABLE, "CARTRIDGE_ID" NUMB
ORA-39083: Object type TABLE failed to create with error:
ORA-01918: user 'ORDERMGMT' does not exist
Failing sql is:
CREATE TABLE "ORDERMGMT"."OM_HIST$FALLOUT_NODE_INSTANCE" ("ORDER_SEQ_ID" NUMBER(18,0) NOT NULL ENABLE, "COMPENSATION_ID" NUMBER(18,0) NOT NULL ENABLE, "ORDER_NODE_INDEX" NUMBER(18,0) NOT NULL ENABLE, "HIST_SEQ_ID" NUMBER(18,0) NOT NULL ENABLE, "NODE_VALUE_NUM" NUMBER, "NODE_VALUE_TEXT" VARCHAR2(1000 CHAR)) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 STORAGE( BUFFER_POOL DEFAULT) TABLESPA
ORA-39083: Object type TABLE failed to create with error:
ORA-01918: user 'ORDERMGMT' does not exist
Failing sql is:
CREATE TABLE "ORDERMGMT"."OM_HIST$STATUS_MAP" ("ORDER_SEQ_ID" NUMBER(18,0) NOT NULL ENABLE, "HIST_MAP_SEQ_ID" NUMBER(18,0) NOT NULL ENABLE, "HIST_SEQ_ID" NUMBER(18,0) NOT NULL ENABLE, "PARENT_HIST_SEQ_ID" NUMBER(18,0) NOT NULL ENABLE, "SUBPROCESS_STATUS_ID" NUMBER(9,0) NOT NULL ENABLE, "TASK_TRANS_TYPE" CHAR(1) NOT NULL ENABLE, "TERMINATE_CHILDREN" VARCHAR2(50) NOT NULL ENABLE, "REPORTING_S
ORA-39083: Object type TABLE failed to create with error:
ORA-01918: user 'ORDERMGMT' does not exist
Failing sql is:
CREATE TABLE "ORDERMGMT"."OM_ORDER_NODE_ANCESTRY" ("ORDER_SEQ_ID" NUMBER(18,0) NOT NULL ENABLE, "ORDER_NODE_ID" NUMBER(9,0) NOT NULL ENABLE, "ORDER_NODE_TYPE" VARCHAR2(20) NOT NULL ENABLE, "ORDER_NODE_INDEX" NUMBER(18,0) NOT NULL ENABLE, "DEPTH" NUMBER(9,0) NOT NULL ENABLE, "ANCESTOR_NODE_ID" NUMBER(9,0) NOT NULL ENABLE, "ANCESTOR_NODE_TYPE" VARCHAR2(20) NOT NULL ENABLE, "ANCESTOR_NODE_INDE
ORA-39083: Object type TABLE failed to create with error:
ORA-01918: user 'ORDERMGMT' does not exist
Failing sql is:
CREATE TABLE "ORDERMGMT"."OM_ORDER_STATE_PENDING" ("ORDER_SEQ_ID" NUMBER(18,0) NOT NULL ENABLE, "ORD_TARGET_STATE_ID" NUMBER(9,0) NOT NULL ENABLE, "ORD_TXN_START_DATE" DATE NOT NULL ENABLE, "ORD_TXN_GRACE_INTERVAL" NUMBER(19,0) NOT NULL ENABLE, "ORD_TXN_EVENT_DATE" DATE NOT NULL ENABLE, "ORD_TXN_EVENT_INTERVAL" NUMBER(19,0) NOT NULL ENABLE) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 STO
ORA-39083: Object type TABLE failed to create with error:
ORA-01918: user 'ORDERMGMT' does not exist
Failing sql is:
CREATE TABLE "ORDERMGMT"."OM_HIST$ORDER_INSTANCE" ("ORDER_SEQ_ID" NUMBER(18,0) NOT NULL ENABLE, "ORDER_NODE_INDEX" NUMBER(18,0) NOT NULL ENABLE, "H$INST_SEQ_ID" NUMBER(18,0) NOT NULL ENABLE, "ORDER_NODE_TYPE" VARCHAR2(20) NOT NULL ENABLE, "ORDER_NODE_ID" NUMBER(9,0) NOT NULL ENABLE, "DATA_DICTIONARY_ID" NUMBER(9,0) NOT NULL ENABLE, "ORDER_TYPE_ID" NUMBER(9,0) NOT NULL ENABLE, "ORDER_SOURCE_
ORA-39083: Object type TABLE failed to create with error:
ORA-01918: user 'ORDERMGMT' does not exist
Failing sql is:
CREATE TABLE "ORDERMGMT"."OM_HIST$NOTIFICATION" ("ORDER_SEQ_ID" NUMBER(18,0) NOT NULL ENABLE, "NOTIFICATION_ID" NUMBER(9,0) NOT NULL ENABLE, "NOTIFICATION_HIST_SEQ_ID" NUMBER(18,0) NOT NULL ENABLE, "ORDER_HIST_SEQ_ID" NUMBER(18,0) NOT NULL ENABLE, "ACTION" CHAR(1), "TIMESTAMP" DATE, "USERNAME" VARCHAR2(32 CHAR), "MESSAGE" VARCHAR2(4000), "CARTRIDGE_ID" NUMBER(6,0) NOT NULL ENABLE) PCTFREE 1
ORA-39083: Object type TABLE failed to create with error:
ORA-01918: user 'ORDERMGMT' does not exist
Failing sql is:
CREATE TABLE "ORDERMGMT"."OM_JMS_EVENT" ("EVENT_ID" NUMBER(9,0) NOT NULL ENABLE, "POOLER_ID" NUMBER(6,0) NOT NULL ENABLE, "EVENT_TYPE" CHAR(1) NOT NULL ENABLE, "ORDER_SEQ_ID" NUMBER(18,0) NOT NULL ENABLE, "ORDER_HIST_ID" NUMBER(18,0) NOT NULL ENABLE, "NOTIFICATION_ID" NUMBER(9,0) NOT NULL ENABLE, "NOTIFICATION_HIST_ID" NUMBER(18,0) NOT NULL ENABLE, "EVENT_DEF_ID" NUMBER(9,0) NOT NULL ENABLE
ORA-39083: Object type TABLE failed to create with error:
ORA-01918: user 'ORDERMGMT' does not exist
..
...
... etc etc etc
Job "SCOTT"."SYS_IMPORT_TABLESPACE_01" completed with 1480 error(s) at 11:59:20
-
Can you see the offending user?... if not I would pre create account ORDERMGMT then try again.
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|