"ORA-28001: the password has expired" error is seen while connecting to the Oracle repository database with the GTREP credentials.
(Please note that GTREP is the default username for connecting to the TDM gtrep repository database. In your environment, this username may be different)
Release : ARD 3.x, FDM all releases, TDM 4.8+ with Oracle GTREP Repository Database
Component : CA Agile Requirements Designer, GT Datamaker, FastDataMasker, TDM Portal
This issue is most likely happening because the Oracle password for the GTREP user has expired and needs to be reset.
The cause can be verified by connecting to the repository instance from command-line SQLPLUS.
For example, from the command prompt, run:
SQLPLUS GTREP/[email protected]
In this example the username and password are GTREP, and the Oracle Net service name is "XE".
Running this command should also give the same error message:
"ORA-28001: the password has expired"
If you are experiencing this issue in a production or multi-user environment, please consult with your Oracle DBA for assistance with resetting the password for the GTREP (or appropriate) user, which is the credential to connect to the TDM repository DB.
If you are facing this issue with a non-production, personal copy of Oracle XE (or similar) database, and have the necessary approval to make administrative changes on the Oracle server, please follow these steps to reset the password for the GTREP user. You need the "SYSTEM" (or SYS) user credentials to reset the password.
If you are still experiencing issues, please open a support case by going to https://support.broadcom.com or call +1 800 225 5224