Re: upgrading oracle through copying files

Oh, absolutely please don't DO this! As has been already said, you should use the ICG specific for your platform. and the CD or other Oracle media, and apply the upgrade as directed, or Oracle Support will hang up on you.

The only exception I can think of is a site where we had two perfectly identical Sun E9000's, down to disk and partition and file systems, everything. To avoid total chaos and shutting a factory down, the SA would image copy all disks from Prod to Test (with Prod down of course), and we would test-apply Oracle and Oracle Apps upgrades, releases, and patches on the mirror machine, first. So we'd avoid, say, breaking Oracle Purchasing with 250 invalid objects, on production.

I took down detailed notes, spent hours on the phone with Oracle, etc. When we had it down cold and perfect, then we applied the patch to production. That saved our lives a number of times.

Not everybody can afford an E9000 rigged out just like production, for such a purpose, but if you have the money to do it, I highly recommend it.

RSH. "Sharkie" <sharkdba_at_yahoo.com> wrote in message news:423b5ab1.0202220945.6d0d6550_at_posting.google.com...
> I have two Oracle 8i servers running on two Sun Sparc Solaris boxes.
> One is 8.1.6 the other one 8.1.7
> 8.1.6 is currently not in use by anyone, and I'd like to upgrade it
> to 8.1.7. Can I do this upgrade by copying certain files over from
> the 8.1.7 box? It seems doable, but since I've never done it this way,
> and this box will be used in production environment, I want to be sure,
> there are no hidden problems with this solution.
>
> The two boxes are networked together, so communication is no problem.
Received on Fri Feb 22 2002 - 15:17:46 CST