Couple of days back, I started to get the following error, whenever I tried to connect to any Oracle Autonomous Database Cloud Service from SQL*Plus on my laptop (which was usually working fine for years):
ORA-29003: SSL transport detected mismatched server certificate

So, I reviewed the sqlnet.ora file under the working Oracle Home, and I found the following entries related to the autonomous databases (added couple of years back for some reason that I didn’t remember):

So, I just changed the parameter “SSL_SERVER_DN_MATCH” from “yes” to “no”, and the issue was resolved and I was able to connect to my database:

But what is “SSL_SERVER_DN_MATCH”?. Let us see the Oracle documentation:

Hope this helping anyone facing the same issue nowadays.
Thanks
Ahmed