This discussion is archived
4 Replies Latest reply: Dec 9, 2013 6:15 AM by 889524 RSS

SQL Developer and LDAP Name Resolution

Brian Bontrager Expert
Currently Being Moderated

We have a database service configured in LDAP (OID) to resolve to one of two sites, depending whether it is running on the primary or standby server.  The connection details are in this format:

 

(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=prodserver.company.com)(PORT=1521))(ADDRESS=(PROTOCOL=TCP)(HOST=drserver.company.com)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=db.company.com)))

 

When sqlplus or TOAD get this connection string from LDAP, they connect just fine, trying the second server as expected.  When SQL Developer does this (connection defined as an LDAP connection type) it works if the database is running from prodserver, but not drserver. During a recent DR exercise the connection failed in SQL Developer with "ORA-12514: TNS listener does not know of service requested in connect descriptor. "

 

In the Connection Details pane of the connection properties, It appears that SQL Developer is parsing out the first host from the connect string it receives from LDAP and using that, never trying the DR site.  My workaround is to use a connection type of TNS and put the entire string above in the Connect Identifier field.  This is not ideal, since I am bypassing LDAP, but it does work around this issue.

 

Am I interpreting the SQL Develoepr behavior correctly, and does this sound like the a bug (I'm running 3.2.20.09)?

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points