WebSphere Application Server & Liberty

WebSphere Application Server & Liberty

Join this online group to communicate across IBM product users and experts by sharing advice and best practices with peers and staying up to date regarding product enhancements.

 View Only
Back to discussions
Expand all | Collapse all

WebSphere v9, DSRA0010E error with oracle DB (invalid username/password)

  • 1.  WebSphere v9, DSRA0010E error with oracle DB (invalid username/password)

    Posted Mon March 01, 2021 12:17 AM

    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?



    #Support
    #SupportMigration
    #WebSphereApplicationServer(WAS)


  • 2.  RE: WebSphere v9, DSRA0010E error with oracle DB (invalid username/password)
    Best Answer

    Posted Mon March 01, 2021 12:23 AM

    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



    #Support
    #SupportMigration
    #WebSphereApplicationServer(WAS)


Related Content