Re: Oracle Database migration from 8i to 9i

"Wade Chy" <wchy65_at_yahoo.com> wrote in message news:4fad73ef.0310011218.64c50c1c_at_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

Here's my two cents, I just went through 35 upgrades of SAP Oracle/Unix databases:

1. Install Oracle 9.2.0.3.0 on new server.
2. Shutdown current Oracle server.
3. Copy all it's data files to the new server.
4. Copy its dbs and network/admin files to the same dirs on the new server.
5. On the new server, set Oracle_Home to the 9.2 home dir, and with SQLPlus "startup migrate".
6. Run the Script "rdbms/admin/u0801070.sql" or whatever your 8i version was.
7. Shutdown immediate.
8. Startup.
9. Done.
10. Adjust the Listener.ora file for the new Oracle_Home

This is somewhat simplied, but you get the idea. don't waste time unloading and reloading the user database files when they aren't affected by the upgrade; why import and rebuild indices and stuff like that.

Research this a tad more; there's an oracle 9i Migration Guide for you to review, but it's rather easy to upgrade.

Charles Received on Wed Oct 01 2003 - 17:01:44 CDT