Has anyone tried to use Oracle Directory Server Discovery (Developing Applications With Oracle Extensions to the Standard APIs - 11g Release 1 (11.1.1))?
I mean, is it possible to employ the next configuration:
setup dns system with SRV records for _ldap._tcp._oid.domain.com
use sqlplus without TNS_ADMIN configs/jdbc in form of ldap:///<tnsname> (which stands for cn=<tnsname>,cn=OracleContext,dc=domain,dc=com) or ldap:///cn=<tnsname>,ou=uk,dc=domain,dc=com
the client component do resolve ldap directory server location through DNS and just substitutes it in exsting forms of urls (like sqlnet/ldap://ldapserver.domain.com)?
I thought it could be more interesting in enterprise environment than distributing config files along with a client.
How applicable is this for any 3-tier application?
JDBC:THIN does not require any of the above.
Is this a solution in search of a problem?
Thin URLs are (according to Data Sources and URLs)
- oracle net connection description - lacks updateability when something changes in host/port/sid combination
- thin-style - the same problem
- tnsnames alias syntax - requires external file to resolve tns names
- ldap-syntax - requires directory to resolve tns names, but lacks updateability when something changes in LDAP layer - host, port
My question is about ldap syntax specifics. While it is possible to manage specifics of LDAP layer in DNS, is it possible to force jdbc thin client use that from DNS?