Discussions
Categories
- 196.8K All Categories
- 2.2K Data
- 238 Big Data Appliance
- 1.9K Data Science
- 450.2K Databases
- 221.7K General Database Discussions
- 3.8K Java and JavaScript in the Database
- 31 Multilingual Engine
- 550 MySQL Community Space
- 478 NoSQL Database
- 7.9K Oracle Database Express Edition (XE)
- 3K ORDS, SODA & JSON in the Database
- 544 SQLcl
- 4K SQL Developer Data Modeler
- 187K SQL & PL/SQL
- 21.3K SQL Developer
- 295.8K Development
- 17 Developer Projects
- 138 Programming Languages
- 292.5K Development Tools
- 107 DevOps
- 3.1K QA/Testing
- 646K Java
- 28 Java Learning Subscription
- 37K Database Connectivity
- 154 Java Community Process
- 105 Java 25
- 22.1K Java APIs
- 138.1K Java Development Tools
- 165.3K Java EE (Java Enterprise Edition)
- 17 Java Essentials
- 160 Java 8 Questions
- 86K Java Programming
- 80 Java Puzzle Ball
- 65.1K New To Java
- 1.7K Training / Learning / Certification
- 13.8K Java HotSpot Virtual Machine
- 94.3K Java SE
- 13.8K Java Security
- 204 Java User Groups
- 24 JavaScript - Nashorn
- Programs
- 436 LiveLabs
- 38 Workshops
- 10.2K Software
- 6.7K Berkeley DB Family
- 3.5K JHeadstart
- 5.7K Other Languages
- 2.3K Chinese
- 171 Deutsche Oracle Community
- 1.1K Español
- 1.9K Japanese
- 232 Portuguese
ORA-00542: Failure during SSL handshake

Hello,
I have to change my c# project the Oracle-Database access by SSL (wallet).
I get the certificate for the wallet and create the wallet by myself:
orapki wallet create -wallet walletpath -pw PASSWORT -auto_login
orapki wallet add -wallet walletpath -trusted_cert -cert certificate.pem
mkstore -wrl walletpath -createCredential tnsalias username password
Without SSL all works fine. But with SSL and a wallet I get the error "ORA-00542" (see the Oracle trace file). It sounds like a problem with the certificate. Is the certificate wrong or the creation of the wallet?
I have tried ODP.NET 21.6.1 and 19.5.1 (Oracle.ManagedDataAccess)
Thanks for any help
Answers
-
It looks like the inner exception is reporting "The remote certificate is invalid according to the validation procedure" as translated from German.
The ODP.NET doc has some step-by-instructions for setting up SSL configuration, which I linked to below. Further down in the same documentation section, there are some ODP.NET SSL troubleshooting recommendations.
-
I had already found this website and I have tested different configuration. Any other idea?
-
You got an untrusted root error.
Can you try adding that CA pub certificate to the root/localmachine store? You should also try removing the following from app.config AND sqlnet.ora:
SSL_SERVER_DN_MATCH : ON
SSL_CIPHER_SUITES : (SSL_RSA_WITH_AES_256_CBC_SHA,SSL_RSA_WITH_AES_256_CBC_SHA256)
If you still see an error after these changes, please provide the trace.
Are you trying to connect to Oracle Autonomous DB with a wallet or with one-way TLS?