Unable to connect to Oracle DB from Spoon IDE

Version 2
    Share:|

    This document contains official content from the BMC Software Knowledge Base. It is automatically updated when the knowledge article is modified.


    PRODUCT:

    BMC Atrium Core - CMDB


    COMPONENT:

    spoon


    APPLIES TO:

    Any use cases where Oracle jdbc driver is necessary to connect to a remote DB.



    PROBLEM:

    Spoon client connection to Oracle database can get an ERROR message when the Oracle DB driver is not up to date. 

    ERROR:
    "org.pentaho.di.core.exception.KettleDatabaseException: Error occurred while trying to connect to the database
    Error connecting to database: (using class oracle.jdbc.driver.OracleDriver) ORA-28040: No matching authentication protocol"

     


    Prior to AR System 9.1.03 installation package only include "ojdbc14" and "orai14n"  jar files in which do not support the Oracle DB latest versions. 


     


    CAUSE:

    The Oracle jdbc driver does not match the Oracle Database version to which the SQL query is sent to. Prior to AR System 9.1.03 installation package only include "ojdbc14" and "orai14n" jar files in which do not support the Oracle DB latest versions.


    SOLUTION:

    BMC ARS Server prior to 8.1 here is what you have to do to solve it.

    1.- Download the JDBC client from Oracle and make sure the version supports your DB version.
        For example: ojdbc8.jar and orai18n.jar are the latest versions in 9.1.04.

    2.- Shut Down ARS System service and close the Spoon(s) client.

    3.- Remove the old jar files (e.g."ojdbc14" and "orai14n"). 

    4.- Insert the new jar files.

    5.- Start ARS service.

    6.- Retest your connection. 

    *Note: For users that has ARS above 9.1 releases, location of the files are: "C:\Program Files\BMC Software\ARSystem\diserver\data-integration\lib".
      Prior 9.1 releases, the jar files are located here: "C:\Program Files\BMC Software\ARSystem\diserver\data-integration\libext\JDBC".

    This is the path and the jar files highligthed involved
     


    Article Number:

    000148372


    Article Type:

    Solutions to a Product Problem



      Looking for additional information?    Search BMC Support  or  Browse Knowledge Articles