KB181000812: AE Connect - External Oracle Database: ORA-28040: No matching authentication protocol

Description

When configuring an Oracle DB as External Database, or when upgrading an Oracle DB that was previously configured as External Database in Automation Engine, the connection fails. Details show the error "ORA-28040: No matching authentication protocol".

Solution

It is likely that the authentication settings on the Oracle DB are restricted, and don't allow connections for all client version.

Automation Engine (14.# and 16.#) use the Oracle driver ojdbc14.jar, installed during Automation Engine installation. If this driver is not supported by your Oracle DB, you need to configure the External Database via DBMS type "Other" instead of "Oracle".

Follow the steps given below to configure an Oracle DB via JDBC

1. Download the appropriate driver from Oracle (www.oracle.com).
2. Go to the Automation Engine Configure tool.
3. Perform the following settings:
   1. External databases: add new database
   2. DBMS Type: Other
   3. Driver (JDBC): oracle.jdbc.driver.OracleDriver
   4. Driver File: Browse to your driver file (for example: file://cssuite14a7/ExampleJobContainer/Oracle-drivers/ojdbc6.jar)
   5. Database URL: jdbc:oracle:thin:username/password@host:1521:SID
      1. username = your username (default: SYSTEM)
      2. password = your password
      3. host = DNS servername where Oracle is installed. (please avoid using IP address)
      4. 1521 is the default port for Oracle (Firewall on Oracle server should allow incoming connections)
      5. SID = Service Name of the database you want to connect to.