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

Document ID : KB000004393
Last Modified Date : 14/02/2018
Show Technical Document Details
Issue:

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)

Environment:
TDM 3.2.2 and later;Oracle Repository Database
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/GTREP@XE

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"

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 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 at https://support.ca.com, or by calling CA Customer Care (http://www3.ca.com/us/support/customer-assistance.aspx).