ORA-29003 while connecting to ADB from 12c client using new mTLS authentication
(Doc ID 2925777.1)
Last updated on FEBRUARY 09, 2023
Applies to:
Autonomous Database on Shared Infrastructure - Version N/A and laterInformation in this document applies to any platform.
Symptoms
++ Getting ORA-29003 while connecting from 12c client to ADB using new mTLS authentication :
sqlplus admin@'(description= (retry_count=20)(retry_delay=3)(address=(protocol=tcps)(port=1522)(host=adb.us-ashburn-1.oraclecloud.com))(connect_data=(service_name=test.adb.oraclecloud.com))(security=(ssl_server_dn_match=yes)))'
SQL*Plus: Release 12.1.0.2.0 Production on Mon Jan 30 07:37:27 2023
Copyright (c) 1982, 2014, Oracle. All rights reserved.
Enter password:
ERROR:
ORA-29003: SSL transport detected mismatched server certificate.
++ Same works fine with 19c client :
sqlplus admin@'(description= (retry_count=20)(retry_delay=3)(address=(protocol=tcps)(port=1522)(host=adb.us-ashburn-1.oraclecloud.com))(connect_data=(service_name=test.adb.oraclecloud.com))(security=(ssl_server_dn_match=yes)))'
SQL*Plus: Release 19.0.0.0.0 - Production on Tue Jan 31 06:28:45 2023
Version 19.18.0.0.0
Copyright (c) 1982, 2022, Oracle. All rights reserved.
Enter password:
Last Successful login time: Tue Jan 31 2023 06:27:55 -05:00
Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.18.0.1.0
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Symptoms |
| Cause |
| Solution |
| References |