WebSphere v9, DSRA0010E error with oracle DB (Account is locked) | WebSphere Application Server & Li

link管理

链接快照平台

输入网页链接，自动生成快照
标签化管理网页链接

IBM Application Runtimes Community

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.

#Support
#SupportMigration
#WebSphereApplicationServer(WAS)

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:

ORA- 28000: the account is locked tips http://www.dba-oracle.com/sf_ora_28000_the_account_is_locked.htm

- 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

#Support
#SupportMigration
#WebSphereApplicationServer(WAS)

Marketplace

IBM Application Runtimes Community

Come for answers, stay for best practices. All we're missing is you.

Community Support Admin Mon March 01, 2021 12:27 AM

Community Support Admin Mon March 01, 2021 12:33 AM Best Answer