ORA-28001: the password has expired

Products

• CA Automic Applications Manager (AM)

Issue/Introduction

Applications Manager may fail to start due to "Error: java awapi time out" message. Reviewing the RmiServer.log or RmiServer<timestamp>.log generated during the start up process show the following error:

ErrorMsg: AwE-5001 Database Query Error (7/25/22, 12:23 PM)
Details: null
java.sql.SQLException: ORA-28001: the password has expired
   at oracle.jdbc.driver.T4CTTIoerll.procèssError(T4CTTIoerll.java:509)  
   at oracle.jdbc.driver.T4CTTIoerll.procèssError(T4CTTIoerll.java:456)
   at oracle.jdbc.driver.T4CTTIoerll.procèssError(T4CTTIoerll.java : 451)
   at oracle.jdbc.driver.T4CTTIfun.procèssError(T4CTTIfun.java:1040)
   at oracle.jdbc.driver.T4CTTIoauthenticate.processError(T4CTTIoauthenticate.java:552)
   at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:550)
   at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:268)
   at oracle.jdbc.driver.T4CTTIoauthenticate.doOAUTH(T4CTTIoauthenticate.java:501)
   at oracle.jdbc.driver.T4CTTIoauthenticate.doOAUTH(T4CTTIoauthenticate.java:1292)
   at oracle.jdbc.driver.T4CTTIoauthenticate.doOAUTH(T4CTTIoauthenticate.java:1025)
   at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:743)
   at oracle.jdbc.driver.PhysicalConnection.connect(PhysicalConnection.java:793)
   at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:57)
   at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:747)
   at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:562)
   at java.sql/java.sql.DriverManager.getConnection(DriverManager.java:677)
   at java.sql/java.sql.DriverManager.getConnection(DriverManager.java:189)
   at com.appworx.server.sql.AxConnectionPool.getConnection(AxConnectionPool.java: 370)
   at com.appworx.server.sql.DBAccess.getConnection(DBAccess.java :1537)
   at com.appworx.server.sql.CommonDB.B(CommonDB.java : 570)
   at com.appworx.server.sql.CommonDB.A(CommonDB.java : 546)
   at com.appworx.server.sql.CommonDB.getSqlData(CommonDB.java:188) 
   at com.appworx.server.data.MasterDB.<init>(MasterDB.java:210)
   at com.appworx.server.data.MasterDB.<init>(MasterDB.java:185)
   at com.appworx.server.data.Master.<init>(Master.java:195)
   at com.appworx.server.data.AxRmiServer.?(AxRmiServer.java:2956)
   at com.appworx.server.data.AxRmiServer.setupMasters(AxRmiServer.java : 2809)
   at com.appworx.server.data.AxRmiServer.main(AxRmiServer.java:936)

Environment

Release : ALL

Component : APPLICATIONS MANAGER

Resolution

The Applications Manager Oracle User's password is expired and needs to be refreshed. 

If password is refreshed with the same password value, no further action is needed besides restarting Applications Manager.

If the password is changed to a different password value, additional steps are required. Please see:

https://knowledge.broadcom.com/external/article?articleId=224707