(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 http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Other related posts: