JDBC Reciver channel :SQLException: ORA-28040: No matching authentication protocol errror in SAP PI

490 Views Last edit Sep 05, 2017 at 08:07 AM 2 rev

Proxy to JDBC outbound interface.

PI 7.31 dual stack verion, Oracle 12.1.0.2.0

. below connection strings are using.

jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=whatEverYourHostNameIs)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=yourServiceName)))

jdbc:oracle:thin:@(DESCRIPTION=(LOAD_BALANCE=on)(ADDRESS=(PROTOCOL=TCP)(HOST= 192.168.10.11)(PORT=1521))(ADDRESS=(PROTOCOL=TCP)(HOST= 192.168.10.12)(PORT=1521)) (ADDRESS=(PROTOCOL=TCP)(HOST= 192.168.10.13) (PORT=1521))(ADDRESS=(PROTOCOL=TCP)(HOST= 192.168.10.14)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME= rac.hostname)))

while connecting from PI to RAC DB getting ORA:28040 error in jdbc channel.

RAC DB is using below paramerts in their side .

https://developer.ibm.com/answers/questions/177075/after-upgrading-to-oracle-12c-database-i-start-get.html

http://www.redstk.com/ora-28040-no-matching-authentication-protocol-after-upgrade-to-12c/

RAC DB sqlnet configuration maintained below parameters..

SQLNET.ALLOWED_LOGON_VERSION_SERVER=8

SQLNET.ALLOWED_LOGON_VERSION_CLIENT=8. please can you help on this issue.