Patch 19007053 Fails While Inserting New Profiles WMS_INTERNET_PROXY_HOSTNAME and WMS_INTERNET_PROXY_PORT with Error ORA-28115: Policy With Check Option Violation
(Doc ID 2805328.1)
Last updated on SEPTEMBER 14, 2021
Applies to:Oracle Warehouse Management - Version 12.2.4 and later
Information in this document applies to any platform.
Profile fails with a database policy error during patching.
The issue occurs with the following patches: <Patch 19007053> or <Patch 26787701>
* See the following error messages in the patch log.
Error loading seed data for PROFILE: PROFILE_NAME = WMS_INTERNET_PROXY_HOSTNAME, ORA-28115: policy with check option violation
Error loading seed data for PROFILE: PROFILE_NAME = WMS_INTERNET_PROXY_PORT, ORA-28115: policy with check option violation
1. Update database to 12c using steps mentioned in <Note 2552181.1>
2. Proceed to Step 9 -Apply post-upgrade WMS patches (Conditional)
3. On applying Patch 19007053, receive the errors.
Update database to 12c using steps mentioned in <Note 2552181.1>
Apply <Patch 19007053>
Apply <Patch 26787701>
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