Oracle-L: RE: Issues/Cautions Migrating Oracle DB across platforms

From: DENNIS WILLIAMS <DWILLIAMS_at_LIFETOUCH.COM>
Date: Thu, 12 Dec 2002 06:33:39 -0800
Message-ID: <F001.005188D7.20021212063339@fatcity.com>

Hemant - You didn't mention performance issues. Is your database small enough and your downtime window large enough that performance isn't a big issue? That is nice when it happens. Also, I assume that you will do this entire process as a test first, and let your users check it out for anything missing.

Dennis Williams
DBA, 40%OCP
Lifetouch, Inc.
dwilliams_at_lifetouch.com

-----Original Message-----
Sent: Wednesday, December 11, 2002 8:54 PM To: Multiple recipients of list ORACLE-L

We are considering migrating some Oracle Databases across platforms -- from Solaris to HPUX. We'll, of course, be using Export-Import.

I've been asked to come up with a list of issues / cautions to consider.

e.g. I can think of

Pre-Requisites :

The right [same or higher] version of the Oracle RDBMS + Patchset Release must be installed.
The database should be created with a minimum block-size of 4K, preferably 8K.
The database character-set should preferably be the same or a higher character-set. [eg US7ASCII or WE8ISO8859P1 or UTF8]
The NLS_LANG settings during the Export and Import must be complaint.

Potential Issues :

BFILE references will become invalid as BFILEs are stored outside the database.
If there are tables containing LOBs, the import can be slower. [There was an 8i bug requiring COMMIT=Y to improve Import performance but commiting at every record, instead of at every buffer-size].

Recommendations / experiences appreciated.

Hemant K Chitale
http://hkchital.tripod.com
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Hemant K Chitale
INET: hkchital_at_singnet.com.sg

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: DENNIS WILLIAMS
INET: DWILLIAMS_at_LIFETOUCH.COM

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------