take a look at this metalink doc...very helpfull
Subject: Complete checklist for manual upgrades of Oracle databases from anyversion to any version on any platform (documents only from 7.3.x>>8.0.x>>8.1.x>>9.0.x>>9.2.x>>10.1.x>>10.2.x>>11.1.x)
Doc ID: 421191.1
? Is it possible to migrate from 8i straight to 11g? Will there be a lot of problems?
it depends upon the version release you're in.
if you're in 126.96.36.199, then
its a two step process to 11g.
Check this one:
Complete Checklist for Manual Upgrades to 11gR1 - 429825.1
Oracle 11g Upgrade Companion - 601807.1
exp/imp would be your best pet....as original exp/imp is still supported by 11g....so create a new DB for 11g...
then create the same user/roles/profiles on 11g from 8i .... create all the tablespace/datafiles...and export from 8i ...move the .dmp to 11g server and imported it....
dont forget to gather stats after moving to 11g...
So, thanks for helping me. I've just read at metalink and I got some informations I needed. And it's recommended some upgrades from 8i to 11g following the matrix below:
Minimum Version of the database that can be directly upgraded to Oracle 11g Release 1
Source Database -->Target Database
188.8.131.52.0 (or higher) --> 11.1.x
10.1.0.2.0 (or higher) --> 11.1.x
10.2.0.1.0 (or higher) --> 11.1.x
The following database version will require an indirect upgrade path.
Source Database --> Upgrade Path for Target Database --> Target Database
184.108.40.206.0 (or lower) --> 7.3.4.x --> 220.127.116.11 --> 11.1.x
18.104.22.168.0 (or lower) --> 8.0.6.x --> 22.214.171.124 --> 11.1.x
126.96.36.199.0 (or lower) --> 188.8.131.52 --> 184.108.40.206 --> 11.1.x
220.127.116.11.0 (or lower) --> 18.104.22.168 --> 22.214.171.124 --> 11.1.x
If source database is 126.96.36.199.0, the upgrade path to be followed is as below:
188.8.131.52.0 --> 184.108.40.206 --> 220.127.116.11 --> 11.1.x.
Does that mean if I want to upgrade from 8i to 11g that I must install the 9i in a new ORACLE_HOME and to upgrade for 11g I must install in another new ORACLE_HOME?
Thanks a lot
Edited by: Bruno Palma on Apr 1, 2009 4:47 PM
1 person found this helpful
Does that mean if I want to upgrade from 8i to 11g that I must install the 9i in a new ORACLE_HOME and to upgrade for 11g I must install in another new >ORACLE_HOME?Yes.
Take a full cold-backup of the database and pfile at every level.
Hey Anhanta, thank you very much.
Just some doubts I still have.
OK, I understand I must upgrade from 8i (8.1.6) to 9i (last release) "Reading that document in Metalink I could see that", creating a new ORACLE_HOME for the installation. And then upgrade from 9i to 11g (11.1.x) installing another new ORACLE_HOME. It means I'll have 3 ORACLE_HOMES .. right?
Basicly, what are the steps after the version updates?
- Let's think I updated from 8i to 9i and everything was fine. I created a database to receive the data from my old database. How should I do this process? Exporting the entire database from 8i and importing on 9i? Test the conection? After that, if all are OK, backup the entire database again, right?
And do the same things at the 11g update progress?
Thanks a lot for the informations.
I know this question posted on Apr 1, 2009 8:56 PM and ended up with wrong direction so I want reiterate with right directions.
Since this is 8i DB and exp/imp approach we can directly upgrade the DB to 11g instead of (staging ) going to 9i.
1.create the db at 11g.
2.export (exp) from 8i db
3.move the dump file to 11g db server.
4.import(imp) using the 11g binary.