Re: HP-Sun Cross Platform Migration - Exp/Imp, CTAS over dblink or ..
Sashidar: In THEORY HP datafiles and Sun data files are compaible. That is you can just move the HP data files to the Sun server and recreate the data files. Both data files are in same endianness and they are cross platform compatible. There is no tool to convert a datafile from one OS format to another OS format. Some time back, some one (Guess who??) tried developing a tool and the idea was dropped since Oracle started addressing this issue as a standard feature inside the RDBMS product. So there is no third party tool available in the market to do that conversion and I don't expect any new tools to do that. Having said that, that above said method is NOT officially supported by Oracle in current versions. You have to wait for some more time to get that officially supported by Oracle (clue!!) If you have a faster interconnect CTAS will be much faster than export import method, I remember seeing some comparitive numbers in Metalink.. Have you checked that? = Have a nice day !! Best Regards, K Gopalakrishnan, Bangalore, INDIA. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: K Gopalakrishnan 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).
RE: HP-Sun Cross Platform Migration - Exp/Imp, CTAS over dblink or ..
Exp/imp of a 200GB database is possible, but I'd think the time required would be the long pole in the tent. I'd say your looking at at least a 4 day weekend at best and only if you used direct mode. Someone has hinted that you can simply move the datafiles from one box to the other. Well I'd not loose the original system before you prove that. My experience with database file from Solaris to HP-UX has been a 100% loss of data. Granted that was on a much earlier version of Oracle (6.0.x). Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -Original Message- Sent: Saturday, June 07, 2003 7:29 AM To: Multiple recipients of list ORACLE-L .. Hi all: We are considering migration of an Oracle eBusiness Suite 11.5.8 from HP-UX 11.0 to Solaris9. I'd like to know if anyone has done this and how daunting the task is. Are there any 3rd Party tools which can help out? Coming to the conventional approaches: 1. What do you think of Export/Import of a 200 GB database? 1a. How much time will it take? 1b. Any strategies for cutting that down? 2. How does CTAS over dblink compare to Export/Import? 3. Is there any tool that converts Oracle datafiles on HP-UX 11.0 to Oracle datafiles on Solaris 9. If so we would just need to recreate the control files on the target database and we are done. Any suggestions, pointers, words of wisdom are greatly appreciated... Thanks & Regards, Sashi -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Sashidhar Kondareddy 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.net -- Author: Goulet, Dick 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).
RE: HP-Sun Cross Platform Migration - Exp/Imp, CTAS over dblink or ..
You may want to review an article, "Cross Platform Migration of a Large Production Database", in the latest issue(2nd Qtr 2003) of SELECT journal (by IOUG). The author details the procedure he followed to migrtate a 300GB production database from HP-UX to IBM AIX. - Kirti --- "Goulet, Dick" <[EMAIL PROTECTED]> wrote: > Exp/imp of a 200GB database is possible, but I'd think the time required would be > the long pole > in the tent. I'd say your looking at at least a 4 day weekend at best and only if > you used > direct mode. Someone has hinted that you can simply move the datafiles from one box > to the > other. Well I'd not loose the original system before you prove that. My experience > with > database file from Solaris to HP-UX has been a 100% loss of data. Granted that was > on a much > earlier version of Oracle (6.0.x). > > Dick Goulet > Senior Oracle DBA > Oracle Certified 8i DBA > > -Original Message- > Sent: Saturday, June 07, 2003 7:29 AM > To: Multiple recipients of list ORACLE-L > .. > > > Hi all: > > We are considering migration of an Oracle eBusiness Suite 11.5.8 from > HP-UX 11.0 to Solaris9. > > I'd like to know if anyone has done this and how daunting the task is. > > Are there any 3rd Party tools which can help out? > > Coming to the conventional approaches: > > 1. What do you think of Export/Import of a 200 GB database? > 1a. How much time will it take? > 1b. Any strategies for cutting that down? > > 2. How does CTAS over dblink compare to Export/Import? > > 3. Is there any tool that converts Oracle datafiles on HP-UX 11.0 to > Oracle datafiles on Solaris 9. If so we would just need to recreate the > control files on the target database and we are done. > > Any suggestions, pointers, words of wisdom are greatly appreciated... > > Thanks & Regards, > Sashi > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Sashidhar Kondareddy > INET: [EMAIL PROTECTED] > __ Do you Yahoo!? Yahoo! Calendar - Free online calendar with sync to Outlook(TM). http://calendar.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Kirtikumar Deshpande 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).
RE: HP-Sun Cross Platform Migration - Exp/Imp, CTAS over dblink or
1. Join the 10i beta program 2. Convert your 9.2 datafiles using the cross-platform transportable tablespaces feature of a dummy 10i instance. ;-) Or... Back when one of our system swas at around 200M, we had a C program that dumped table data in parallel by rowid ranges, wrote the streams in SQL*Loader native format to named pipes that were being dd'd with large block sizes across a fast network, to several SQL*Loader processes on the other side using direct/unrecoverable. We ran several of these at a time. As soon as a table would finish we would kick off the index creation in parallel/unrecoverable mode. The goal was to get both the source and target hosts as close to 100% utilization as possible. This was Oracle 8.0.5, migrating Compaq Tru64 (DEC OSF to HP-UX 11 64-bit. The migration took 6 hours. It shouldn't have even taken that long, but we were clumsy in a few ways. There's a lot involved in a migration. Lots of dependencies and details to think about. I recommend repeated practice runs on test equipment before trying the real thing. There's a lot of blood to be squeezed out of this stone to get the time down and reliability up. -- Jeremiah Wilton http://www.speakeasy.net/~jwilton On Mon, 9 Jun 2003, Goulet, Dick wrote: > Exp/imp of a 200GB database is possible, but I'd think the time required would be > the long pole in the tent. I'd say your looking at at least a 4 day weekend at best > and only if you used direct mode. Someone has hinted that you can simply move the > datafiles from one box to the other. Well I'd not loose the original system before > you prove that. My experience with database file from Solaris to HP-UX has been a > 100% loss of data. Granted that was on a much earlier version of Oracle (6.0.x). > > Dick Goulet > Senior Oracle DBA > Oracle Certified 8i DBA > > -Original Message- > Sent: Saturday, June 07, 2003 7:29 AM > To: Multiple recipients of list ORACLE-L > .. > > > Hi all: > > We are considering migration of an Oracle eBusiness Suite 11.5.8 from > HP-UX 11.0 to Solaris9. > > I'd like to know if anyone has done this and how daunting the task is. > > Are there any 3rd Party tools which can help out? > > Coming to the conventional approaches: > > 1. What do you think of Export/Import of a 200 GB database? > 1a. How much time will it take? > 1b. Any strategies for cutting that down? > > 2. How does CTAS over dblink compare to Export/Import? > > 3. Is there any tool that converts Oracle datafiles on HP-UX 11.0 to > Oracle datafiles on Solaris 9. If so we would just need to recreate the > control files on the target database and we are done. > > Any suggestions, pointers, words of wisdom are greatly appreciated... > > Thanks & Regards, > Sashi > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Sashidhar Kondareddy > 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.net > -- > Author: Goulet, Dick > 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.net -- Author: Jeremiah Wilton 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).
RE: HP-Sun Cross Platform Migration - Exp/Imp, CTAS over dblink or ..
Wondering out aloud here. Could you export/imp using pipes. I remember doing this on a 200gb database going from 7.3 to 8 on Solaris, granted on the same server. Took about 4-6 hours if I remember correctly. Anyway to create a remote pipe on another server to listen for inputs from another server so that the above can be accomplisher or am I Way off the mark here. mohammed --- "Goulet, Dick" <[EMAIL PROTECTED]> wrote: > Exp/imp of a 200GB database is possible, but I'd > think the time required would be the long pole in > the tent. I'd say your looking at at least a 4 day > weekend at best and only if you used direct mode. > Someone has hinted that you can simply move the > datafiles from one box to the other. Well I'd not > loose the original system before you prove that. My > experience with database file from Solaris to HP-UX > has been a 100% loss of data. Granted that was on a > much earlier version of Oracle (6.0.x). > > Dick Goulet > Senior Oracle DBA > Oracle Certified 8i DBA > > -Original Message- > Sent: Saturday, June 07, 2003 7:29 AM > To: Multiple recipients of list ORACLE-L > .. > > > Hi all: > > We are considering migration of an Oracle eBusiness > Suite 11.5.8 from > HP-UX 11.0 to Solaris9. > > I'd like to know if anyone has done this and how > daunting the task is. > > Are there any 3rd Party tools which can help out? > > Coming to the conventional approaches: > > 1. What do you think of Export/Import of a 200 GB > database? > 1a. How much time will it take? > 1b. Any strategies for cutting that down? > > 2. How does CTAS over dblink compare to > Export/Import? > > 3. Is there any tool that converts Oracle datafiles > on HP-UX 11.0 to > Oracle datafiles on Solaris 9. If so we would just > need to recreate the > control files on the target database and we are > done. > > Any suggestions, pointers, words of wisdom are > greatly appreciated... > > Thanks & Regards, > Sashi > -- > Please see the official ORACLE-L FAQ: > http://www.orafaq.net > -- > Author: Sashidhar Kondareddy > 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.net > -- > Author: Goulet, Dick > 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). __ Do you Yahoo!? Yahoo! Calendar - Free online calendar with sync to Outlook(TM). http://calendar.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: mkb 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).
RE: HP-Sun Cross Platform Migration - Exp/Imp, CTAS over dblink or ..
This is *exactly* what I would like to do on our SAP systems when we upgrade, since this is the best way to move to LMT's. Unfortunately for me and a lot of other folks, Windoze don't do that. :( You can't imagine just how much I wish we were on Solaris. Jared Kirtikumar Deshpande <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 06/09/2003 07:59 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: Subject: RE: HP-Sun Cross Platform Migration - Exp/Imp, CTAS over dblink or .. You may want to review an article, "Cross Platform Migration of a Large Production Database", in the latest issue(2nd Qtr 2003) of SELECT journal (by IOUG). The author details the procedure he followed to migrtate a 300GB production database from HP-UX to IBM AIX. - Kirti --- "Goulet, Dick" <[EMAIL PROTECTED]> wrote: > Exp/imp of a 200GB database is possible, but I'd think the time required would be the long pole > in the tent. I'd say your looking at at least a 4 day weekend at best and only if you used > direct mode. Someone has hinted that you can simply move the datafiles from one box to the > other. Well I'd not loose the original system before you prove that. My experience with > database file from Solaris to HP-UX has been a 100% loss of data. Granted that was on a much > earlier version of Oracle (6.0.x). > > Dick Goulet > Senior Oracle DBA > Oracle Certified 8i DBA > > -Original Message- > Sent: Saturday, June 07, 2003 7:29 AM > To: Multiple recipients of list ORACLE-L > .. > > > Hi all: > > We are considering migration of an Oracle eBusiness Suite 11.5.8 from > HP-UX 11.0 to Solaris9. > > I'd like to know if anyone has done this and how daunting the task is. > > Are there any 3rd Party tools which can help out? > > Coming to the conventional approaches: > > 1. What do you think of Export/Import of a 200 GB database? > 1a. How much time will it take? > 1b. Any strategies for cutting that down? > > 2. How does CTAS over dblink compare to Export/Import? > > 3. Is there any tool that converts Oracle datafiles on HP-UX 11.0 to > Oracle datafiles on Solaris 9. If so we would just need to recreate the > control files on the target database and we are done. > > Any suggestions, pointers, words of wisdom are greatly appreciated... > > Thanks & Regards, > Sashi > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Sashidhar Kondareddy > INET: [EMAIL PROTECTED] > __ Do you Yahoo!? Yahoo! Calendar - Free online calendar with sync to Outlook(TM). http://calendar.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Kirtikumar Deshpande 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.net -- Author: 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).
Re: HP-Sun Cross Platform Migration - Exp/Imp, CTAS over dblink or ..
Hi: Thanks to everyone who responded to my message on Cross Platform Migration... I will update the list if we come to any conclusions not consilient with the findings given on the list.. Thanks & Regards, Sashi Sashidhar Kondareddy Project Manager IT Solutions Inc, a SEI CMM Level 5 Company Chennai 66, India efax : +1 (360) 242-8334 -- The nice thing about standards is that you have so many to choose from. Furthermore, if you do not like any of them, you can just wait for next year's model. -- Andrew S. Tanenbaum in Computer Networks, 2nd Edition --- Original Message --- We are considering migration of an Oracle eBusiness Suite 11.5.8 from HP-UX 11.0 to Solaris9. I'd like to know if anyone has done this and how daunting the task is. Are there any 3rd Party tools which can help out? Coming to the conventional approaches: 1. What do you think of Export/Import of a 200 GB database? 1a. How much time will it take? 1b. Any strategies for cutting that down? 2. How does CTAS over dblink compare to Export/Import? 3. Is there any tool that converts Oracle datafiles on HP-UX 11.0 to Oracle datafiles on Solaris 9. If so we would just need to recreate the control files on the target database and we are done. Any suggestions, pointers, words of wisdom are greatly appreciated... Thanks & Regards, Sashi -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Sashidhar Kondareddy 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).