'Oracle 11g XE - ORA-31202: DBMS_LDAP: LDAP client/server error: SSL handshake failed when connecting AD

I'm trying to integrate my oracle 11g XE instance (version forced by product I'm working with) with Samba based Active Directory on port 636. Unfortunetally, I'm getting error ORA-31202: DBMS_LDAP: LDAP client/server error: SSL handshake failed. I've set oracle wallet, trying with openssl an keytool (using SE version), but it's not working with any of them. I've seen same problem here, but it was resolved by adding java procedure which is not supported by XE. If anybody could help me, I'd be really, really grateful. I'm storing my test procedure below, but it's nothing more than minimal required standard one:

declare
  l_retval varchar(100);
  p_session dbms_ldap.session;
  begin
  
    dbms_ldap.use_exception := true;
    p_session := dbms_ldap.init(hostname => 'myldaphost',
                                portnum  => 636);
                                
    l_retval := DBMS_LDAP.open_ssl (p_session,'file:/u01/app/wallet2',
                                    'xxxxx', 2);
                                
    l_retval := dbms_ldap.simple_bind_s(ld     => p_session,
                                   dn     => 'myuserdn',
                                   passwd => 'xxxxx');
  end;

#EDIT: That's why I've managed to capture with tshark:

    1 0.000000000  10.10.30.58 → 10.10.30.29  TCP 74 34068 → 636 [SYN] Seq=0 Win=64240 Len=0 MSS=1460 SACK_PERM=1 TSval=1812804240 TSecr=0 WS=128
    2 0.001134994  10.10.30.29 → 10.10.30.58  TCP 74 636 → 34068 [SYN, ACK] Seq=0 Ack=1 Win=65160 Len=0 MSS=1460 SACK_PERM=1 TSval=3244251678 TSecr=1812804240 WS=128
    3 0.001194794  10.10.30.58 → 10.10.30.29  TCP 66 34068 → 636 [ACK] Seq=1 Ack=1 Win=64256 Len=0 TSval=1812804241 TSecr=3244251678
    4 0.062087948  10.10.30.58 → 10.10.30.29  SSLv2 133 Client Hello
    5 0.063469940  10.10.30.29 → 10.10.30.58  TCP 66 636 → 34068 [ACK] Seq=1 Ack=68 Win=65152 Len=0 TSval=3244251740 TSecr=1812804302
    6 0.063480740  10.10.30.29 → 10.10.30.58  TCP 66 636 → 34068 [FIN, ACK] Seq=1 Ack=68 Win=65152 Len=0 TSval=3244251740 TSecr=1812804302
    7 0.063532740  10.10.30.58 → 10.10.30.29  SSLv3 73 Alert (Level: Fatal, Description: Close Notify)
    8 0.063556040  10.10.30.58 → 10.10.30.29  TCP 66 34068 → 636 [FIN, ACK] Seq=75 Ack=2 Win=64256 Len=0 TSval=1812804303 TSecr=3244251740
    9 0.064059637  10.10.30.29 → 10.10.30.58  TCP 60 636 → 34068 [RST] Seq=2 Win=0 Len=0


Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source