Unable to upgrade or run the Update Readiness Tool due to database errors
search cancel

Unable to upgrade or run the Update Readiness Tool due to database errors

book

Article ID: 162886

calendar_today

Updated On:

Products

Data Loss Prevention Enforce Data Loss Prevention Data Loss Prevention Core Package Data Loss Prevention Oracle Standard Edition 2 Data Loss Protection Oracle Standard Edition

Issue/Introduction

When attempting to upgrade or run the Update Readiness Tool, it fails with PRECHECK.CHECK_SYS_PRIVILEGES and PRECHECK.CHECK_OBJECT_PRIVILEGES, ORA-06550 errors.

Error seen the the Update Readiness log:

Precheck.check_sys_privileges(p_passed => l_passed,p_cursor => l_cur);
*
ERROR at line 10:
ORA-06550: line 10, column 4:
PLS-00201: identifier 'PRECHECK.CHECK_SYS_PRIVILEGES' must be declared
ORA-06550: line 10, column 4:
PL/SQL: Statement ignored
ORA-06550: line 32, column 4:
PLS-00201: identifier 'PRECHECK.CHECK_OBJECT_PRIVILEGES' must be declared
ORA-06550: line 32, column 4:
PL/SQL: Statement ignored

 

Environment

Oracle database for Data Loss Prevention

Update Readiness Tool

Cause

The 'protect' or Update Readiness Tool user has an invalid password.

In one case, it was found that the password had a - (dash) and another case had a @, which is invalid for Oracle passwords.

Resolution

Created a new URT user with a password that meets the Oracle database requirements and the URT ran successfully.

When creating the passwords for the 'protect' or Update Readiness Tool user, ensure that the password follows the Oracle recommendations.

Additional Information

Link to article with Oracle password guidelines:

https://knowledge.broadcom.com/external/article?articleNumber=160157