Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Moving to new Server and upgrading Oracle

Moving to new Server and upgrading Oracle

From: A <A_at_yahoo.com>
Date: 2000/06/16
Message-ID: <394B16F2.73F79DEE@yahoo.com>#1/1

We are currently running Oracle 8.0.5.2 on Solaris 2.7 on a Sun E4500. Because of rapid growth, we are moving to an Oracle HA/Clustered environment on an E10000, and will be running Oracle 8.0.6 (not all of our apps run on 8i :-(( ).
Currently our databases are not large enough to rule out an export/import to accomplish the move and upgrade. (One would involve a full export/import, and then an outage with incremental export/import, all others could be accomplished with just an outage and full export/import).
However, I am not sure if that is the approach that will be recommended by Sun Professional Services.

Can anyone provide their views on the pros and cons of just installing 8.0.6 on the new E10000 and doing an export/import of the data (which would definitely help with some
tablespace fragmentation on a couple of the db's) , vs. moving the datafiles over with an Oracle 8.0.5 install and upgrading?

I would prefer the export/import option, but would like to see others views.

TIA Received on Fri Jun 16 2000 - 00:00:00 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US