Last updated on AUGUST 20, 2017
Applies to:
Oracle Platform Security for Java - Version 11.1.1.1.0 to 12.2.1.2.0 [Release Oracle11g to 12c]Information in this document applies to any platform.
Symptoms
On : 12.2.1.2.0 version, Upgrade Assistant
When attempting to run Upgrade Assistant(UA) Readiness check to upgrade domain to 12.2.1.2, errors such as the following occur for Oracle Audit Services.
Completed schema test: PRIVILEGES_TEST --> Test that the audit schema has appropriate system and object privileges +++ FAIL
Starting schema test: SEQUENCE_TEST Test that the audit schema sequence and its properties are valid
Completed schema test: SEQUENCE_TEST --> Test that the audit schema sequence and its properties are valid +++ PASS
Starting schema test: SYNONYMS_TEST Test that the audit schema required synonyms are present
EXCEPTION OIDCOMPONENT synonym missing in ORD_IAU_VIEWER schema
EXCEPTION IAU_CUSTOM_01 synonym missing in ORD_IAU_VIEWER schema
EXCEPTION IAU_BASE synonym missing in ORD_IAU_VIEWER schema
EXCEPTION AUDITREPORTS_PKG synonym missing in ORD_IAU_VIEWER schema
EXCEPTION WS_POLICYATTACHMENT synonym missing in ORD_IAU_VIEWER schema
EXCEPTION OWSM_PM_EJB synonym missing in ORD_IAU_VIEWER schema
EXCEPTION XMLPSERVER synonym missing in ORD_IAU_VIEWER schema
EXCEPTION SOA_HCFP synonym missing in ORD_IAU_VIEWER schema
EXCEPTION JPS synonym missing in ORD_IAU_VIEWER schema
EXCEPTION SOA_B2B synonym missing in ORD_IAU_VIEWER schema
EXCEPTION OVDCOMPONENT synonym missing in ORD_IAU_VIEWER schema
EXCEPTION WEBSERVICES synonym missing in ORD_IAU_VIEWER schema
EXCEPTION AUDITSCHEMA_PKG synonym missing in ORD_IAU_VIEWER schema
EXCEPTION STS synonym missing in ORD_IAU_VIEWER schema
EXCEPTION IAU_DISP_NAMES_TL synonym missing in ORD_IAU_VIEWER schema
EXCEPTION OWSM_AGENT synonym missing in ORD_IAU_VIEWER schema
EXCEPTION OHSCOMPONENT synonym missing in ORD_IAU_VIEWER schema
EXCEPTION OAAM synonym missing in ORD_IAU_VIEWER schema
INFO IAU_CUSTOM synonym missing in ORD_IAU_VIEWER schema. This maybe caused by a known issue, anyway, this missing synonym will be added in 12.2.2 upgrade. So this issue will be fixed in 12.2.2 upgrade
EXCEPTION WEBCACHECOMPONENT synonym missing in ORD_IAU_VIEWER schema
EXCEPTION REPORTSSERVERCOMPONENT synonym missing in ORD_IAU_VIEWER schema
EXCEPTION DIP synonym missing in ORD_IAU_VIEWER schema
EXCEPTION ADMINSERVER synonym missing in ORD_IAU_VIEWER schema
EXCEPTION LIST_OF_COMPONENTS synonym missing in ORD_IAU_VIEWER schema
EXCEPTION OIF synonym missing in ORD_IAU_VIEWER schema
INFO IAU_AUDITSERVICE synonym missing in ORD_IAU_VIEWER schema. This maybe caused by a known issue, anyway, this missing synonym will be added in 12.2.2 upgrade. So this issue will be fixed in 12.2.2 upgrade
EXCEPTION ATTRIBUTE_VALUE_PAIRS synonym missing in ORD_IAU_VIEWER schema
EXCEPTION LIST_OF_EVENTS synonym missing in ORD_IAU_VIEWER schema
EXCEPTION IAU_LOCALE_MAP_TL synonym missing in ORD_IAU_VIEWER schema
INFO IAU_USERSESSION synonym missing in ORD_IAU_VIEWER schema. This maybe caused by a known issue, anyway, this missing synonym will be added in 12.2.2 upgrade. So this issue will be fixed in 12.2.2 upgrade
INFO IAU_SCHEMA_VERSION synonym missing in ORD_IAU_VIEWER schema. This maybe caused by a known issue, anyway, this missing synonym will be added in 12.2.2 upgrade. So this issue will be fixed in 12.2.2 upgrade
INFO IAU_COMMON synonym missing in ORD_IAU_VIEWER schema. This maybe caused by a known issue, anyway, this missing synonym will be added in 12.2.2 upgrade. So this issue will be fixed in 12.2.2 upgrade
EXCEPTION OAM synonym missing in ORD_IAU_VIEWER schema
EXCEPTION OIDCOMPONENT synonym missing in ORD_IAU_APPEND schema
EXCEPTION IAU_CUSTOM_01 synonym missing in ORD_IAU_APPEND schema
EXCEPTION IAU_BASE synonym missing in ORD_IAU_APPEND schema
EXCEPTION AUDITREPORTS_PKG synonym missing in ORD_IAU_APPEND schema
EXCEPTION WS_POLICYATTACHMENT synonym missing in ORD_IAU_APPEND schema
EXCEPTION OWSM_PM_EJB synonym missing in ORD_IAU_APPEND schema
EXCEPTION XMLPSERVER synonym missing in ORD_IAU_APPEND schema
EXCEPTION SOA_HCFP synonym missing in ORD_IAU_APPEND schema
EXCEPTION JPS synonym missing in ORD_IAU_APPEND schema
EXCEPTION SOA_B2B synonym missing in ORD_IAU_APPEND schema
EXCEPTION OVDCOMPONENT synonym missing in ORD_IAU_APPEND schema
EXCEPTION WEBSERVICES synonym missing in ORD_IAU_APPEND schema
EXCEPTION AUDITSCHEMA_PKG synonym missing in ORD_IAU_APPEND schema
EXCEPTION STS synonym missing in ORD_IAU_APPEND schema
EXCEPTION IAU_DISP_NAMES_TL synonym missing in ORD_IAU_APPEND schema
EXCEPTION OWSM_AGENT synonym missing in ORD_IAU_APPEND schema
EXCEPTION OHSCOMPONENT synonym missing in ORD_IAU_APPEND schema
EXCEPTION OAAM synonym missing in ORD_IAU_APPEND schema
INFO IAU_CUSTOM synonym missing in ORD_IAU_APPEND schema. This maybe caused by a known issue, anyway, this missing synonym will be added in 12.2.2 upgrade. So this issue will be fixed in 12.2.2 upgrade
EXCEPTION WEBCACHECOMPONENT synonym missing in ORD_IAU_APPEND schema
EXCEPTION REPORTSSERVERCOMPONENT synonym missing in ORD_IAU_APPEND schema
INFO ID_SEQ synonym missing in ORD_IAU_APPEND schema. This maybe caused by a known issue, anyway, this missing synonym will be added in 12.2.2 upgrade. So this issue will be fixed in 12.2.2 upgrade
EXCEPTION DIP synonym missing in ORD_IAU_APPEND schema
EXCEPTION ADMINSERVER synonym missing in ORD_IAU_APPEND schema
EXCEPTION LIST_OF_COMPONENTS synonym missing in ORD_IAU_APPEND schema
EXCEPTION OIF synonym missing in ORD_IAU_APPEND schema
INFO IAU_AUDITSERVICE synonym missing in ORD_IAU_APPEND schema. This maybe caused by a known issue, anyway, this missing synonym will be added in 12.2.2 upgrade. So this issue will be fixed in 12.2.2 upgrade
EXCEPTION ATTRIBUTE_VALUE_PAIRS synonym missing in ORD_IAU_APPEND schema
EXCEPTION LIST_OF_EVENTS synonym missing in ORD_IAU_APPEND schema
EXCEPTION IAU_LOCALE_MAP_TL synonym missing in ORD_IAU_APPEND schema
INFO IAU_USERSESSION synonym missing in ORD_IAU_APPEND schema. This maybe caused by a known issue, anyway, this missing synonym will be added in 12.2.2 upgrade. So this issue will be fixed in 12.2.2 upgrade
EXCEPTION IAU_SCHEMA_VERSION synonym missing in ORD_IAU_APPEND schema
INFO IAU_COMMON synonym missing in ORD_IAU_APPEND schema. This maybe caused by a known issue, anyway, this missing synonym will be added in 12.2.2 upgrade. So this issue will be fixed in 12.2.2 upgrade
EXCEPTION OAM synonym missing in ORD_IAU_APPEND schema
Completed schema test: SYNONYMS_TEST --> Test that the audit schema required synonyms are present +++ FAIL
Finished readiness check of Oracle Audit Services with status: FAILURE.
Starting schema test: SEQUENCE_TEST Test that the audit schema sequence and its properties are valid
Completed schema test: SEQUENCE_TEST --> Test that the audit schema sequence and its properties are valid +++ PASS
Starting schema test: SYNONYMS_TEST Test that the audit schema required synonyms are present
EXCEPTION OIDCOMPONENT synonym missing in ORD_IAU_VIEWER schema
EXCEPTION IAU_CUSTOM_01 synonym missing in ORD_IAU_VIEWER schema
EXCEPTION IAU_BASE synonym missing in ORD_IAU_VIEWER schema
EXCEPTION AUDITREPORTS_PKG synonym missing in ORD_IAU_VIEWER schema
EXCEPTION WS_POLICYATTACHMENT synonym missing in ORD_IAU_VIEWER schema
EXCEPTION OWSM_PM_EJB synonym missing in ORD_IAU_VIEWER schema
EXCEPTION XMLPSERVER synonym missing in ORD_IAU_VIEWER schema
EXCEPTION SOA_HCFP synonym missing in ORD_IAU_VIEWER schema
EXCEPTION JPS synonym missing in ORD_IAU_VIEWER schema
EXCEPTION SOA_B2B synonym missing in ORD_IAU_VIEWER schema
EXCEPTION OVDCOMPONENT synonym missing in ORD_IAU_VIEWER schema
EXCEPTION WEBSERVICES synonym missing in ORD_IAU_VIEWER schema
EXCEPTION AUDITSCHEMA_PKG synonym missing in ORD_IAU_VIEWER schema
EXCEPTION STS synonym missing in ORD_IAU_VIEWER schema
EXCEPTION IAU_DISP_NAMES_TL synonym missing in ORD_IAU_VIEWER schema
EXCEPTION OWSM_AGENT synonym missing in ORD_IAU_VIEWER schema
EXCEPTION OHSCOMPONENT synonym missing in ORD_IAU_VIEWER schema
EXCEPTION OAAM synonym missing in ORD_IAU_VIEWER schema
INFO IAU_CUSTOM synonym missing in ORD_IAU_VIEWER schema. This maybe caused by a known issue, anyway, this missing synonym will be added in 12.2.2 upgrade. So this issue will be fixed in 12.2.2 upgrade
EXCEPTION WEBCACHECOMPONENT synonym missing in ORD_IAU_VIEWER schema
EXCEPTION REPORTSSERVERCOMPONENT synonym missing in ORD_IAU_VIEWER schema
EXCEPTION DIP synonym missing in ORD_IAU_VIEWER schema
EXCEPTION ADMINSERVER synonym missing in ORD_IAU_VIEWER schema
EXCEPTION LIST_OF_COMPONENTS synonym missing in ORD_IAU_VIEWER schema
EXCEPTION OIF synonym missing in ORD_IAU_VIEWER schema
INFO IAU_AUDITSERVICE synonym missing in ORD_IAU_VIEWER schema. This maybe caused by a known issue, anyway, this missing synonym will be added in 12.2.2 upgrade. So this issue will be fixed in 12.2.2 upgrade
EXCEPTION ATTRIBUTE_VALUE_PAIRS synonym missing in ORD_IAU_VIEWER schema
EXCEPTION LIST_OF_EVENTS synonym missing in ORD_IAU_VIEWER schema
EXCEPTION IAU_LOCALE_MAP_TL synonym missing in ORD_IAU_VIEWER schema
INFO IAU_USERSESSION synonym missing in ORD_IAU_VIEWER schema. This maybe caused by a known issue, anyway, this missing synonym will be added in 12.2.2 upgrade. So this issue will be fixed in 12.2.2 upgrade
INFO IAU_SCHEMA_VERSION synonym missing in ORD_IAU_VIEWER schema. This maybe caused by a known issue, anyway, this missing synonym will be added in 12.2.2 upgrade. So this issue will be fixed in 12.2.2 upgrade
INFO IAU_COMMON synonym missing in ORD_IAU_VIEWER schema. This maybe caused by a known issue, anyway, this missing synonym will be added in 12.2.2 upgrade. So this issue will be fixed in 12.2.2 upgrade
EXCEPTION OAM synonym missing in ORD_IAU_VIEWER schema
EXCEPTION OIDCOMPONENT synonym missing in ORD_IAU_APPEND schema
EXCEPTION IAU_CUSTOM_01 synonym missing in ORD_IAU_APPEND schema
EXCEPTION IAU_BASE synonym missing in ORD_IAU_APPEND schema
EXCEPTION AUDITREPORTS_PKG synonym missing in ORD_IAU_APPEND schema
EXCEPTION WS_POLICYATTACHMENT synonym missing in ORD_IAU_APPEND schema
EXCEPTION OWSM_PM_EJB synonym missing in ORD_IAU_APPEND schema
EXCEPTION XMLPSERVER synonym missing in ORD_IAU_APPEND schema
EXCEPTION SOA_HCFP synonym missing in ORD_IAU_APPEND schema
EXCEPTION JPS synonym missing in ORD_IAU_APPEND schema
EXCEPTION SOA_B2B synonym missing in ORD_IAU_APPEND schema
EXCEPTION OVDCOMPONENT synonym missing in ORD_IAU_APPEND schema
EXCEPTION WEBSERVICES synonym missing in ORD_IAU_APPEND schema
EXCEPTION AUDITSCHEMA_PKG synonym missing in ORD_IAU_APPEND schema
EXCEPTION STS synonym missing in ORD_IAU_APPEND schema
EXCEPTION IAU_DISP_NAMES_TL synonym missing in ORD_IAU_APPEND schema
EXCEPTION OWSM_AGENT synonym missing in ORD_IAU_APPEND schema
EXCEPTION OHSCOMPONENT synonym missing in ORD_IAU_APPEND schema
EXCEPTION OAAM synonym missing in ORD_IAU_APPEND schema
INFO IAU_CUSTOM synonym missing in ORD_IAU_APPEND schema. This maybe caused by a known issue, anyway, this missing synonym will be added in 12.2.2 upgrade. So this issue will be fixed in 12.2.2 upgrade
EXCEPTION WEBCACHECOMPONENT synonym missing in ORD_IAU_APPEND schema
EXCEPTION REPORTSSERVERCOMPONENT synonym missing in ORD_IAU_APPEND schema
INFO ID_SEQ synonym missing in ORD_IAU_APPEND schema. This maybe caused by a known issue, anyway, this missing synonym will be added in 12.2.2 upgrade. So this issue will be fixed in 12.2.2 upgrade
EXCEPTION DIP synonym missing in ORD_IAU_APPEND schema
EXCEPTION ADMINSERVER synonym missing in ORD_IAU_APPEND schema
EXCEPTION LIST_OF_COMPONENTS synonym missing in ORD_IAU_APPEND schema
EXCEPTION OIF synonym missing in ORD_IAU_APPEND schema
INFO IAU_AUDITSERVICE synonym missing in ORD_IAU_APPEND schema. This maybe caused by a known issue, anyway, this missing synonym will be added in 12.2.2 upgrade. So this issue will be fixed in 12.2.2 upgrade
EXCEPTION ATTRIBUTE_VALUE_PAIRS synonym missing in ORD_IAU_APPEND schema
EXCEPTION LIST_OF_EVENTS synonym missing in ORD_IAU_APPEND schema
EXCEPTION IAU_LOCALE_MAP_TL synonym missing in ORD_IAU_APPEND schema
INFO IAU_USERSESSION synonym missing in ORD_IAU_APPEND schema. This maybe caused by a known issue, anyway, this missing synonym will be added in 12.2.2 upgrade. So this issue will be fixed in 12.2.2 upgrade
EXCEPTION IAU_SCHEMA_VERSION synonym missing in ORD_IAU_APPEND schema
INFO IAU_COMMON synonym missing in ORD_IAU_APPEND schema. This maybe caused by a known issue, anyway, this missing synonym will be added in 12.2.2 upgrade. So this issue will be fixed in 12.2.2 upgrade
EXCEPTION OAM synonym missing in ORD_IAU_APPEND schema
Completed schema test: SYNONYMS_TEST --> Test that the audit schema required synonyms are present +++ FAIL
Finished readiness check of Oracle Audit Services with status: FAILURE.
Changes
Performing Readiness checks, before the upgrade.
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