Blog dedicated to Oracle Applications (E-Business Suite) Technology; covers Apps Architecture, Administration and third party bolt-ons to Apps

Friday, August 8, 2008

Upgrade 11i/9i vision to 11i/11g

I am currently doing a test upgrade of a freshly installed 11i vision instance with database 9.2.0.6 to database version 11.1.0.6. Till now I have achieved the following:

Install Oracle Enterprise Linux 5
Install pre-requisite patches for 11.5.10.2 on OEL5
Install E-Business Suite 11.5.10.2 Vision instance
Apply pre-requisite patch ATG_PF.H RUP6
Install 11g software
Executed catupgrd.sql successfully

Recompilation of invalids is in progress now.

I'll update this post with more details about this activity.

3 comments:

Anonymous said...

Hi

Are you done with the upgrade sucessfully. Please update the steps.

Thanks
NG

Anonymous said...

Are there any preferences with using import/export or DBUA or manual upgrade frpm 9.2.0.x or issues with any of the method.

Vikram Das said...

Hi Anonymous,

Please refer to metalink note 230627.1, which is a white paper on Export/Import Process for Oracle Applications Release 11i Database Instances Using Oracle9i Enterprise Edition. A similar white paper for 10gR2 is available in metalink note 362205.1. If you are on 10gR1 then the note is 331221.1.

- Vikram