Skip to main content
  • EN
  • Home
  • Forums
  • FME Form
  • Transformers
  • Facing an issue while trying to connect Oracle 19c instance using FME 2020.2.3 with oracle client 11 and 10 and jdbc driver 5,6,11. We tried adding below lines in sqlnet.ora file but getting error like" no authentication protocol".
Facing an issue while trying to connect Oracle 19c instance using FME 2020.2.3 with oracle client 11 and 10 and jdbc driver 5,6,11. We tried adding below lines in sqlnet.ora file but getting error like" no authentication protocol".

we also trying adding below lines in sqlnet.ora

SQLNET.ALLOWED_LOGON_VERSION_CLIENT = 11

SQLNET.ALLOWED_LOGON_VERSION_SERVER = 11

Please assist on this case

 

 

Hi @anshuhk15​, could you please provide some more details about the error you're encountering, including the log file? You can find the log file in the same location as your saved workspace.

We have a Known Issue article that may relate to the issue you're seeing here: ORA-28040 No matching authentication protocol exception

 

Thanks,

Dan

Hi @anshuhk15​, could you please provide some more details about the error you're encountering, including the log file? You can find the log file in the same location as your saved workspace.

We have a Known Issue article that may relate to the issue you're seeing here: ORA-28040 No matching authentication protocol exception

 

Thanks,

Dan

Hi @danminneyatsaf​ , thanks for the link you suggested. It worked. We installed oracle client 12c and was able to connect to 19c instance. Thanks for your assistance.

Reply


Community Stats

30,167
Posts
114,519
Replies
37,824
Members
Terms & ConditionsCookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.