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:
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.