Websphere application server does not come up with the error ORA-28001 in systemout logs

Issue : 

Application deployed on the Websphere Application server does not load after the restart of the server. The application url will show 500 http error code.

Error:

Following error is seen in the SystemOut.log :

Caused by: java.sql.SQLException: ORA-28001: the password has expired
DSRA0010E: SQL State = 99999, Error Code = 28,001
at oracle.jdbc.driver.T.processError(TT.java:445)

Why is this error displayed in the logs :

This error is seen the logs when the password for id used to connect to oracle database is expired at oracle end.

Tips to troubleshoot :

-> Test the WAS connectivity with the database by using the "test connection" tab in WAS console.

Test will be unsuccessful as WAS will not be able to establish a connection with database due to password expiry. Following error is displayed in the console.

 

-> Get the id that is being used to connect to database by following the below instructions.

• Navigate to Data-sources tab.        

• Navigate to the data-source that was throwing an error while connecting to the database server.                   

• Click on the JAAS link.

                                                            

• Get the id's listed and check if they are locked at oracle end.
• In new oracle versions automatic password expiry is set to 180 days. Once the password is reset at oracle end, Restart the application servers and the servers will restart without any errors.