Some background:
Solaris 10 SPARC 64bits
Oracle Database 10.2.0.1
Upgrading to same OS on different server
I installed Oracle 11.1.0.7 on the new server and started the new database and it's listener.
The new database has some of the same tablespaces that are still on the old database, like system, undo, sysaux, users, example. So you may see "already exists" in the error below. And the error you see below is partly only from top, middle and last part of the output.
Problem:
We are upgrading one of our test databases base on Export/Import Datapump method. We chose this method to certify our own spicification. I know there are lots of ways to upgrade, but please keep to this only.
Here is the Export script:
expdp system/password full=Y directory=csappdb_dir parallel=3 dumpfile=CSAPPDB_%U.dmp version=10.2.0.1.0 logfile=CSAPPDB.log
And here is the import script:
impdp system/password full=Y directory=CSAPPDB_DIR parallel=3 dumpfile=CSAPPDB_%U.dmp version=10.2.0.1.0 logfile=CSAPPDB.log
For your information, I listed the problem before when the export completed without error and started to import flawlessly and thought I got it right this time. I histily marked the previous thread "answered", so please disregard that and forgive me.
Now here is the error I am getting from the import datapump. Can somebody see where I am getting this wrong and give me some directiion?
Thanks
A-31684: Object type SYNONYM:"PUBLIC"."TEMP$LOB" already exists
Processing object type DATABASE_EXPORT/SCHEMA/SYNONYM
ORA-31684: Object type SYNONYM:"SYSTEM"."SYSCATALOG" already exists
ORA-31684: Object type SYNONYM:"SYSTEM"."CATALOG" already exists
ORA-31684: Object type SYNONYM:"SYSTEM"."TAB" already exists
ORA-31684: Object type SYNONYM:"SYSTEM"."COL" already exists
ORA-31684: Object type SYNONYM:"SYSTEM"."TABQUOTAS" already exists
ORA-31684: Object type SYNONYM:"SYSTEM"."SYSFILES" already exists
ORA-31684: Object type SYNONYM:"SYSTEM"."PUBLICSYN" already exists
ORA-31684: Object type SYNONYM:"SYSTEM"."PRODUCT_USER_PROFILE" already exists
ORA-31684: Object type SYNONYM:"BI"."CHANNELS" already exists
ORA-31684: Object type SYNONYM:"BI"."COUNTRIES" already exists
ORA-31684: Object type SYNONYM:"BI"."TIMES" already exists
ORA-31684: Object type SYNONYM:"BI"."COSTS" already exists
ORA-31684: Object type SYNONYM:"BI"."CUSTOMERS" already exists
ORA-31684: Object type SYNONYM:"BI"."PRODUCTS" already exists
ORA-31684: Object type SYNONYM:"BI"."PROMOTIONS" already exists
ORA-31684: Object type SYNONYM:"BI"."SALES" already exists
ORA-31684: Object type TYPE:"SYSMAN"."MGMT_JOB_TARGET_LIST_ARRAY" already exists
ORA-31684: Object type TYPE:"SYSMAN"."MGMT_JOB_PURGE_CRITERION_LIST" already exists
ORA-31684: Object type TYPE:"SYSMAN"."MGMT_JOB_PARAMSRC_ARRAY" already exists
ORA-31684: Object type TYPE:"SYSMAN"."SMP_EMD_COL_DEF_ARRAY_ARRAY" already exists
ORA-31684: Object type TYPE:"SYSMAN"."MGMT_CRED_TYPE_COL_RECORD" already exists
ORA-31684: Object type TYPE:"SYSMAN"."MGMT_CRED_RECORD" already exists
ORA-31684: Object type TYPE:"SYSMAN"."MGMT_DELTA_ENTRIES" already exists
ORA-31684: Object type TYPE:"SYSMAN"."MGMT_DELTA_QUERIES" already exists
ORA-31684: Object type TYPE:"SYSMAN"."MGMT_DELTA_RECORDER" already exists
ORA-31684: Object type TYPE:"SYSMAN"."ECM_POLICY_RULE" already exists
ORA-31684: Object type TYPE:"SYSMAN"."MGMT_JOB_STEP_RECORD" already exists
ORA-31684: Object type TYPE:"SYSMAN"."MGMT_CRED_TYPE_COL_ARRAY" already exists
ORA-31684: Object type TYPE:"SYSMAN"."MGMT_TARGET_CRED_RECORD" already exists
ORA-31684: Object type TYPE:"SYSMAN"."MGMT_CLUSTER_CRED_RECORD" already exists
ORA-31684: Object type TYPE:"SYSMAN"."MGMT_HOST_CRED_RECORD" already exists
ORA-31684: Object type TYPE:"SYSMAN"."MGMT_ENTERPRISE_CRED_RECORD" already exists
ORA-31684: Object type TYPE:"SYSMAN"."MGMT_JOB_CRED_RECORD" already exists
ORA-31684: Object type TYPE:"SYSMAN"."MGMT_CONTAINER_CRED_RECORD" already exists
ORA-31684: Object type TYPE:"SYSMAN"."MGMT_DELTA_ENTRY_RECORDER" already exists
ORA-31684: Object type TYPE:"SYSMAN"."MGMT_HISTORY_ENTRY_RECORDER" already exists
ORA-31684: Object type TYPE:"SYSMAN"."MGMT_JOB_STEP_LIST" already exists
ORA-31684: Object type TYPE:"SYSMAN"."MGMT_TARGET_CRED_ARRAY" already exists
ORA-31684: Object type TYPE:"SYSMAN"."MGMT_CLUSTER_CRED_ARRAY" already exists
ORA-31684: Object type TYPE:"SYSMAN"."MGMT_HOST_CRED_ARRAY" already exists
ORA-31684: Object type TYPE:"SYSMAN"."MGMT_ENTERPRISE_CRED_ARRAY" already exists
ORA-31684: Object type TYPE:"SYSMAN"."MGMT_JOB_CRED_ARRAY" already exists
ORA-31684: Object type TYPE:"SYSMAN"."MGMT_CONTAINER_CRED_ARRAY" already exists
Processing object type DATABASE_EXPORT/SYSTEM_PROCOBJACT/PRE_SYSTEM_ACTIONS/PROCACT_SYSTEM
ORA-39083: Object type PROCACT_SYSTEM failed to create with error:
ORA-20000: Incompatible version of Workspace Manager Installed
Failing sql is:
BEGIN
declare ver varchar2(100) ; dummy integer; compile_exception EXCEPTION; PRAGMA EXCEPTION_INIT(compile_exception, -06550); invalid_table EXCEPTION; PRAGMA EXCEPTION_INIT(invalid_table, -00942); procedure createErrorProc is begin execute immediate 'create or replace function system.wm$_check_install return boolean is begin return true ; end;' ; end ; begin
Processing object type DATABASE_EXPORT/SYSTEM_PROCOBJACT/POST_SYSTEM_ACTIONS/PROCACT_SYSTEM
RIMARYKEY" skipped, base object type TABLE:"QC10MIGRATION_GCSS710_SEQ_DB"."TESTCYCL" creation failed
ORA-39112: Dependent object type CONSTRAINT:"QC10MIGRATION_GCSS710_SEQ_DB"."TA_PRIMARYKEY" skipped, base object type TABLE:"QC10MIGRATION_GCSS710_SEQ_DB"."TO_ALERT" creation failed
ORA-39112: Dependent object type CONSTRAINT:"QC10MIGRATION_GCSS710_SEQ_DB"."TK_PRIMARYKEY" skipped, base object type TABLE:"QC10MIGRATION_GCSS710_SEQ_DB"."TOKENS" creation failed
ORA-39112: Dependent object type CONSTRAINT:"QC10MIGRATION_GCSS710_SEQ_DB"."TR_PRIMARYKEY" skipped, base object type TABLE:"QC10MIGRATION_GCSS710_SEQ_DB"."TRAN_RULES" creation failed
ORA-39112: Dependent object type CONSTRAINT:"QC10MIGRATION_GCSS710_SEQ_DB"."US_PRIMARYKEY" skipped, base object type TABLE:"QC10MIGRATION_GCSS710_SEQ_DB"."USERS" creation failed
ORA-39112: Dependent object type CONSTRAINT:"QC10MIGRATION_GCSS710_SEQ_DB"."VCCR_PRIMARYKEY" skipped, base object type TABLE:"QC10MIGRATION_GCSS710_SEQ_DB"."VC_CROS_REF" creation failed
ORA-39112: Dependent object type CONSTRAINT:"QC10MIGRATION_GCSS710_SEQ_DB"."VCDS_PRIMARYKEY" skipped, base object type TABLE:"QC10MIGRATION_GCSS710_SEQ_DB"."VC_DESSTEPS" creation failed
ORA-39112: Dependent object type CONSTRAINT:"QC10MIGRATION_GCSS710_SEQ_DB"."VCSP_PRIMARYKEY" skipped, base object type TABLE:"QC10MIGRATION_GCSS710_SEQ_DB"."VC_STEP_PARAMS" creation failed
ORA-39112: Dependent object type CONSTRAINT:"QC10MIGRATION_GCSS710_SEQ_DB"."VCTS_PRIMARYKEY" skipped, base object type TABLE:"QC10MIGRATION_GCSS710_SEQ_DB"."VC_TEST" creation failed
ORA-39112: Dependent object type CONSTRAINT:"QC10MIGRATION_GCSS710_SEQ_DB"."TVCI_PRIMARYKEY" skipped, base object type TABLE:"QC10MIGRATION_GCSS710_SEQ_DB"."TEST_VC_INFO" creation failed
ORA-39112: Dependent object type CONSTRAINT:"QC10MIGRATION_GCSS710_SEQ_DB"."VRCT_PRIMARYKEY" skipped, base object type TABLE:"QC10MIGRATION_GCSS710_SEQ_DB"."VER_CTRL" creation failed
ORA-39112: Dependent object type CONSTRAINT:"QC10MIGRATION_GCSS710_SEQ_DB"."LN_PRIMARYKEY" skipped, base object type TABLE:"QC10MIGRATION_GCSS710_SEQ_DB"."LINK" creation failed
ORA-39112: Dependent object type CONSTRAINT:"QC10MIGRATION_GCSS710_SEQ_DB"."SV_PRIMARYKEY" skipped, base object type TABLE:"QC10MIGRATION_GCSS710_SEQ_DB"."SERVICE" creation failed
ORA-39112: Dependent object type CONSTRAINT:"QC10MIGRATION_GCSS710_SEQ_DB"."SG_PRIMARYKEY" skipped, base object type TABLE:"QC10MIGRATION_GCSS710_SEQ_DB"."SERVICE_GROUP" creation failed
ORA-39112: Dependent object type CONSTRAINT:"QC10MIGRATION_GCSS710_SEQ_DB"."STG_PRIMARYKEY" skipped, base object type TABLE:"QC10MIGRATION_GCSS710_SEQ_DB"."SERVICE_TO_GROUP" creation failed
ORA-39112: Dependent object type CONSTRAINT:"QC10MIGRATION_GCSS710_SEQ_DB"."WO_PRIMARYKEY" skipped, base object type TABLE:"QC10MIGRATION_GCSS710_SEQ_DB"."WSDL_OPERATION" creation failed
ORA-39112: Dependent object type CONSTRAINT:"QC10MIGRATION_GCSS710_SEQ_DB"."OP_PRIMARYKEY" skipped, base object type TABLE:"QC10MIGRATION_GCSS710_SEQ_DB"."WSDL_OPERATION_PARAMS" creation failed
ORA-39112: Dependent object type CONSTRAINT:"QC10MIGRATION_GCSS710_SEQ_DB"."SC_PRIMARYKEY" skipped, base object type TABLE:"QC10MIGRATION_GCSS710_SEQ_DB"."SERVICE_CHANGE" creation failed
ORA-39112: Dependent object type CONSTRAINT:"QC10MIGRATION_GCSS710_SEQ_DB"."STR_PRIMARYKEY" skipped, base object type TABLE:"QC10MIGRATION_GCSS710_SEQ_DB"."SERVICE_TO_REQUIREMENT" creation failed
ORA-39112: Dependent object type CONSTRAINT:"QC10MIGRATION_GCSS710_SEQ_DB"."GTR_PRIMARYKEY" skipped, base object type TABLE:"QC10MIGRATION_GCSS710_SEQ_DB"."SERVICE_GROUP_TO_REQUIREMENT" creation failed
ORA-39112: Dependent object type CONSTRAINT:"QC10MIGRATION_GCSS710_SEQ_DB"."STT_PRIMARYKEY" skipped, base object type TABLE:"QC10MIGRATION_GCSS710_SEQ_DB"."SERVICE_TO_TEST" creation failed
ORA-39112: Dependent object type CONSTRAINT:"QC10MIGRATION_GCSS710_SEQ_DB"."GTT_PRIMARYKEY" skipped, base object type TABLE:"QC10MIGRATION_GCSS710_SEQ_DB"."SERVICE_GROUP_TO_TEST" creation failed
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/INDEX/STATISTICS/INDEX_STATISTICS
ORA-39083: Object type JOB failed to create with error:
ORA-00001: unique constraint (SYS.I_JOB_JOB) violated
Failing sql is:
BEGIN SYS.DBMS_IJOB.SUBMIT( JOB=> 1, LUSER=> 'SYSMAN', PUSER=> 'SYSMAN', CUSER=> 'SYSMAN', NEXT_DATE=> TO_DATE('2011-01-21 14:36:07', 'YYYY-MM-DD:HH24:MI:SS'), INTERVAL=> 'sysdate + 1 / (24 * 60)', BROKEN=> FALSE, WHAT=> 'EMD_MAINTENANCE.EXECUTE_EM_DBMS_JOB_PROCS();', NLSENV=> 'NLS_LANGUAGE=''AMERICAN'' NLS_TERRITORY=''AMERICA'' NLS_CURRENCY=''$'' NLS_ISO_CURRENCY=''AMERICA'' NLS
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/POST_INSTANCE/PROCACT_INSTANCE
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/POST_INSTANCE/PROCDEPOBJ
Processing object type DATABASE_EXPORT/SCHEMA/POST_SCHEMA/PROCOBJ
Processing object type DATABASE_EXPORT/SCHEMA/POST_SCHEMA/PROCACT_SCHEMA
Job "SYSTEM"."SYS_IMPORT_FULL_01" completed with 11888 error(s) at 16:51:41