Databases
cancel
Showing results for 
Search instead for 
Did you mean: 

Oracle Upgrade from7.3.4 to 8i

Ashish Anand
Occasional Contributor

Oracle Upgrade from7.3.4 to 8i

Hello everybody,

We are currently using HP-UX 10.20 with Oracle 7.3.4. We are planning to upgrade oracle as this version will not be supported soon. At the same time we are also planning to upgrade HP-UX to 11.00.
What should be the best approach to these upgrades??
What if we do the oracle upgrade first and keep HP-UX 10.20?

Thanks,

Ashish
4 REPLIES
A. Clay Stephenson
Acclaimed Contributor

Re: Oracle Upgrade from7.3.4 to 8i

This appears to be a continuation of your earlier question. I think your best and safest approach to this is to do a new install of Oracle 8i on your new OS coupled with a full export / import. Go ahead and create the the database and tablespaces before the import so that you can optimize the layout for your new environment. You also need to decide in your new package if your want the Oracle executables themselves to switch along with the data.


If it ain't broke, I can fix that.
Tom Geudens
Honored Contributor

Re: Oracle Upgrade from7.3.4 to 8i

Hi,
1. Take backups (of database AND system) !!!
2. Take full export from database
3. Remove database
4. Upgrade server
5. Recreate database as 8i
Compatible parameter might be important, check this with oracle !!!
6. Import exportfile

To make sure you should check with oracle whether or not a 7.3.4 export can be imported in a 8i database ... but I believe it can be done (one of our dba's did this).

Hope this helps,
Tom Geudens
A life ? Cool ! Where can I download one of those from ?
Ryan Kogelheide
Frequent Advisor

Re: Oracle Upgrade from7.3.4 to 8i

If you have the space, I'd suggest you first do a test of the 8i import.

1) Install 8i on 10.20 first if possible (?).
2) Use dbassist to create the new db
3) Create your tablespaces, roles, and users
4) Export using the 7.3.4 export
5) Import using the 8i import
6) Connect test applications to the 8i and bang away at it a bit.

If all goes well in 1 to 6, then
8) Uninstall 8i
9) Upgrade to 11 and apply the patches
10) Reinstall 8i and apply the patches
11) repeat 2-5

Be picky about your testing, it pays.

Ryan
Virgil Chereches_2
Frequent Advisor

Re: Oracle Upgrade from7.3.4 to 8i

First of all, there is no Oracle 8.1.X on 10.20. You will need to use 11.00 - 32 or 64 (this depend on your hardware configuration).
Second, there exists a document on Oracle Metalink which describes migration from 7.3.x to 8.1.x - note 99206.1 and other with checklist for migration -note 47290.1.
It's better to read its first.
Obvious, you will need a full backup of database or if you have a test machine it's better to try with a copy of database first. Also, make sure that any possible dependencies with other databases aren't broken after upgrade (views on other databases or anything like this). That's why I recommend to try on a test machine first.
Remember that is a no-return point and if you miss something you'll have to recover from backup.