Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

dbms_ldap.open_ssl - ORA-31202: DBMS_LDAP: LDAP client/server error: SSL handshake failed

Farhan SiddiquiMay 23 2015 — edited May 29 2015

I am trying to connect to AD server using PL SQL on SSL port (636), but it thows the error - ORA-31202: DBMS_LDAP: LDAP client/server error: SSL handshake failed

When I connect on port 389, it works fine. My requirement is that, I want to create a user on AD using PL SQL. But when connected on port 389 and I execute the process to create user, it creates a disabled user.

After a little research I found that if I need to create a normal user, I need to send the password in Unicode encryption. The unicode password can be created only when connected in SSL mode.

So, I created an oracle wallet to use in dbms_ldap.open_sslĀ  procedure, after getting the certificates (.cer) files from Trusted Root Certification Authorities. I used Equifax and GeoTrust Global and GeoTrust Primary. There are more than 30 certificates, so I chose these 3 after suggestion at some blogs.

So now, even after all these efforts, I am not able to connect to AD on SSL. Please help me or show me some article which could help me to resolve this issue.

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 26 2015
Added on May 23 2015
2 comments
4,325 views