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

Home -> Community -> Usenet -> c.d.o.server -> Oracle Database migration from 8i to 9i

Oracle Database migration from 8i to 9i

From: Wade Chy <wchy65_at_yahoo.com>
Date: 1 Oct 2003 13:18:22 -0700
Message-ID: <4fad73ef.0310011218.64c50c1c@posting.google.com>


Hi All,
I have been assigned to migrate a 8i database to a new 9i database. The current 8i server is on W2K with 1GB memory. The new 9i server is on a W2K3 with 6GB memory. There's about 20 GB data in 2 schemas. Here's my plan:

  1. Install the Oracle 9.0.2
  2. Create a new database instance in the 9i server using the DBCA.
  3. Export the 2 schemas from the 8i server and split the dmp file to 2GB files during off hours.
  4. Ftp the dump files over to the new server during off hours.
  5. Import the dmp files to the new 9i database.

This new 9i server will be running along the 8i server for some time while the applications are tested before promoted to production. So I will have some time to monitor and make changes as required in test env.

My question is what's the downside to this plan if any? What sort of problem I could face during the installation process? What sort of problem I could face with VLM(6GB Memory)? I am going through the installation guide now and found that 9i support VLM. Your feedback and installation / migration experience will be greatly appreciated. TIA Wade Chy Received on Wed Oct 01 2003 - 15:18:22 CDT

Original text of this message

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