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.
[EMAIL PROTECTED]
-----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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
