Learn how to a build a cloud-first strategyRegister Now


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

Posted on 2009-02-18
Medium Priority
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:
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.

Question by:heyday2004
LVL 14

Accepted Solution

ajexpert earned 1600 total points
ID: 23674890

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
LVL 23

Assisted Solution

David earned 400 total points
ID: 23692263
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.

Featured Post

Get your Conversational Ransomware Defense e‑book

This e-book gives you an insight into the ransomware threat and reviews the fundamentals of top-notch ransomware preparedness and recovery. To help you protect yourself and your organization. The initial infection may be inevitable, so the best protection is to be fully prepared.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In our personal lives, we have well-designed consumer apps to delight us and make even the most complex transactions simple. Many enterprise applications, however, are a bit behind the times. For an enterprise app to be successful in today's tech wo…
When it comes to protecting Oracle Database servers and systems, there are a ton of myths out there. Here are the most common.
This video shows how to copy a database user from one database to another user DBMS_METADATA.  It also shows how to copy a user's permissions and discusses password hash differences between Oracle 10g and 11g.
Video by: Steve
Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…
Suggested Courses
Course of the Month20 days, 19 hours left to enroll

810 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question