What version of 8 Oracle db you have? If you are on 8.1.7 it will be much simpler to install 9i on the same box and upgrade. Yechiel Adar Mehish ----- Original Message ----- From: "Seema Singh" <oracledbam@xxxxxxxxxxx> To: <oracle-l@xxxxxxxxxxxxx> Sent: Monday, August 16, 2004 7:00 PM Subject: (no subject) > Hi, > I want to move to new server on unix platform. > Current : 8 database ,Oracleapplication 9i > platform: UNIX > > purposed : 9i database,Oracleapplication 10g > Platform :UNIX > > Please suggest which approach would be good with minimum interruption to the > production enviornment. > Which option would be good Export/Import OR we need to install the same > version of oracle on new server and then upgrade by keeping the view with > minimum intrruption of production enviornment and less riskly? > > I'm thinking following plan ,please correct me if any. > 1)Install OS on new db and application boxes > 2)Set enviornment.change kernel parameters etc according to oracle database > and applciation server and rebuild the kernel. > 3)Install OS patches/packages if any. > 4)Install Oracle9i DATABASE and Oracleapplication 10g on 2 diffrent boxes. > 5)Create database and map tablespaces according with currect. > 6)take export on production and FTP to new box. > 7)Import the data in usermode. > 8)Configure the tns and listerner > 9)test the applications > 10)If all above 9 steps are successfully then plan for final migration. > 11)We need to do either stop the application ,export the data,ftp the data > to new mahcine and start import on new server OR PUT THE TABLESPACE INTO > READ ONLY MODE,LEAVE THE APPLICATION, TAKE EXPORT,FTP AND IMPORT. > > thx > -seema > > _________________________________________________________________ > Don’t just search. Find. Check out the new MSN Search! > http://search.msn.click-url.com/go/onm00200636ave/direct/01/ > > ---------------------------------------------------------------- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > ---------------------------------------------------------------- > To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx > put 'unsubscribe' in the subject line. > -- > Archives are at //www.freelists.org/archives/oracle-l/ > FAQ is at //www.freelists.org/help/fom-serve/cache/1.html > ----------------------------------------------------------------- ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------