Hi,
we want to upgrade to 2.4 and wanted to test this on a non production ISE(unlicensed).
The URT fails at 75% of the "Clone config database" with "Failed (Import onto clones database failed)
Logs show ok here:
Job "CEPM"."SYS_EXPORT_SCHEMA_02" successfully completed at Tue Apr 10 14:41:44 2018 elapsed 0 00:02:09
but failed:
...
. . imported "CEPM"."UPSWORKFLOW_ROLES" 0 KB 0 rows
. . imported "CEPM"."WCS_SSO_TOKEN" 0 KB 0 rows
Processing object type SCHEMA_EXPORT/TABLE/GRANT/OWNER_GRANT/OBJECT_GRANT
Processing object type SCHEMA_EXPORT/TABLE/COMMENT
Processing object type SCHEMA_EXPORT/TABLE/INDEX/INDEX
Processing object type SCHEMA_EXPORT/TABLE/INDEX/FUNCTIONAL_INDEX/INDEX
Processing object type SCHEMA_EXPORT/TABLE/CONSTRAINT/CONSTRAINT
ORA-31684: Object type CONSTRAINT:"CEPM"."SYS_C0015154" already exists
ORA-31684: Object type CONSTRAINT:"CEPM"."SYS_C0015147" already exists
Processing object type SCHEMA_EXPORT/TABLE/CONSTRAINT/REF_CONSTRAINT
Job "CEPM"."SYS_IMPORT_SCHEMA_01" completed with 2 error(s) at Tue Apr 10 14:43:50 2018 elapsed 0 00:01:56
same but other log:
Tue Apr 10 14:43:17 CEST 2018 : . . imported "CEPM"."UPSWORKFLOW_ROLES" 0 KB 0 rows
Tue Apr 10 14:43:17 CEST 2018 : . . imported "CEPM"."WCS_SSO_TOKEN" 0 KB 0 rows
Tue Apr 10 14:43:17 CEST 2018 : Processing object type SCHEMA_EXPORT/TABLE/GRANT/OWNER_GRANT/OBJECT_GRANT
Tue Apr 10 14:43:17 CEST 2018 : Processing object type SCHEMA_EXPORT/TABLE/COMMENT
Tue Apr 10 14:43:17 CEST 2018 : Processing object type SCHEMA_EXPORT/TABLE/INDEX/INDEX
Tue Apr 10 14:43:34 CEST 2018 : Processing object type SCHEMA_EXPORT/TABLE/INDEX/FUNCTIONAL_INDEX/INDEX
Tue Apr 10 14:43:35 CEST 2018 : Processing object type SCHEMA_EXPORT/TABLE/CONSTRAINT/CONSTRAINT
Tue Apr 10 14:43:43 CEST 2018 : ORA-31684: Object type CONSTRAINT:"CEPM"."SYS_C0015154" already exists
Tue Apr 10 14:43:43 CEST 2018 : ORA-31684: Object type CONSTRAINT:"CEPM"."SYS_C0015147" already exists
Tue Apr 10 14:43:43 CEST 2018 : Processing object type SCHEMA_EXPORT/TABLE/CONSTRAINT/REF_CONSTRAINT
Tue Apr 10 14:43:53 CEST 2018 : Job "CEPM"."SYS_IMPORT_SCHEMA_01" completed with 2 error(s) at Tue Apr 10 14:43:50 2018 elapsed 0 00:01:56
and last:
===========================================================
Tue Apr 10 14:39:41 2018
TABLE SYS.WRP$_REPORTS: ADDED INTERVAL PARTITION SYS_P1008 (3022) VALUES LESS THAN (TO_DATE(' 2018-04-11 01:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
TABLE SYS.WRP$_REPORTS_DETAILS: ADDED INTERVAL PARTITION SYS_P1009 (3022) VALUES LESS THAN (TO_DATE(' 2018-04-11 01:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
TABLE SYS.WRP$_REPORTS_TIME_BANDS: ADDED INTERVAL PARTITION SYS_P1012 (3021) VALUES LESS THAN (TO_DATE(' 2018-04-10 01:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
Tue Apr 10 14:41:53 2018
DM00 started with pid=50, OS id=27934, job CEPM.SYS_IMPORT_SCHEMA_01
Tue Apr 10 14:41:56 2018
DW00 started with pid=51, OS id=27966, wid=1, job CEPM.SYS_IMPORT_SCHEMA_01
Tue Apr 10 14:42:18 2018
Thread 1 cannot allocate new log, sequence 2
Private strand flush not complete
Current log# 1 seq# 1 mem# 0: /opt/oracle/base/oradata/cpm11/redo01.log
Tue Apr 10 14:42:21 2018
Thread 1 advanced to log sequence 2 (LGWR switch)
Current log# 2 seq# 2 mem# 0: /opt/oracle/base/oradata/cpm11/redo02.log
Tue Apr 10 14:42:54 2018
Thread 1 advanced to log sequence 3 (LGWR switch)
Current log# 3 seq# 3 mem# 0: /opt/oracle/base/oradata/cpm11/redo03.log
Tue Apr 10 14:43:19 2018
The value (159) of MAXTRANS parameter ignored.
The value (159) of MAXTRANS parameter ignored.
The value (167) of MAXTRANS parameter ignored.
The value (167) of MAXTRANS parameter ignored.
The value (167) of MAXTRANS parameter ignored.
The value (167) of MAXTRANS parameter ignored.
Tue Apr 10 14:43:34 2018
The value (167) of MAXTRANS parameter ignored.
The value (167) of MAXTRANS parameter ignored.
The value (167) of MAXTRANS parameter ignored.
The value (167) of MAXTRANS parameter ignored.
The value (167) of MAXTRANS parameter ignored.
The value (167) of MAXTRANS parameter ignored.
The value (167) of MAXTRANS parameter ignored.
The value (167) of MAXTRANS parameter ignored.
The value (167) of MAXTRANS parameter ignored.
The value (167) of MAXTRANS parameter ignored.
The value (167) of MAXTRANS parameter ignored.
The value (167) of MAXTRANS parameter ignored.
The value (167) of MAXTRANS parameter ignored.
The value (167) of MAXTRANS parameter ignored.
The value (167) of MAXTRANS parameter ignored.
The value (167) of MAXTRANS parameter ignored.
Tue Apr 10 14:43:42 2018
Thread 1 cannot allocate new log, sequence 4
Checkpoint not complete
Current log# 3 seq# 3 mem# 0: /opt/oracle/base/oradata/cpm11/redo03.log
Tue Apr 10 14:43:48 2018
Thread 1 advanced to log sequence 4 (LGWR switch)
Current log# 1 seq# 4 mem# 0: /opt/oracle/base/oradata/cpm11/redo01.log
Tue Apr 10 14:43:54 2018
Shutting down instance (immediate)
Stopping background process SMCO
Shutting down instance: further logons disabled
Stopping background process CJQ0
Stopping background process MMNL
Stopping background process MMON
License high water mark = 43
Tue Apr 10 14:43:57 2018
All dispatchers and shared servers shutdown
ALTER DATABASE CLOSE NORMAL
Tue Apr 10 14:43:58 2018
Stopping Emon pool
Tue Apr 10 14:43:58 2018
SMON: disabling tx recovery
Stopping Emon pool
Tue Apr 10 14:43:58 2018
SMON: disabling cache recovery
Shutting down archive processes
Archiving is disabled
Tue Apr 10 14:43:58 2018
Thread 1 closed at log sequence 4
Successful close of redo thread 1
Completed: ALTER DATABASE CLOSE NORMAL
ALTER DATABASE DISMOUNT
Shutting down archive processes
Archiving is disabled
Completed: ALTER DATABASE DISMOUNT
Tue Apr 10 14:43:59 2018
ARCH: Archival disabled due to shutdown: 1089
Shutting down archive processes
Archiving is disabled
ARCH: Archival disabled due to shutdown: 1089
Shutting down archive processes
Archiving is disabled
Tue Apr 10 14:44:01 2018
Stopping background process VKTM
Tue Apr 10 14:44:10 2018
Instance shutdown complete
hope someone can help troubleshooting.
BR!
