We help IT Professionals succeed at work.

We've partnered with Certified Experts, Carl Webster and Richard Faulkner, to bring you two Citrix podcasts. Learn about 2020 trends and get answers to your biggest Citrix questions!Listen Now

x

How to clone Oracle client and Oracle ODBC set up to another machine?

Medium Priority
1,417 Views
Last Modified: 2013-12-19
I have one server A, it has Oracle 9 client and Oracle ODBC driver installed. Now I need to install the identical Oracle client and Oracle ODBC driver on another machine B. What is the best strategy? One easy way I could think of is:
Copy these two directories in machine A to machine B:
D:\oracle\ora92\*.*
C:\Program Files\Oracle

And export the registry setting in machine A to machine B (will this affect other registry settings in machine B?)

Is this a 100% correct solution? Is there anything missing here? Of course, I can find an Oracle 9i installation CD, but still a lot of work to do to copy registry settings, manually set up ODBC connections, etc. to machine B. I appreciate it if there is any easy and safe solution to just copy files from machine A to machine B.



Comment
Watch Question

Commented:

Playing with windows registry is dicey unless you are expert.

You can download Oracle drivers from Oracle site, and set up ODBC connection.

I believe this will not take much time and safest way to do

Not the solution you were looking for? Getting a personalized solution is easy.

Ask the Experts
David VanZandtSr Software Engineer
CERTIFIED EXPERT
Commented:
My advice-  the tried and true best practice is to use the Oracle Installer on each client.  Remember you have environment variables and services required as well.
Access more of Experts Exchange with a free account
Thanks for using Experts Exchange.

Create a free account to continue.

Limited access with a free account allows you to:

  • View three pieces of content (articles, solutions, posts, and videos)
  • Ask the experts questions (counted toward content limit)
  • Customize your dashboard and profile

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.