'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 |
|---|
