OPSS - IAU Schema Failures When Running UA Readiness Mode for SOA 12.2.1.1 Upgrade from 12.1.3: Completed index test for table IAU_COMMON: TEST_REQUIRED_INDEXES --> Test that the table contains all the required indexes +++ FAIL (Doc ID 2208624.1)

Last updated on DECEMBER 06, 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

While running the UA readiness mode for upgrade from SOA/BPM 12.1.3 to 12.2.1.1.0, failures occur related to indexes, synonyms and privileges for the IAU_  related tables:

Upgrade readiness check completed with one or more errors.

This readiness check report was created on Tue Oct 04 13:19:35 MST 2016
Log file is located at: /tmp/ua12clogs/ua2016-10-04-12-52-05PM.log
Readiness Check Report File: /tmp/ua12clogs/readiness2016-10-04-13-19-35PM.txt
Domain Directory: /u01/app/weblogic/mw/admin/soapatch_domain/aserver/soapatch_domain

Starting readiness check of components.

Oracle Audit Services
  Starting readiness check of Oracle Audit Services.
    Schema User Name: PATCH_IAU
    Database Type: Oracle Database
    Database Connect String: <host>:<port>/<sid>
    VERSION Schema PATCH_IAU is currently at version 12.1.3.0.0.  Readiness checks will now be performed.
  Starting schema test:  TEST_DATABASE_VERSION  Test that the database server version number is supported for upgrade
    INFO   Database product version: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

...<snip>...

Following are all the entries with "fail" status in it:

Line 151:    Completed index test for table IAU_COMMON: TEST_REQUIRED_INDEXES --> Test that the table contains all the required indexes +++ FAIL
Line 243:    Completed schema test: PRIVILEGES_TEST --> Test that the audit schema has appropriate system and object privileges +++ FAIL
Line 258:    Completed schema test: SYNONYMS_TEST --> Test that the audit schema required synonyms are present +++ FAIL
Line 259:    Finished readiness check of Oracle Audit Services with status: FAILURE.
Line 1455:    Completed schema test: TEST_ENOUGH_TABLESPACE --> Test that the schema tablespaces automatically extend if full +++ FAIL
Line 1464:    Finished readiness check of Oracle Metadata Services with status: FAILURE.
Line 2129:    Completed schema test: TEST_ENOUGH_TABLESPACE --> Test that the schema tablespaces automatically extend if full +++ FAIL
Line 2134:    Finished readiness check of Oracle SOA with status: FAILURE.

 

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