WebSphere Application Server & Liberty

We recently upgraded our WebSphere environment to version 9 from version 6 and now are encountering a database error (DSRA0010E – account is locked). We are using oracle DB 19. Our environment is SunOS.

"DSRA0010E: SQL State = 99999, Error Code = 28,000

org.quartz.JobPersistenceException: Failed

to obtain DB connection from data source

'wfschedulerDS': java.sql.SQLException:

Could not retrieve datasource via JNDI url

'datasource/nx/base'

java.sql.SQLException: ORA-28000: The

account is locked.

DSRA0010E: SQL State = 99999, Error Code = 28,000 [See nested

exception: java.sql.SQLException: Could not retrieve datasource via

JNDI url 'datasource/nx/base' java.sql.SQLException: ORA-28000: The

account is locked.

DSRA0010E: SQL State = 99999, Error Code = 28,000]

at .....

....

* Nested Exception (Underlying Cause) ---------------

java.sql.SQLException: Could not retrieve datasource via JNDI url

'datasource/nx/base' java.sql.SQLException: ORA-28000: The account is

locked.

This is happening because WebSphere has tried to connect to

the DB several times and there is an issue either with the password or the helper class is not updated.

The recommendation is to ensure password and helper class has been update has been updated to 11g. In addition, the following lines need to be added in the

sqlnet.ora

SQLNET.ALLOWED_LOGON_VERSION_SERVER=11

SQLNET.ALLOWED_LOGON_VERSION_CLIENT=11

References for unlocking the account:

Ref:

- also see the following page on how to unlock oracle

accounts on

AIX.. you could use the same info to unlock on SunOs -

https://docs.oracle.com/en/database/oracle/oracle-database/12.2/axdbi/using-sql-plus-to-unlock-accounts-and-reset-passwords.html#GUID-1147D2B9-8FFC-4F91-A774-E97

066B4E9C5