Readiness Check for OPSS Schema Fails
When you upgrade Oracle Access Manager 11.1.2.3.0 environments that is upgraded from 11g Release 2 (11.1.2.1.0), the readiness check for Oracle Platform Security Services (OPSS) schema fails with the following exception”
Starting schema test: SEQUENCE_TEST Test that the Oracle Platform Security
Services schema sequence and its properties are valid
EXCEPTION JPSCHANGELOG_SEQ sequence is missing
EXCEPTION JPSDN_SEQ sequence is missing
EXCEPTION JPSATTRS_SEQ sequence is missing
Completed schema test: SEQUENCE_TEST --> Test that the Oracle Platform Security
Services schema sequence and its properties are valid +++ FAIL .
Starting schema test: TEST_REQUIRED_TABLES Test that the schema contains
all the required tables
EXCEPTION Schema is missing a required table: JPS_ENTITY_LOCK
Completed schema test: TEST_REQUIRED_TABLES --> Test that the schema
contains all the required tables +++ FAIL
This is a known issue for a multi-step (chain) upgrade. This exception can be ignored.Parent topic: Troubleshooting the Oracle Access Manager Upgrade