Message-ID: <F001.00518B54.20021212082349@fatcity.com>
Date: Thu, 12 Dec 2002 08:23:49 -0800
To: Multiple recipients of list ORACLE-L <ORACLE-L@fatcity.com>
Sender: root@fatcity.com
Reply-To: ORACLE-L@fatcity.com
Errors-To: ML-ERRORS@fatcity.com
From: Hemant K Chitale <hkchital@singnet.com.sg>
Subject: RE: Issues/Cautions Migrating Oracle DB across platforms
Organization: Fat City Network Services, San Diego, California
Precedence: bulk
Mime-Version: 1.0
Content-Type: text/plain; charset="us-ascii"; format=flowed
Content-Transfer-Encoding: 7bit


Yes, downtime currently isn't an issue.
We plan to attempt migration of new systems which are still in development --
thus only new applications will first go to HPUX.  If the development
database migrates successfully to HPUX [we will "test the development" !],
further development from that point will only continue against the HPUX
servers and we will "retire" the Solaris servers.

Hemant

At 06:33 AM 12-12-02 -0800, you wrote:
>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@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 :
>         1.  The right [same or higher] version of  the Oracle RDBMS +
>Patchset Release must be installed.
>         2.  The database should be created with a minimum block-size of 4K,
>preferably 8K.
>         3.  The database character-set should preferably be the same or a
>higher character-set.  [eg US7ASCII or WE8ISO8859P1 or UTF8]
>         4.  The NLS_LANG settings during the Export and Import must be
>complaint.
>
>
>Potential Issues :
>
>         1.  BFILE references will become invalid as BFILEs are stored
>outside the database.
>         2.  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@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@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@LIFETOUCH.COM
>
>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@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).

Hemant K Chitale
My web site page is :  http://hkchital.tripod.com


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Hemant K Chitale
  INET: hkchital@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@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).