Oracle Ldap

Answered

how can I connect to oracle using ldap?

what kind of connection should I choose? (sid, service name, tns or url)

thanks!

9 comments
Comment actions Permalink

You can refer to Oracle documentation:

"jdbc:oracle:thin:@ldap://ldap.acme.com:7777/sales,cn=OracleContext,dc=com"

or

"jdbc:oracle:thin:@ldaps://ldap.acme.com:7777/sales,cn=OracleContext,dc=com"

 

Also, there is a good article by Razor SQL:

jdbc:oracle:thin:@ldap://<LDAP Server String>/<Database Service Name>,<LDAP Context>

0
Comment actions Permalink

I'm trying to connect to an Oracle Database using an Oracle JDBC URL with an LDAP reference in it through an SSH tunnel. I have entered a URL like the one you've shown and Data Grip doesn't even recognize the URL format.

I get the error message "unable to find host/port in URL"

What is supposed to happen instead is that Data Grap should

- open an LDAP connection _through the SSH tunnel_
- perform an LDAP lookup using the LDAP query in the JDBC URL
- retrieve connection parameters from LDAP there
- connect to the database pointed to in the retrieved connection parameters

Usually this is functionality of the JDBC driver itself. I'm not sure why you're trying to parse the URL here.

0
Comment actions Permalink

Georg Berky,

Could you provide a sample URL that is not recognized?

0
Comment actions Permalink

vasily chernov, could you please let me know your email address? I do not want to release the URL publicly. 

0
Comment actions Permalink

The error message "unable to find host/port in URL" only seems to appear if I enable SSH tunneling

0
Comment actions Permalink

And the error message also appears with the sample URL above, provided I try to enable SSH tunneling.

0
Comment actions Permalink

I've sent you and email with a sample URL. The problem occurs when SSH tunnelling is activated.

1
Comment actions Permalink

Good morning, I am having the same issue with DataGrip.  This is an issue with DataGrip, not Oracle, their tool (Oracle SQL Developer) works with no issue.  

Can JetBrains team provide a working example of LDAP setup that works with screen shots

to see what was done to get it working? 

I can get this working on Oracle SQL Developer and Toad for Oracle but it's been a challenge to get it to work on DataGrip.  Has anyone had success with configuring LDAP for DataGrip?  I purchased a single license of this tool and evaluating it for team, if we cannot get LDAP to work with DataGrip there is no point in moving forward. 

 

0

Please sign in to leave a comment.