Datamaker throws an "ORA-28001: the password has expired" error while connecting to the repository database

book

Article ID: 4393

calendar_today

Updated On:

Products

CA Test Data Manager (Data Finder / Grid Tools)

Issue/Introduction

Datamaker throws an "ORA-28001: the password has expired" error while connecting to the Oracle repository database with the GTREP credentials.

(Please note that GTREP is the default username for connecting to the TDM repository database. In your environment, this username may be different)

Cause

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]

Here, username and password are GTREP, and the Oracle Net service name is "XE".

Running this command also should give the same error message:

"ORA-28001: the password has expired"

Environment

 

Release : ARD all releases, TDM 4.2+ and later with Oracle Repository Database

Component : CA Agile Requirements Designer

 

Resolution

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.

 

1. From Windows command-prompt, run the following command: 

sqlplus system/<password>@XE 

You should see the SQL> prompt. 

 

2. Reset the password of the GTREP user by the following command: 

ALTER user GTREP identified by <password>;

Use the same password as earlier (that was indicated as expired) if you do not wish to change your TDM Portal, Datamaker, TDoD and Remote Publish configurations. 

 

3. Use these two commands to ensure that the password does not expire in the future: 

a. SELECT USERNAME, PROFILE from dba_users where username = 'GTREP'; 

 

Suppose the "Profile" value returned is "DEFAULT". Next, run this SQL command: 

b. ALTER PROFILE DEFAULT limit password_life_time UNLIMITED;

If a profile other than DEFAULT was returned in the previous step, replace the value "DEFAULT" appropriately in the above SQL.

Additional Information

If you are still experiencing issues, please open a support case by going to https://casupport.broadcom.com/user/ or https://www.ca.com/us/services-support/ca-support/contact-support.html?intcmp=footernav.