Home

ORA-28001: The password has been expired

Hi All,

 

We have multiple servers of Agile 936 but some of them throwing the Error (ORA-28001: The password has been expired) while starting.

I try to resolve the Error from unlocking and change the password of Expired and Locked Users.

Solution Link(ORA-28001):

https://hecpv.wordpress.com/2014/10/16/how-to-solve-ora-28001-the-password-has-expired/

After following the link, get other Error (ORA-01017: invalid username/password; logon denied).

 

Please suggest me some solution, So I can start the Agile 936 Servers.

 

Thanks

Sandeep

Agile User Asked on August 13, 2020 in Agile PLM (v9).
Add Comment
Cancel
1 Answer(s)

Sandeep,

Seems like you haven’t updated the new password.

Check if the updated  database password and RCU password are correct or not in the below files

Note: Take backup before updating the below files

1.New encrypted database password  to be updated in the below files

1.agile.properties

2.AgileContentPool-jdbc

2. New Encrypted RCU password to be updated  in the below 4 files

C:\Agile\Agile936\agileDomain\config\jdbc

1.LocalSvcTblDataSource-jdbc.xml

2.opss-audit-jdbc.xml

3.opss-auditview-jdbc.xml

4.opss-datasource-jdbc.xml

3.Modify the bootstrap of OPSS password through WLST

1.Launch command line, and invoke wlst from C:\Oracle\Middleware\Oracle_Home\oracle_common\common\bin

2.C:\Oracle\Middleware\Oracle_Home\oracle_common\common\bin> wlst

3.wls:/offline>modifyBootStrapCredential(jpsConfigFile=’C:/Agile/Agile936/agileDomain/config/fmwconfig/jps-config.xml’, username=’DEV_OPSS’, password=’Agilercu936′)

Note:If the command completes without error, modifyBootStrapCredential has run successfully

4.Restart Agile Application Server. 

Hope this helps

Cancel
Agile User Answered on February 20, 2021.
Add Comment
Cancel

Your Answer

By posting your answer, you agree to the privacy policy and terms of service.