Errors during Recreate of AQ Views During 11.2 to 12.1 RDBMS Upgrade of OIM Instance (Doc ID 2285205.1)

Last updated on JULY 11, 2017

Applies to:

Identity Manager - Version 11.1.2.2.0 and later
Oracle SOA Suite - Version 11.1.1.7.0 and later
Information in this document applies to any platform.

Symptoms

While upgrading a OIM Schema database from 11.2 to 12.1, the following errors are listed in the alert.log.
- NOTE: There are no errors logged in the DBUA tool.

a1102000.sql: create _L view or recreate base view failed for IDM_SOAINFRA.EDN_EVENT_QUEUE_TABLE
a1102000.sql: create _L view or recreate base view failed for IDM_SOAINFRA.EDN_OAOO_DELIVERY_TABLE
a1102000.sql: recreate deq view failed for IDM_SOAINFRA.EDN_EVENT_QUEUE_TABLE
a1102000.sql: recreate deq view failed for IDM_SOAINFRA.EDN_OAOO_DELIVERY_TABLE
a1102000.sql: recreate deq view failed for IDM_SOAINFRA.EDN_EVENT_QUEUE_TABLE
a1102000.sql: recreate deq view failed for IDM_SOAINFRA.EDN_OAOO_DELIVERY_TABLE

 

Changes

 DB Upgrade using Oracle's Database Upgrade Guide documentation.

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