topic No matching authentication protocol-Oracle 19C in Administration and Deployment

No matching authentication protocol-Oracle 19C

rajdeep — Wed, 29 Sep 2021 19:05:30 GMT

Hi Team,

I am trying to connect to Oracle 19C OCI database from ODBC Bridge through system DSN, but I am getting the below error. The system DSN basically I am going to use for Dataflux studio.

I had kept the settings as above snapshots and for other tabs I kept as default. I have taken the Oracle wire Protocol Driver.

I had updated the SQLNET.ORA file with below two lines as well.

SQLNET.ALLOWED_LOGON_VERSION_SERVER=11
SQLNET.ALLOWED_LOGON_VERSION_CLIENT=11

Please suggest what work around I can follow to resolve this.

Thanks

Re: No matching authentication protocol-Oracle 19C

rajdeep — Thu, 30 Sep 2021 08:18:04 GMT

Hi Team,

Can anyone please guide something on this. The issue is in bit high priority.
Just wanted to know the the sqlnet.ora parameters need to be added in both server as well as client side or only server side.

Please help.

Thanks in advance.

Re: No matching authentication protocol-Oracle 19C

gwootton — Thu, 30 Sep 2021 13:07:50 GMT

You may wish to engage Oracle support as this message is not related to the SAS software and the issue is critical.

Seems like the issue is a mismatch in versions between the client driver and the server, perhaps you can update the driver?