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".
Best answer by danminneyatsaf
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
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.
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
+13- Safer
- 485 replies
- Best Answer
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.