Migration Plan from Oracle 8i to 11g
Dear all.
I've got some questions that are about migration. At the moment I have a customer which has a server as I describe below:
- HP PA Risc 9000/800 Dual Core 800Mhz RP3410, 1 processor, 4Gb RAM and 2 disks SCSI of 72Gb each
- ERP with internal development using Oracle Technology / Web (PL/SQL generating HTML) with packages stored in the same database.
- Oracle 8i Database (8.1.6)
- Database with 44Gb approx.
- OS = HP-UX B.11.11 64 bits
- Backup system = Archives and dump recorded in tapes daily
With those specifications I would like, if it's possible, some recommendations for a migration to 11g.
Questions:
1 - Is it possible to migrate from 8i straight to 11g? Will there be a lot of problems?
2 - What's the best plan to follow? For example: a) backup the entire db. b) create another specific directory for 11g instalation files. c) export and import full db.
Could anyone just reply a plan for a upgrade like that? The best methods and tips?
Thanks a lot