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 FEBRUARY 03, 2022
Applies to:
Oracle Platform Security for Java - Version 12.2.1.1.0 and laterInformation 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: /<MIDDLEWARE>/aserver/<DOMAINNAME>
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.
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: /<MIDDLEWARE>/aserver/<DOMAINNAME>
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
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 |
References |