Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

Quicker Method to replicate Oracle Software

Posted on 2011-04-22
4
Medium Priority
?
281 Views
Last Modified: 2012-05-11
Need to install Oracle 11.2.0.1 Enterprise Database on several servers (8 separate machines).  I have already installed on my first server and want to expedite this to the other servers.  Trying to avoid loading DVD and going through the menus, etc. seven more times.  Seem to remember a method of tar-ring up the oracle software, then un-tarring on the next server, and running perl clone.pl.  Anybody familiar with this approach?
0
Comment
Question by:sdruss
4 Comments
 
LVL 78

Expert Comment

by:slightwv (䄆 Netminder)
ID: 35451074
My unix is old but I remember being able to copy the $ORACLE_HOME acorss machines.

You just need to know what else you need.  Then you should be able to just rerun the root.sh on the new machine.

That said, have you ever thought about the silebt install option?  Place the software on a share, and run it.  No prompts, no fuss.  Exactly the same all the time.
0
 
LVL 23

Accepted Solution

by:
OP_Zaharin earned 2000 total points
ID: 35451177
0
 
LVL 40

Expert Comment

by:mrjoltcola
ID: 35451443
Oracle differentiates between "software / binaries" and "instances / databases". Moving the Oracle software itself is pretty easy. tar will work. I usually pipe it over ssh or rsh. Something like:

tar cvf - /u01 |ssh server2 "cd / ; tar xvf -"

This is the software only, not the database instances. So during the server1 install, choose "Install Oracle Software Only".

When you copy include:
1) Oracle home
2) Oracle inventory (wherever you chose to locate Oracle base usually has it). Look for $ORACLE_BASE/oraInventory

Prior to copying the directories to new servers, setup the oracle user with same user id and group ids (dba, etc.), and clone the .profile or /etc/profile. Also do run root.sh as slightwv said, which will create your /etc/oratab and set permissions. Also ensure you setup your init script so dbstart will
 boot Oracle at OS boot time.

Once you are done, you should be able to login to each and run "dbca" and "netca" to create Oracle instances and listeners.
0
 
LVL 1

Author Closing Comment

by:sdruss
ID: 35464303
Good websites.
0

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Question has a verified solution.

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

How to Create User-Defined Aggregates in Oracle Before we begin creating these things, what are user-defined aggregates?  They are a feature introduced in Oracle 9i that allows a developer to create his or her own functions like "SUM", "AVG", and…
Background In several of the companies I have worked for, I noticed that corporate reporting is off loaded from the production database and done mainly on a clone database which needs to be kept up to date daily by various means, be it a logical…
This video shows how to Export data from an Oracle database using the Original Export Utility.  The corresponding Import utility, which works the same way is referenced, but not demonstrated.
This video explains what a user managed backup is and shows how to take one, providing a couple of simple example scripts.
Suggested Courses
Course of the Month11 days, 1 hour left to enroll

571 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