Home » RDBMS Server » Server Administration » Upgrading oracle
Upgrading oracle [message #278876] Tue, 06 November 2007 01:29 Go to next message
Messages: 96
Registered: October 2006
Hi ,

On our server, there are oracle databases ,some are having version & one database is having version 8.1.7.


We want to upgrade all databases to
We were thinking of creating different mount point, we will install there & upgrade it to Then upgrade other databases to
Is it right method to do??

To upgrade 8i to 9i database, are these steps are sufficient?
update environment variable

-> Run Upgrade script : cd $ORACLE_HOME/rdbms/admin
Sqlplus /as sysdba
startup restrict or startup migrate
@u0801070.sql or u0900010.sql
-> Run @utlrp
-> Shutdown immediate
-> Modify Listner.ora with new ORACLE_HOME

Re: Upgrading oracle [message #278879 is a reply to message #278876] Tue, 06 November 2007 01:46 Go to previous message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

for upgrade 9.2 version.
you have to apply latest patchset for version 9ir2. and latest patchset is "" patchset.
then after if you want to apply critical patch update "cpu" then check metalink for latest cpu patch for patchset.

How to apply patchset or cpu patch read README.txt file which comes with patchset.

for upgrade 8.1.7 version.
Direct upgrade is supported from 8.1.7 to 9ir2.

Yes you step is correct.but also go through below link

Mohammed Taj
Previous Topic: pfile or spfile
Next Topic: Database shutdown in the midnight
Goto Forum:

Current Time: Wed Aug 23 01:25:15 CDT 2017

Total time taken to generate the page: 0.04995 seconds