I'm trying to track down a problem we are having with sql developer 3.1.07.42
to set up a new connection using the LDAP method, obtaining the
net service name from a sun one ldap server.
The net service names are stored in the sun one ldap server, ldap.ora is
configured correctly and tnsping and sqlplus successfully obtain a
databases netservice details, but sql developer doesn't.
When creating a new connection and specifying the connection type as ldap, after selecting
the required ldap server, instead of listing any contexts the error
Status: Failure -[LDAP: error code 32 - No Such Object]
It seems sqldeveloper extracts the available directory servers from the DIRECTORY_SERVERS
setting in ldap.ora but doesn't use the DEFAULT_ADMIN_CONTEXT setting.
Does sql developer query the directory server for a list of contexts ? If so, what ldap search
query does it use ?
Up until now we have only tested against Oracle Internet Directory.
Feature request: Retrieve Oracle connection from a LDAP other than the Oracle OID. ON sqldeveloper exchange.
"To bypass this problem i use the following connection:
Connection Type: Advanced
Custom JDBC URL: jdbc:oracle:thin:@ldap://MyLdapServ1:4001/MyConnectStringDB,cn=OracleContext,dc=MyDomain,dc=ch ldap://MyLdapServ2:4002/MyConnectStringDB,cn=OracleContext,dc=MyDomain,dc=ch"
Has anything happened on this request?
The exchange webpage is confusing and I donot get there, if this feature request is implemented/taken up for development / scheduled for future development?
We, like many other organiations use Microsoft Active Directory and SQL developer doesnot work with it.
As the Feature Request indicates, an enhancement request was logged. It is flagged as Published. Here is the BugDB reference: Bug 13370657 - ENH REQ: NEED SQL DEVELOPER LDAP CONNECTION CERTIFIED WITH ACTIVE DIRECTORY.
Perhaps Turloch can comment further.
Anyway, I would recommend going through Oracle Support to see if you can get the priority bumped on this. With Support, the bigger your company and the higher up in the management chain the request originates, the better.
SQL Developer Team