OPSS - 11.1.1.8.8 To 12.2.1.1.0 Upgrade Fails On JDBC Component Schema Test - CFGWK-64216: Data source ORA-00942 select 1 from schema_version_registry where owner=(select user from dual) and mr_type='IAU_VIEWER' and version like '12.2.1%' (Doc ID 2186371.1)

Last updated on SEPTEMBER 28, 2016

Applies to:

Oracle Platform Security for Java - Version 12.2.1.1.0 and later
Information in this document applies to any platform.

Symptoms

During Webcenter upgrade from 11.1.1.8.8 to 12.2.1.1.0. Failes on OPSS Audit Viewer Schema, next message is reported:

 

Apparently OPSS and Audit database schemas (PTC_IAU, PTC_IAU_APPEND and PTC_IAU_VIEWER)were created with RDA 12c successfully.

 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms