java.sql.SQLException: ORA-28001: the password has expired

  • KM00407364
  • 15-Apr-2013
  • 07-Jun-2021

Summary

The Data Base administrator set a timeframe to the password of the user that the database uses to authenticate with Network Node Manager and the password was expired.

Error

--- MBeans waiting for other MBeans ---
ObjectName: jboss.messagingervice=PersistenceManager
State: FAILED
Reason: org.jboss.util.NestedSQLException: Could not create connection; - nested throwable: (java.sql.SQLException: ORA-28001: the password has expired
); - nested throwable: (org.jboss.resource.JBossResourceException: Could not create connection; - nested throwable: (java.sql.SQLException: ORA-28001: the password has expired
))
 

Cause

Password expired  from the Oracle user that it use to authenticate with Network Node Manager (NNM).

Fix

 
A)Please doublecheck with the Data Base  administrator to set the password unexpired.
B)Then change on the Network Node Manager server the password of the database.
 
Windows:
D:\Program Files (x86)\HP\HP BTO Software\bin\nnmchangedbpw.ovpl
Unix:
/opt/OV/bin/nnmchangedbpw.ovpl