Skip to Main Content

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!

Enterprise manager platform migration from HP-UX to linux

2886923May 30 2018 — edited May 30 2018

Hi, community

i am facing a problem while importing sysman schema in the database(migrated database platform from hp-ux to linux)

database version is 12.2.0.1, platform -linux, i am getting following errors while importing

KUP-11007: conversion error loading table "SYSMAN"."EM_NOTIFY_QTABLE"

ORA-22337: the type of accessed object has been evolved

KUP-11009: data for row: SYS_NC00058$ : 0X'8801FE00000A651B1300050000000000000000000000000000'

Failing sql is:

ALTER TABLE "SYSMAN"."EM_JOB_TYPE_STEP_CREDS" ADD CONSTRAINT "EM_JOB_TYPE_STEP_CREDS_FK2" FOREIGN KEY ("JOB_TYPE_ID", "USAGE_REF") REFERENCES "SYSMAN"."EM_JOB_TYPE_CREDS_INFO" ("JOB_TYPE_ID", "USAGE") ENABLE

ORA-39083: Object type REF_CONSTRAINT:"SYSMAN"."MGMT_NOTIFY_DEVICE_PARAMS_FK1" failed to create with error:

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

ORA-39082: Object type PACKAGE:"SYSMAN"."EM_JOBTYPE" created with compilation warnings

ORA-39082: Object type PACKAGE:"SYSMAN"."MGMT_JOB_UI" created with compilation warnings

ORA-39082: Object type PACKAGE:"SYSMAN"."MGMT_LOCK_UTIL" created with compilation warnings

ORA-39082: Object type FUNCTION:"SYSMAN"."GETEMKEY" created with compilation warnings

ORA-39082: Object type FUNCTION:"SYSMAN"."UNPAD" created with compilation warnings

need help,thanks in advance

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 27 2018
Added on May 30 2018
5 comments
486 views