Hello Team,
Run update readiness tool to upgrade DLP from 15.7 to 15.8. In the output file we have 3 warnings and 4 errors.
Hostname : WIN-RDOEBTQKTR8
Upgrade Source Version : 15.7
no rows selected
no rows selected
no rows selected
No errors.
No errors.
No errors.
No errors.
Readiness Tool Release : October 2020
Upgrade Target Version : 15.8
Date : 2022-07-26 17:34:13
Database Schema Version : 15.7
Oracle Version : Oracle Database 19c Standard Edition 2 Release 19.0.0.0.0 - Production
Oracle Server Platform : Microsoft Windows x86 64-bit
Oracle Registry History :
Action Time Action Comments
-------------------- --------------- ----------------------------------------
(null) BOOTSTRAP RDBMS_19.3.0.0.0DBRU_WINDOWS.X64_190528
Enforce Install History :
Enforce Version Date Installed Is Current Version?
-------------------- ------------------------------ -------------------
15.7.0.18016 2020-02-29 14:19:14 Y
15.0.0.45028 2018-03-10 12:46:38 N
Start: Oracle Support Validation - 2022-07-26 17:34:13
End : Oracle Support Validation - elapsed 0s - PASSED
Start: Oracle System Privilege Validation - 2022-07-26 17:34:13
Missing system privileges
-------------------------
CREATE JOB
End : Oracle System Privilege Validation - elapsed .06s -
FAILED (1 error)
Start: Oracle Object Privilege Validation - 2022-07-26 17:34:13
Missing object privileges
Oblect Name Privilege Required Needs Direct Grant
---------------------------- ------------------ ------------------
DATA_PUMP_DIR WRITE N
DATA_PUMP_DIR READ N
End : Oracle Object Privilege Validation - elapsed 2.47s -
FAILED (2 errors)
Start: Oracle CDC support not enabled - 2022-07-26 17:34:15
End : Oracle CDC support not enabled - elapsed 0s - PASSED
Start: Oracle Queued Jobs - 2022-07-26 17:34:15
End : Oracle Queued Jobs - elapsed .02s - PASSED
Start: Oracle Securefile Validation - 2022-07-26 17:34:15
End : Oracle Securefile Validation - elapsed .06s - PASSED
Start: Oracle Virtual Column Validation - 2022-07-26 17:34:15
End : Oracle Virtual Column Validation - elapsed .5s - PASSED
Start: Oracle Partition Table Validation - 2022-07-26 17:34:16
End : Oracle Partition Table Validation - elapsed .02s - PASSED
Start: Numeric Overflow Validation - 2022-07-26 17:34:16
End : Numeric Overflow Validation - elapsed 0s - PASSED
Start: Table Definition Validation - 2022-07-26 17:34:16
End : Table Definition Validation - elapsed 2.99s - PASSED
Start: Index Definition Validation - 2022-07-26 17:34:19
End : Index Definition Validation - elapsed 16.66s - PASSED
Start: Foreign Key Validation - 2022-07-26 17:34:36
End : Foreign Key Validation - elapsed 4.28s - PASSED
Start: Trigger Validation - 2022-07-26 17:34:40
End : Trigger Validation - elapsed .15s - PASSED
Start: Miscellaneous Object Validation - 2022-07-26 17:34:40
End : Miscellaneous Object Validation - elapsed .03s - PASSED
Start: **** Object Validation - 2022-07-26 17:34:40
End : **** Object Validation - elapsed 6.18s - PASSED
Start: Tablespace Validation - 2022-07-26 17:34:46
End : Tablespace Validation - elapsed .06s - PASSED
Start: Check Constraint Validation - 2022-07-26 17:34:46
End : Check Constraint Validation - elapsed .4s - PASSED
Start: Sequence Validation - 2022-07-26 17:34:47
Out-of-order sequences
Sequence Name Table Name Column Name Sequence.NEXTVAL Highest PK Value
------------------------------ ------------------------------ ------------------------------ ---------------- ----------------
End : Sequence Validation - elapsed 1.98s - PASSED
Start: Oracle System Parameter Validation - 2022-07-26 17:34:49
Parameter Name Current Value Recommended Value
------------------------------ -------------------- --------------------
compatible 19.0.0 19.0.0.0.0
memory_target 0 3221225472
sort_area_size 65536 0
End : Oracle System Parameter Validation - elapsed .03s -
WARNING (3 warnings)
Start: Data Check Constraint Validation - 2022-07-26 17:34:49
Data violations are detected on your schema, please use the below query(s) to retrieve the **** data.
SELECT DISTINCT CommandName FROM CommandInfo WHERE CommandName IN ('protect-encrypt', 'endpoint-encrypt-cancel', 'cloud-storage-encrypt', 'rest-response-dim-encrypt', 'rest-response-dar-encrypt', 'rest-response-encrypt');
End : Data Check Constraint Validation - elapsed 0s -
FAILED (1 violation)
Data Objects Check Summary: There are total of 3 warnings and 4 errors.
For details about the Update Readiness Tool output messages and troubleshooting information, see "Reviewing update readiness results" in the Data Loss Prevention online help.
Can you please guide me for next POA