Link to home
Start Free TrialLog in
Avatar of ammounpierre
ammounpierre

asked on

Oracle TNS Name ...

Hello Gurus

I am taking over an old network that has an Oracle DB V.8.1.17
I have some problems with the network I hope somebody can help me.
I need to install a Win2008 Domain controller.
Here is the setup as it is now....(very old setup)

-Windows 2000 Server - Oracle Db on it. Application too..
  No Domain controller.

-On each PC that needs to connect to the oracle database has to have its DNS setting to the server IP (which is 192.168.0.1)

This is where my problems start...
If a user has to access the Oracle Db and the Internet ... I have a problem because the server (win2000) has no internet access (to protect it)
The way to this was to use a proxy server.. (they have now something called spoon proxy)..
which is an archaic application...

I need to install a windows 2008 domain controller because they are getting a new ERP but I need also to have the Oracle DB online since it will stay online for sometime now (for archiving issues...etc...)

So my questions is how do I set up windows 2008 Domain controller living next to the Oracle DB ?

Thanks a lot
Avatar of Alan Gunn
Alan Gunn
Flag of United Kingdom of Great Britain and Northern Ireland image

Hi!
Not much response to your query :-)

I believe you can put in the 2008r2 DC and set up a forest and domain without much trouble.
Add the 2000 server to the 2008 domain as a member server.

Did you mean the workstations that access the Oracle Database need a TNS name set to that server's IP?
If so, this should still work as long as the 2000 server stays on the same IP.

What server is the Spoon Proxy running on?

It should still be useable if you set the workstations IE to point to the local address of the proxy in the "Connections" settings.

The best way to do this is with Group policy on the 2008 DC.

All a little vague I'm afraid but it all sounds do-able. :-)


Kind regards.

TRM
Avatar of ammounpierre
ammounpierre

ASKER

Im intending to remove the spoon proxy and replace it by something more industrial strength... Any idea what are my options ?
ASKER CERTIFIED SOLUTION
Avatar of Alan Gunn
Alan Gunn
Flag of United Kingdom of Great Britain and Northern Ireland image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Microsoft also have a proxy offering.

http://en.wikipedia.org/wiki/ISA_Server
Is forefront fairly  "easy" to implement ?