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!
Please sign in to leave a comment.
You can refer to Oracle documentation:
or
Also, there is a good article by Razor SQL:
jdbc:oracle:thin:@ldap://<LDAP Server String>/<Database Service Name>,<LDAP Context>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.
@...,
Could you provide a sample URL that is not recognized?
vasily chernov, could you please let me know your email address? I do not want to release the URL publicly.
The error message "unable to find host/port in URL" only seems to appear if I enable SSH tunneling
And the error message also appears with the sample URL above, provided I try to enable SSH tunneling.
Feel free to e-mail me vasily.chernov@jetbrains.com
I've sent you and email with a sample URL. The problem occurs when SSH tunnelling is activated.
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.
did anyone manage to do this?
I'm trying to connect datagrip to an oracle server via LDAP and it is just impossible…