While Upgrading WebCenter Portal the RCU and Upgrade Assistant (ua) are not taking the Existing OPSS schema if the OPSS Schema Prefix is not Same as Other Schemas (Doc ID 2672416.1)

Last updated on JUNE 07, 2024

Applies to:

Symptoms

ACTUAL BEHAVIOR

Attempting to upgrade from 11g to 12c with an OPSS schema prefix different then other schemas is causing the following issues:

• Running the RCU to create new schemas needed in 12c is trying to create a new OPSS schema with the same prefix as other schemas.
  
  
• If continue with the upgrade and try to run the upgrade assistance (ua), this tries to use all the new schema with the wrong PREFIX.

EXPECTED BEHAVIOR

Expected the upgrade will recognize and use the existing OPSS schema.

STEPS

Having the following use case:

• ALL domain schemas with exception of OPSS have the same prefix.
  e.g.: PREFIX1
  
  SO all other schemas look like: PREFIX1_webcenter, PREFIX1_MDS, ...
  
  
• The OPSS schema has a different prefix from all other schemas in the domain.
  e.g.: PREFIX2.
  
  So OPSS schema looks like: PREFIX2_OPSS 

1. Run the RCU to create the new schemas in preparation for the upgrade to 12c.
   Note here the RCU creates a new OPSS schema with same prefix as the other schemas in the domain (e.g. PREFIX1_OPSS).
   
   
   
2. Run the upgrade assistance (ua).
   Note here it takes the schema with same prefix as the other schemas in the domain (e.g. PREFIX1_OPSS).
   So it is ignoring the actual OPSS schema (PREFIX2_OPSS).

Changes

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.