Home

Trying to connect to agile with boomi (odbc) getting error ORA-28040

Hi Agile gurus,
We are trying to connect to Agile with boomi via odbc. We’re getting an errror
Unable to connect to database;caused by: unable to open database connection. ORA-28040: No matching authentication protocol

Any ideas how to fix this. We’re on windows server, oracle 12c, agile 9.3.385

Attached is error and settings for odbc connection

Thank you!
Laura

Agile Talent Asked on June 7, 2019 in Agile PLM (v9),   Product Collaboration.
Add Comment
Cancel
2 Answer(s)

There’s a lot of responses on the net that can help with this, such as https://developer.ibm.com/answers/questions/177075/after-upgrading-to-oracle-12c-database-i-start-get/.

FYI, this is a JDBC connection, not ODBC.

Cancel
Agile Angel Answered on June 7, 2019.
Add Comment
Cancel

Thanks so much. 
I’ve added 

SQLNET.ALLOWED_LOGON_VERSION_CLIENT = 8
SQLNET.ALLOWED_LOGON_VERSION_SERVER = 8

to sqlnet.ora file. We’re restarting oracle and listener services soon.

Thank you for your help!!
Laura

Cancel
Agile Talent Answered on June 7, 2019.
Add Comment
Cancel

Your Answer

By posting your answer, you agree to the privacy policy and terms of service.