Errors Running The Upgrade Assistant (ua) For Upgrading from 11g To 12c : MDS-92001: The upgrade is not supported from Oracle Metadata Services schema version / UPGCMP-05418: Oracle WebCenter Portal schema WEBCENTER does not contain the required indexes
(Doc ID 2697546.1)
Last updated on OCTOBER 03, 2023
Applies to:
Oracle WebCenter Portal - Version 11.1.1.8.8 and laterInformation in this document applies to any platform.
Symptoms
ACTUAL BEHAVIOR
Running the upgrade assistant in readiness check mode for upgrading from 11.1.1.8 to 12.2.1.3 fails with the following errors:
ERROR
Oracel WebCenter Portal: Spaces and Services [<SCHEMA_PREFIX>_WEBCENTER] - failed
Oracle Metadata Services
MDS-92001: The upgrade is not supported from Oracle Metadata Services schema version of 11.1.1.6.0
Cause: An unsupported base schema version has being upgraded.
Action: Refer to the Oracle Metadata Services Upgrade Guide for supported versions to upgrade.
Oracle WebCenter Portal: Spaces and Services
UPGCMP-05418: Oracle WebCenter Portal schema WEBCENTER does not contain the required indexes.
Cause: The schema does not contain the indexes which are required to be present before upgrade.
Action: Ensure all required indexes are present before upgrade.
The upgrade assistant log shows the following errors:
[<DATE_TIME>] [MDS] [ERROR] [MDS-92001] [upgrade.MDS.SCHEMA_UPGRADE] [tid: 83] [ecid: <ECID>,0] The upgrade is not supported from Oracle Metadata Services schema version of 11.1.1.6.0.
[<DATE_TIME>] [MDS] [ERROR] [] [upgrade.MDS.SCHEMA_UPGRADE] [tid: 83] [ecid: <ECID>,0] Cause: An unsupported base schema version was being upgraded.
[<DATE_TIME>] [MDS] [ERROR] [] [upgrade.MDS.SCHEMA_UPGRADE] [tid: 83] [ecid: <ECID>,0] Action: Refer to the Oracle Metadata Services Upgrade Guide for supported versions to upgrade.
[<DATE_TIME>] [MDS] [NOTIFICATION] [] [upgrade.MDS.SCHEMA_UPGRADE] [tid: 83] [ecid: <ECID>,0] VERSION Schema <SCHEMA_PREFIX>_MDS is currently at unsupported version 11.1.1.6.0. No readiness checks will be performed.
[<DATE_TIME>] [Framework] [NOTIFICATION] [] [upgrade.Framework] [tid: 83] [ecid: <ECID>,0] Finished readiness check of Oracle Metadata Services with status: FAILURE.
[<DATE_TIME>] [Framework] [NOTIFICATION] [] [upgrade.Framework] [tid: 83] [ecid: <ECID>,0] Component ID=MDS, Schema=<SCHEMA_PREFIX>_MDS, Schema version=11.1.1.6.0, Status=VALID, Upgraded=false
[<DATE_TIME>] [Framework] [NOTIFICATION] [] [upgrade.Framework] [tid: 83] [ecid: <ECID>,0] Finished readiness check of MDS.SCHEMA_UPGRADE with status: FAILURE.
...
[<DATE_TIME>] [WEBCENTER] [NOTIFICATION] [] [upgrade.WEBCENTER.WC1] [tid: 83] [ecid: <ECID>,0] Starting schema test: TEST_REQUIRED_TABLES Test that the schema contains all the required tables
[<DATE_TIME>] [WEBCENTER] [NOTIFICATION] [] [upgrade.WEBCENTER.WC1] [tid: 83] [ecid: <ECID>,0] Run standard query: queryTableNames, Schema tag: WEBCENTER, Schema name: <SCHEMA_PREFIX>_WEBCENTER, Object: null
[<DATE_TIME>] [WEBCENTER] [NOTIFICATION] [] [upgrade.WEBCENTER.WC1] [tid: 83] [ecid: <ECID>,0] List of database TABLE objects for user: <SCHEMA_PREFIX>_WEBCENTER
[<DATE_TIME>] [WEBCENTER] [NOTIFICATION] [] [upgrade.WEBCENTER.WC1] [tid: 83] [ecid: <ECID>,0] Completed schema test: TEST_REQUIRED_TABLES --> Test that the schema contains all the required tables +++ PASS
[<DATE_TIME>] [WEBCENTER] [NOTIFICATION] [] [upgrade.WEBCENTER.WC1] [tid: 83] [ecid: <ECID>,0] Starting index test for table WC_AS_CUSTATTR: TEST_REQUIRED_INDEXES --> Test that the table contains all the required indexes
[<DATE_TIME>] [WEBCENTER] [NOTIFICATION] [] [upgrade.WEBCENTER.WC1] [tid: 83] [ecid: <ECID>,0] Run standard query: queryIndexNames, Schema tag: WEBCENTER, Schema name: <SCHEMA_PREFIX>_WEBCENTER, Object: WC_AS_CUSTATTR
[<DATE_TIME>] [WEBCENTER] [NOTIFICATION] [] [upgrade.WEBCENTER.WC1] [tid: 83] [ecid: <ECID>,0] List of database INDEX objects for user: <SCHEMA_PREFIX>_WEBCENTER
[<DATE_TIME>] [WEBCENTER] [NOTIFICATION] [] [upgrade.WEBCENTER.WC1] [tid: 83] [ecid: <ECID>,0] EXCEPTION Table is missing a required index: WC_AS_CUSTATTR_FK
[<DATE_TIME>] [WEBCENTER] [NOTIFICATION] [] [upgrade.WEBCENTER.WC1] [tid: 83] [ecid: <ECID>,0] EXCEPTION Table is missing a required index: WC_AS_CUSTATTR_NI
[<DATE_TIME>] [WEBCENTER] [NOTIFICATION] [] [upgrade.WEBCENTER.WC1] [tid: 83] [ecid: <ECID>,0] Completed index test for table WC_AS_CUSTATTR: TEST_REQUIRED_INDEXES --> Test that the table contains all the required indexes +++ FAIL
[<DATE_TIME>] [WEBCENTER] [NOTIFICATION] [] [upgrade.WEBCENTER.WC1] [tid: 83] [ecid: <ECID>,0] INFO Required indexes are not present, schema: WEBCENTER table: WC_AS_CUSTATTR
[<DATE_TIME>] [WEBCENTER] [ERROR] [UPGCMP-05418] [upgrade.WEBCENTER.WC1] [tid: 83] [ecid: <ECID>,0] Oracle WebCenter Portal schema WEBCENTER does not contain the required indexes.
[<DATE_TIME>] [WEBCENTER] [ERROR] [] [upgrade.WEBCENTER.WC1] [tid: 83] [ecid: <ECID>,0] Cause: The schema does not contain the indexes which are required to be present before upgrade.
[<DATE_TIME>] [WEBCENTER] [ERROR] [] [upgrade.WEBCENTER.WC1] [tid: 83] [ecid: <ECID>,0] Action: Ensure all required indexes are present before upgrade.
[<DATE_TIME>] [Framework] [NOTIFICATION] [] [upgrade.Framework] [tid: 83] [ecid: <ECID>,0] Finished readiness check of Oracle WebCenter Portal: Spaces and Services with status: FAILURE.
[<DATE_TIME>] [Framework] [NOTIFICATION] [] [upgrade.Framework] [tid: 83] [ecid: <ECID>,0] Component ID=WEBCENTER, Schema=<SCHEMA_PREFIX>_WEBCENTER, Schema version=11.1.1.4.0, Status=VALID, Upgraded=false
[<DATE_TIME>] [Framework] [NOTIFICATION] [] [upgrade.Framework] [tid: 83] [ecid: <ECID>,0] Finished readiness check of WEBCENTER.WC1 with status: FAILURE.
EXPECTED BEHAVIOR
Expected the upgrade assistant t o run without issues.
STEPS
The issue can be reproduced at will with the following steps:
- Run the upgrade assistant in readiness mode as follows:
./ua –readiness check - The above will fail with the above errors.
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Symptoms |
Cause |
Solution |