Re: Copying Oracle software between Unix servers
- From: Carel-Jan Engel <cjpengel.dbalert@xxxxxxxxx>
- To: chris@xxxxxxxxxxxxxxxxxxxxx
- Date: Fri, 01 Apr 2005 09:38:46 +0200
At a site I'm working for, (using NIM), we will use response files.
We're in the middle of developing scripts and parameter-structures,
which will enable us to roll out any install with just one script-call.
Important part is that ORACLE_HOME naming is extended: e.g. 9.2.0.6.0.a
represents the 9.2.0.6.0 version, first install. Any 'one-off' patch
will cause the last position to increase. The install-script knows (by
parameters) of pre-requisites. The 9.2.0.6. patchset will only be
installed after 9.2.0.1 (or ..4, depending on parameter settings) is
installed in the 9.2.0.6.0.a directory. The inventory is isolated, by
maintaining an oraInst.loc file per installed version. The
response-files have placeholders, substituted for the 'real' values
before the script executes the installer.
Advantages:
- one ORACLE_HOME per version, to the lowest version level. This enables
us to host numerous databases on one host, whithout the need to patch
them all at once, and even being able to leave some of them unpatched
(if it ain't broke, don't fix it)
- automated installations of software on new boxes, enabling the SA's to
do the full software install. Needless to say that automated
installations help to standardize the modus operandi.
- Pre-requisite-tests in the script: A software-copy doesn't check
whether the right OS-patches have been applied. Our script will do that.
- No risk of overwriting already existing software. The script prevents
this.
- for GC, agent and iAS-installs: all hard-coded servernames,
IP-adresses and whatever will be taken care of by the installer
There will be some disadvantages as well:
- X-server needed for pre-10g installs
- find out about the response-files, put the placeholders in there
- create and maintain the mother-of-all-install-scripts
Best regards,
Carel-Jan Engel
===
If you think education is expensive, try ignorance. (Derek Bok)
===
On Fri, 2005-04-01 at 09:19, Chris Dunscombe wrote:
> Dave,
>
> I agree. A couple of years back we managed to mess up an 8i installation on
> dev
> server by copying the software (Oracle worked fine but not patching etc. was
> possible). The issue related to the inventory and various "pointers" about
> file
> locations etc, can't remember the details (too long ago).
>
> Anyway I believe that if you're very careful and edit appropriate files (on
> Unix) then you can do it safely but it's definately safer to do proper
> installs.
>
> Chris
>
>
> Quoting David Sharples <davidsharples@xxxxxxxxx>:
>
> > yes you can really mess up the inventory and then you are unable to patch it
> >
> >
> > On Thu, 31 Mar 2005 08:19:06 -0500, Luc Demanche <lucdemanche@xxxxxxxxx>
> > wrote:
> > > Hi,
> >
> > > Do you have some bad stories about that?
> > --
> > //www.freelists.org/webpage/oracle-l
> >
>
>
> Chris Dunscombe
>
> www.christallize.com
> --
> //www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
