Hi,

We have upgraded our WebSphere 6.1 to 9.0.5.5 Base Edition and we are using Oracle DB 19 (ojdbc8.jar) and now we are encountering this error:

“ DSRA8040I: Failed to connect to the DataSource "".

Encountered java.sql.SQLException: ORA-01017: invalid username/password; logon denied

DSRA0010E: SQL State = 72000, Error Code = 1,017. “

We tried to connect to DB using SQLDeveloper and it was successful however it fails on WebSphere. Is oracle DB19 not supported for WebSphere 9?

WebSphere Application Server V9.0.5 supports "Any

database with a JDBC driver that is compliant with JDBC specification version 4.1 or earlier":

https://www.ibm.com/software/reports/compatibility/clarity-report/report/html/softwareReqsForProduct?deliverableId=DB3F9F7004D011EABCF401BE7354

4226&osPlatforms=Windows&duComponentIds=S000&mandatoryCapIds=13|132&opti

onalCapIds=341|9|39|8|132|20|223|26|40#sw-1

Check your username/password that you have used in the

database datasource configuration on WebSphere settings.

Testing a connection with the administrative console:

https://www.ibm.com/support/knowledgecenter/SSEQTP_9.0.5/com.ibm.websphere.base.doc/ae/tda

t_testcon.html

If that is failing, review the following page

for minimum requirements for Oracle database settings to ensure you are meeting them:

Data source minimum required settings for Oracle:

https://www.ibm.com/support/knowledgecenter/SSEQTP_9.0.5/com.ibm.websphere.base.doc/ae/rdat_mi

nreqoracle.html

"You must use the Oracle11gDataStoreHelper for database

server versions 11g and later"

You need to manually upgrade the helper class, unless you

redefine the Providers/Datasources

If an 11g database is configured for case sensitive passwords,

but you're trying to connect using a 10g client, the 10g client

will send the password all in upper case to the database, hence an

invalid password when the password you typed in is clearly correct.

So you need to upgrade the client to 11g to get it to send the password

in the correct case (but for a quick test you can change your

password to all upper case and you'll be able to connect)

Also see these Oracle ORA-01017 tips:

http://www.dba-oracle.com/t_ora_01017.htm

Other references:

1) Class Oracle11gDataStoreHelper -

https://www.ibm.com/support/knowledg

ecenter/SSEQTP_9.0.5/com.ibm.websphere.javadoc.doc/web/apidocs/com/ibm/w ebsphere/rsadapter/Oracle11gDataStoreHelper.html

2) Data source minimum required settings for Oracle:

https://www.ibm.com/support/knowledgecenter/SSEQTP_9.0.5/com.ibm.websphere.base.doc/ae/rdat

_minreqoracle.html

3) Java connect to Oracle database via JDBC:

https://www.codejava.net/java-se/jdbc/connect-to-oracle-database-via-jdbc

4) Data sourcess:

https://www.ibm.com/support/knowledgecenter/SSEQTP_9.0.5/c

om.ibm.websphere.base.doc/ae/cdat_datasor.html