Upgrade Oracle Apps 11i with Database to 10g R2
This is in continuation from my previous blog on 28th August about upgrading database for Oracle Apps 11i. If you have not seen previous update on overview of DB upgrade for Apps 11i you can Click Here
Upgrading a Oracle Apps 11i Database is Upgrading Usual 10g Database + some additional steps which are specific to Oracle Applications 11i. So if you have already done a database Upgrade you simply need to follow metalink note # 362203.1
Database upgrade is Two Step process: First Upgrade your software i.e. your files under Database $ORACLE_HOME to provide new executables .
How to upgrade software from 8i, 9i or 10.1 to 10.2 just go to directory where you have downloaded 10.1.2.0.2 database & go to Disk1 & execute ./runInstaller . This will start Universal Installer & then you have to choose different Oracle_Home to install 10.2 software . (Check oracle database upgrade guide at http://download-uk.oracle.com/docs/cd/B19306_01/server.102/b14238/preup.htm#i1007718 ) After software Installation you have to install software for companion CD in above ORACLE_HOME i.e. one for 10.2 only.
Why I need to Install companion CD separately, I never did it earlier ? Oracle recently started shipping Ultra Search as part of companion CD which earlier used to come with database software only Apply 10.2.0.2 patch 4547817 on top of 10.1.2.0.1 base release. For instructions on How to apply patcheset 10.2.0.2 check ReadMe of patch & you again have to apply it via OUI Upgrade database Metadata Once software is upgraded you have to upgrade Metadata and option you have is via executing sql’s mentioned in upgrade guide or dbua ( database upgarde assistance tool ). Oracle Universal Installer while upgrading software also prompt you to upgrade database while upgrade software. Depending on your comfort you can choose method to upgrade database. I prefer using manual method i.e. via upgrade sql files. Now apart from upgrading database there are some pre upgrade & post upgrade steps specific to oracle applications 11i & follow them as mentioned in metalink note # 362203.1 some are option & some are compulsory . I want to discuss Native Compilation in Oracle 10 g database but because of time constraints I will discuss it some other time.
From now onwards slowly I will move on Advanced Apps DBA tasks like
Adding extra Node in Applications 11i
Implementing SSL with Apps 11i webserver
Disaster Recovery Implementation
Configuring 10g Application Server with E-Business Suite 11i
Don’t forget to leave comments and if you have any doubts in Apps 11i mail me at atul_iiit@yahoo.com or post here as comment.
Atul Kumar
Oracle Apps DBA