Error: "ORA-28002: the password will expire within x days" when running the URT

Products

• Data Loss Prevention

Issue/Introduction

The ORA-28002 error is an Oracle error and we advise checking with your Oracle DBA to change the life time of the password to never expire/unlimited for this particular user. 

Resolution

Here are two links that contain information on how to identify the user and reset or extend the password in Oracle:

https://blogs.oracle.com/sql/post/how-to-fix-ora-28002-the-password-will-expire-in-7-days-errors

https://forums.oracle.com/ords/apexds/post/ora-28002-password-will-expire-in-x-days-7402

You can change the "protect" password following the steps in this KB:

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