(no subject)

From: Seema Singh <oracledbam_at_hotmail.com>
Date: Mon, 16 Aug 2004 13:00:13 -0400
Message-ID: <BAY19-F40msSCGPhFYp000438eb@hotmail.com>

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_at_freelists.org put 'unsubscribe' in the subject line.
--

Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html

Received on Mon Aug 16 2004 - 11:56:06 CDT