My Oracle Support Banner

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.

Symptoms

Profile fails with a database policy error during patching.

The issue occurs with the following patches: <Patch 19007053> or <Patch 26787701>


ERROR
* 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

STEPS
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.

Changes

Update database to 12c using steps mentioned in <Note 2552181.1>

Apply <Patch 19007053>

-or-

Apply <Patch 26787701>

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
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.