Forum Stats

  • 3,825,744 Users
  • 2,260,557 Discussions
  • 7,896,657 Comments

Discussions

DRM-11037 when trying to use Oracle LDAP connection string

We set up Oracle LDAP (a.k.a OID) to resolve connect identifiers, e.g.

C:\Temp>tnsping hiss19c

...

Used LDAP adapter to resolve the alias

Attempting to contact (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=<SCAN of RAC>)(PORT=1521)))(CONNECT_DATA=

(SERVICE_NAME=hisssvc)))

OK (110 msec)

(where SCAN of RAC means the cluster DNS "host" name of the RAC database)

and sqlplus works. In %oracle_home%\network\admin\sqlnet.ora, "LDAP" is a value for NAMES.DIRECTORY_PATH and the file ldap.ora is in place. The connect identifier "hiss19c" is not in tnsnames.ora.

Now we want to use this connect identifier in DRM. On the screen to set up database connection string, we tried both the following:

Data Source=hiss19c

DATA Source=jdbc:oracle:thin:@ldap://<our oid server>:389/hiss19c,cn=OracleContext,dc=<domain>

we get error DRM-11037 (Could not open database connection within the specified timeout period). But hardcoding the database hostname does work:

Data Source=<SCAN of RAC>:1521/hisssvc

But we want to avoid hardcoding the database hostname here and want to use Oracle LDAP to resolve the connection instead. Is it possible?