Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: (no subject)

Re: (no subject)

From: Yechiel Adar <adar76_at_inter.net.il>
Date: Tue, 17 Aug 2004 13:21:07 +0200
Message-ID: <02d101c4844c$4b9bd020$c701a8c0@sys3>


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_at_hotmail.com> To: <oracle-l_at_freelists.org>
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_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
> -----------------------------------------------------------------



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 Tue Aug 17 2004 - 05:25:50 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US