2 Replies Latest reply: Aug 22, 2013 9:57 AM by mantis308 RSS

    upgrade from 10gr2 to 11gr2 - error during impdp

    mantis308

      Current server is 10gr2 on windows 2003 64 bit, running TDE. On the new server, I've copied the wallet to the new server, opened it using the alter system set encryption wallet open command. Verifed it's open. When I run impdp on the 11gr2 server, I get a ton of these errors:

       

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

      ORA-28374: typed master key not found in wallet

      Failing sql is:

      CREATE INDEX "BANK"."RTXN_DX29" ON "BANK"."RTXN" ("RTXNTYPCD") PCTFREE 10 INITRANS 2 MAXTRANS 255  STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "INDEXES" PARALLEL 12

       

      Followed by a ton of errors like this

       

      Processing object type DATABASE_EXPORT/SCHEMA/TABLE/CONSTRAINT/REF_CONSTRAINT

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

      ORA-02270: no matching unique or primary key for this column-list

      Failing sql is:

      ALTER TABLE "BANK"."ACCT1099M" ADD CONSTRAINT "ACCT1099M004" FOREIGN KEY ("PARENTACCTNBR", "PARENTRTXNNBR") REFERENCES "BANK"."RTXN" ("ACCTNBR", "RTXNNBR") ENABLE NOVALIDATE

       

      Any ideas? I'm doing my practice runs for the real upgrade, which is this weekend, and I've had several successful upgrades, but this time I can't get past this error.