ROC Down with ORA-28001 Error


Article ID: 5861


Updated On:


CA Release Automation - Release Operations Center (Nolio) CA Release Automation - DataManagement Server (Nolio)


After restarting the data management server, such as for an upgrade, patch, or other maintenance, the ROC page fails to load.

Error ORA-28001 is found in the nolio_dm_all.log file, such as in the following example:

[localhost-startStop-1] WARN ( - Could not retrieve version info from DB. org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection; nested exception is java.sql.SQLException: Cannot create PoolableConnectionFactory (ORA-28001: the password has expired Line 60: org.flywaydb.core.api.FlywayException: Unable to obtain Jdbc connection from DataSource


ORA-28001 is an Oracle-specific message stating that the password used has expired.  This means that for the account Release Automation relies on to connect to the database, the password has expired and thus the connection is rejected.  ROC cannot load without a database connection. 


Any Release Automation environment using Oracle database.


To ensure a reliable connection between Release Automation and the database, the password used for RA's login to Oracle should never expire, thus having an expiration policy on that specific account is not advised.  Remove the expiration policy, and if the password has been changed, ensure the file is updated to reflect the change.  Restart the Release Automation server service after making changes.