Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I have a group of clients, Windows server 2008 R2(Active Directory Installed in it), and an oracle database Server

I Want to know how to make the configuration of the following Diagram in this link:

So how to configure the clients to reach the database server through the active directory?

enter image description here


If Active Directory is not of any use here (as comments suggest), is there another way I can do remote routing from clients to the DB server through a proxy?

share|improve this question
What are you really asking? You want clients to use AD authentication? Connecting through AD makes no sense. – Phil Apr 29 '13 at 15:37
Or do you just want to use AD for TNSNAMES lookup? This is possible but based on my experience I don't recommend it for anything but the largest of setups. – Colin 't Hart Apr 29 '13 at 15:40
Active directory is basically an authentication and name resolution service. I wouldn't recommend trying to use it for TNSNAMES or anything. Can you be MUCH more specific about the result you are looking for? – mrdenny Apr 29 '13 at 15:42
For TNSNAME resolution, I would make one canonical set of sqlnet.ora, tnsnames.ora and put it on a network share. Add TNSADMIN=\\path\to\share in the registry of all Oracle homes on all clients. It's a simple, effective solution dating from the 1990's that still works today. – Colin 't Hart Apr 29 '13 at 15:47
Why do you need Active Directory to act as a proxy for database connections? Doesn't make a great deal of sense. – Phil May 1 '13 at 14:24
up vote 0 down vote accepted

If you need an Oracle proxy server, then you should investigate Oracle Connection Manager, which is exactly that.

See for the documentation on 11gR1's version of it.

share|improve this answer
Thank you Colin but I was working on Oracle Connection Manager and I failed to set it up as I mentioned here… – Saf1 May 1 '13 at 15:52
Oracle Connection Manager is the answer ^_^ – Saf1 May 6 '13 at 15:11

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.