We don't technically support OpenLDAP
searching an LDAP provider is supported for Oracle Internet Directory only at this time
developer suggests attempting connecting via TNS identifier with a thick driver connection, sqlnet.ora, ldap.ora setup
Thanks Jeff, I also have an open Development request open via bug filed from an SR. All other tools and applications seem to work and since posting this I've found quite a few folks having the same issue. Could you happen to share the ldapsearch that Oracle sql developer does when the load button is pressed? I'd love to run that manually against my openldap to see if I can replicate the issue. Perhaps knowing that I can find some work around or some parameter that can be added to the slapd.conf. Know what I mean?
Actually, we found our problem. The issue was openldap was limiting the ldapsearch resultset SQL Developer was doing to 500, after altering the slapd.conf on both master and slave openldap servers we have for sizelimit to unlimited SQL Developer now returns all 800+ of our DB Service names in the drop down. I'll mark this as resolved.
Would you mind sharing your openLDAP slapd.conf, ldap hiararchy sqlnet (ldap.ora, sqlnet.ora etc), a lot of the community would find it really useful to see how you got it to work (especially me!)