Monday 24 January 2011

Step by step process 11i to R12.1.1


Hi everybody, recently I have made complete iteration from fresh PROD 11i instance to R12.1.1 with database 11.2.0.2

I have used VMware for this iteration, the following step involved to achieve this upgrade from 11i to R12.1.1

OS – OEL 4.6
Memory 3GB
Instance 11i CU2
Database 9.2.0.6

My VMware installation has been running on P5 processor with 4GB memory under Windows 7 (64 bits) machine.
Before starting this iteration, I have enabled multi-org. So please follow multi-org enabled procedure prior to this step. 

The following steps performed successfully to complete this hectic upgrade from 11i instance to R12.1.1

      Upgrade 9.2.0.6 to 10.2.0.4
     Patches applied before 10g upgrade are 5478710, 4676589, 4653225
     Changed some of the OS kernel parameters
     Created new oracle home directory
     Installed 10gR1 (software only)
     Installed 10gR1 companion CD
     Installed 10g patch set 3 (10.2.0.4)
      Configuration section for 10g
     Created nls/data/9idata
     Run the script cr9idata.pl
     Copied environment file from 9i home to 10g home and made changes to reflect the directory structure of 10g home
     Copied TNS_ADMIN directory from 9i to 10 home and made changes according to new home
     Copies admin directory from 9i to 10g home and make necessary changes
     Shutdown 9i database and listener
     Startup 10g listener
     Upgraded  9i to 10g using dbua from 10g home
      Shutdown database and listener
      Create temporary tablespace
      Apply RDBMS Patches
      Fix Korean Lexers
      Run Adgrants.sql
      Grant create procedure privilege on CTXSYS
      Implement and run Autoconfig
      Gather statistics for SYS schema
      Recreate grants and synonym for apps
      Restart application server process
      Preparing for the Upgrade R12.1.1
     Apply AD.I.6
     Apply TUMS utility
     Run AD preparation scripts
Backup database and applications
      Startup 11i Instance
      Check for Invalid Objects etc...
      Create R12 application user
      Create R12 Base folder
      OS  Kernel setting etc
      (Refer Metalink: 761564.1  - Oracle E-Business Suite Installation and Upgrade Notes R12.1.1 for Linux x86)
      Installation of R12.1.1 applications
      Enable maintenance mode in R12
      Apply AD 12.1.1 upgrade driver (7461070)
      Source the R12 Applications environment file
      Run the Patch Application Assistant
      Run the adgrants.sql
      Apply patch
      Re-Create grants and Synonyms
      Compile APPS schema
      Modify tablespace
      Run the American English upgrade patch driver 6678700
      Review patch history and timing
      Install R12.1.1 again for configuration purpose
       Startup / shutdown applications and database
       Try with autoconfig in both tiers
       Restart services
       Upgrade 10.2.0.4 to 11.2.0.2
      Patches applied before  11gR2 upgrade are 9062910, 8919489, 9868229, 10024524
      Autoconfig latest version with 9852070 and 9738085
      OS kernel parameters for 11gR2
      Created new oracle home directory
      Installed 11gR2 (software only)
      Installed 11g Examples CD
       Configuration section for 11gR2
      Created nls/data/9idata
      Run the script cr9idata.pl
      Copied environment file from 10g home to 11g home and made changes to reflect the directory structure of 11g home
      Copied TNS_ADMIN directory from 10g to 11g home and made changes according to new home
      Copies admin directory from 10g to 11g home and make necessary changes
      Apply 11.2.0.2 RDBMS Patches – 4247037 and 10149223
      Shutdown 10g database and listener
      Startup 11g listener
      Run  DBUA
      Perform post-install instructions
      Run adgrants.sql
      Grant create procedure privilege on CTXSYS
      Set CTXSYS parameter
      Validate Workflow ruleset
      Implement and run AutoConfig in the new Oracle home on the database server node.
      Gather statistics for SYS schema
      Re-create grants and synonyms
      Restart Applications server processes
      Synchronize Workflow views

Very detailed step-by-step notes with screen shot also prepared along with this iteration, if anybody looking for this iteration material or VMware copy don’t forget to drop me mail.


Cheers!!!
SocialTwist Tell-a-Friend

Related Posts by Categories



96 comments:

Anonymous said...

Hi,
Excellant articles,

Can you please send me the detailed step by step notes to my email address nassarsheik@yahoo.com

Thank in Advance.
Nassar

Unknown said...

Hi,

Very Good Article,

Can you please send me the Oracle Database 11gR2 Installation & Upgradation Notes from 9.2.0.6 to 11gR2 for Oracle Apps 11.5.10.2 to 12.1.3 - step by step screen shots document to my email ID appsdba2learn@gmail.com

Thank & Regards.
Vinod Kumar

Zerocool Blog said...

Hi,
I'm going to start explore how to upgrade 11i to 12.1 right now. This is very good article. Please send the complete step by step with screen shot..

Zerocool Blog said...

Hi,
I'm going to start explore how to upgrade 11i to 12.1 right now. This is very good article. Please send the screen shot at ibnisharhakim@gmail.com

stephen rengan said...

Excellent, can you please drop me a note of the doc.

Anonymous said...

Hi !
First of all, thanks for providing so kindly a step by step update guide, that helps me to become a better DBA.
Could you please send it to bitmakker@hotmail.com ; I'll be very grateful ...

Anonymous said...

Dear Aji,

Your blog is excellent for technical knowledge. Kindly share the step by step upgrade screenshots of 9i to 11g and 11i to R12. My email id is syedam143@gmail.com.

Regards,
Mehmood.

Anonymous said...

Hi,

I'm doing an upgrade from 11i to 12.1.3 right now.

This is very good article. Could you please send me the complete step by step document with screen shots ..

My address is :- fordr@waikato.ac.nz

Many thanks, Rob

Sonam Gupta said...

Dear Ajikumar,

Kindly share the upgradation document of 11i to R12 including database with screenshots. I would be grateful to you.

Regards,
Sonam Gupta
Apps DBA Consultant
sonam_gupta_oracle@yahoo.com

Anonymous said...

Hi,

I need your expertise advise. My client is having Dbtier and AppsTier on windows 2003(32 bit) server. Now we are planning to move to 12.1.3 on windows 2008R2(64 bit). DB from 10.2.0.3 to 11gR2. I am going through metlaink notes. What I uderstood is as RapidInstall 12.1.1 cannot be directly done on 64 bit. they are suggesting to upgrade teh windows 2003(32 bit) to 12.1.1 and then do rapid clone to 2008R2(64bit). My doubt here is...when to upgrade the DB. as 11gR2 installation available on 64bit.. which is the right step.
first upgrade it to 11gR2 at 32 bit and then migrate it to 64bit and apply OLAP sizing
or secondly..install 11gR2(64bit) installation on Windows2008R2(64 bit)..

Actually lots of doubts arising..Please mail me ur response at sailasudhaj@gmail.com..

Particularly those we are working on this kind of environment(windows).. please suggest me.

Unknown said...

Hi Ajikumar,

plz mail me upgradation doc of 11i to R12 including screen shots.

Regards,
Adinarayana
gvadinarayana@hotmail.com

Anonymous said...

I didnt understand this point, where instanlled 10gR1 software on that you applied 10gR2 patcheset 3(10.2.0.4) ?! :((

Unknown said...

Hi,
I'm going to start explore how to upgrade 11i to 12.1 right now. This is very good article. Please send the complete step by step with screen shot at s_skywalker@yahoo.com.

kind regards,
Shay

Unknown said...

Hello Ajikumar,

Kindly share the upgrade document of 11i to R12 including database with screenshots. I'd really appreciate it.

kind Regards,
Baljit Singh

bal_23@yahoo.co.uk

Anonymous said...

Hi,
Excellant document

Can you please send me the detailed step by step notes to my email address soumabha.lahiri@gmail.com

Thanks

Anonymous said...

Dear Aji,
I'm going to start explore how to upgrade 11i to 12.1 right now. Please send the upgrade document with screenshots at s_skywalker@yahoo.com.

thx in advance,
Shay

Anonymous said...

Hi ,
Great work sir , would like to share your screen short document at

Aamir.sky@gmail.com

Thanks in advance

Anonymous said...

Hi Kumar,
Excellent article,

Can you please send me the detailed step by step doc to my email address rana313@hotmail.com

Thank in Advance.
Sarwar

Anonymous said...

Hi Kumar,

Can you please send me the detailed step by step doc to my email address rana313@hotmail.com.

Thank.
Sarwar

Mohammad Al-Masri said...

Hi Ajikumar,

Could you please share me the upgrade doc of 11i to R12 including screen shots.

Appreciate this for you in advance

Regards,
Mohammad Al-Masri
mtalmasri@gmail.com

Anonymous said...

Hi Ajikumar,

Could you please share me the upgrade doc of 11i to R12 including screen shots.

Appreciate this for you in advance

Regards,
Hatkesh.samor@gmail.com

rahul said...

Hi Ajithkumar,

Can you please send me upgrade doc 11i to R12 with scrrenshots?

Thansk in advance.

It's bit urgent.

Regards
Rahul
rahul2888@gmail.com

praneeth said...

Hi Ajith,
You blog has helped me in solving my concurent managers problem after cloning.
Thank you very much for the valuable resource you are providing in your site.

Request you to send me the 11i to R12 Upgrade docs along with sceen shots to my mail id: reddy.praneeth27@gmail.com

please forward me other upgrade docs of R12 if possible.

Thank you,
Praneeth

sweetora said...

Hi,
Excellant articles,

Can you please send me the detailed step by step notes to my email address vsweetora@gmail.com

Thank in Advance.
vinoth

Unknown said...

Hi Ajikumar,

Your blog is excellent for technical knowledge. Kindly share the step by step upgrade .

ptsubhan@gmail.com

Regards,
Subhan

Madhu Somala said...

Hi Ajith,

Kindly share the step by step upgrade doc 11i to R12 with scrrenshots.

Email ID: sudhan.ma@gmail.com

Thanks in advance.

Regards,
Madhu Somala

Saurav Mishra said...

Hi Ajit
Kindly share the upgrade document ,from 11i to R12

Email ID:saurav.mishra3@gmail.com

Thanks a lot for your efforts

regards
Saurav Mishra

Kumar said...

Hi,
Excellant articles,

Can you please send me the detailed step by step notes to my email address vino5b@gmail.com

Waiting for you Valuable reply.

Thank in Advance.
Kumar

Ramu said...

Please send me step by step screenshots to my mail id.......
thanks in advance........

Ajitk said...

Hi AjiKumar,

Thanks for the nice post , please send the step by step screen shot document to ajitkerhalkar@gmail.com

Thanks and Regards,

Ajit Kerhalkar

Anonymous said...

Hi Ajikumar,

Thank you so much for your post. I am going to explore this task too. Could you please send me the step by step screen shot document to momoliu2011@yahoo.com.hk.

Thanks

Amy

Anonymous said...

Hi Ajitkumar,
Could you share the document.
Please email me at bhavani_neema@yahoo.com
Thanks

Anonymous said...

Hi,

Thank you for this, can you please share screen shot docment to my id:g.anilkumar99@gmail.com

shaik said...

Hi ,

Thanks for posting imp concept. can u pls send the step by step document to my mail id moulali123@gmail.com

Thanks
shaik

Anonymous said...

really nice steps in short. can you please provide me step be step doucment to manish.nashikkar@hotmail.com

It would be really appreciated.

Regards,
Manish

jelson said...

Hi Vinod
Excellent work and i am facing some issues with Upgradation and can u send the notes or Screenshots for upgradation

jels
Jakkara@gmail.com

jelson said...

HI ANil
Thnks for sharing info can u send the Metalink notes and Sschots to my email jakkara@gmail.com

Anonymous said...

Excellent article,

Can you please send me the detailed step by step doc to my email address hussain.javaid@gmail.com

Thanx in Adv

Unknown said...

Hi Kumar,

Very good document.Will you please send me the step by step document with screen shot.

My Mail Address is : jeyanandcse@gmail.com

Best Regards,
Anand.

myfriendchowdary said...

hi,
this is chowdary, i am very great for this blog.thankful if u send me a copy of step by step Document of upgradation of 11i to R12.1 to my mail id myfriendchowdari@gmail.com.

Anonymous said...

can u pls send me the step by step document to my mail id soumabha.lahiri@gmail.com

Mohammed Sajid Siddique said...

Hi Ajikumar,

Could you please share me the upgrade doc of 11i to R12 including screen shots.

Thank you and appreciate for your effort in advance.

Regards,
Sajid
sajid_siddiquee@yahoo.co.in

Unknown said...

The articles are great and very helpful for DBA's. Can u please send me a copy on hemalroha@gmail.com.

Anonymous said...

hi, nice guidance.
could you please send me a copy on
inijoey@gmx.com?
really apreciate it.

thanks
adi

Anonymous said...

Hi AjiKumar,

Thanks for the nice post , please send the step by step screen shot document to ' grsreddy.g@gmail.com '

Anonymous said...

Hi
I'm going to start explore how to upgrade 11i to 12.1 right now. This is very good article. Please send the screen shot at dbasam@hotmail.com
Thanks~

Anonymous said...

Hi,
I'm going to start explore how to upgrade 11i to 12.1 right now. This is very good article. Please send the complete step by step with screen shot at dbasam@hotmail.com

Thanks

venkat chinta said...

Hi,
I'm going to start explore how to upgrade 11i to 12.1 right now. This is very good article. Please send the complete step by step with screen shot.. my mail id is venki.likeme@gmail.com

Anonymous said...

Hi Ajikumar,

Could you please share me the upgrade doc of 11i to R12 including screen shots.

Thank you and appreciate for your effort in advance.

Regards,

Muhammad
mred82@gmail.com

Nemat said...

Hi,
could you please share the step by step upgrade screenshots document of 11i to r12.
my id is nemat.tamanne@gmail.com

thanks in advance,
regard,

Nemat

Nemat said...

Hi,
sir could you please share the oracle 11i to r12 upgrade screenshots document. my id is nemat.tamanne@gmail.com

thanks regard,
Nemat

Nemat said...

Hi,
sir could you plz share the upgrade 11i to r12 screen shots doc.
my id is nemat.tamanne@gmail.com

regards,
Nemat

Nemat said...

Hi,
sir could you plz share the 11i to r12 upgrade screen shots documents.
my email-id is nemat.tamanne@gmail.com.

regard,
Nemat

Anonymous said...

Hi,
sir could you plz share the 11i to r12 upgrade screen shots doc. my id is nemat.tamanne@gmail.com

Anonymous said...

Hi,
sir could you plz share the 11i to r12 upgrade screenshots doc. my email id is nemat.tamanne@gmail.com

thanks regards,
Nemat

Nemat said...

Hi,
sir could you plz send me the upgrade 11i to r12 screen shots doc. my email id is nemat.tamanne@gmail.com.

thanks regard,
Nemat

Anonymous said...

Hi Ajit,
Thanks for taking time to do this.
I truly appreciate your effort.
If you could, please email the step by step upgrade to 12.1.3 to sesivara@gmail.com
Thanks and Regards,
Selva

Anonymous said...

Great work!
Can you please share the upgrade doc with screen shot on vmware?

My email is adbavm@gmail.com

Thanks
Adb

Anonymous said...

Hi,

Please would you share this upgrade doc step by step on may mail id vishv_ims@hotmail.com.




Thanks,
Vishv

Unknown said...

Hi Ajith Please Forward me Screen shots of up-gradation from 11i to R12
This is my mail id dilipkmg@gmail.com

Thanks&Regards

Dileep Kumar

Anonymous said...

Hi Ajikumar,

plz mail me upgradation doc of 11i to R12 including screen shots on dimitrita@gmail.com.




Thanks & Regards,
Dimitrita Mohanty
dimitrita@gmail.com

Rajab said...

Hi Ajikumar,
Am in the final compilation steps of gathering all the required material for doing an upgrade from 11i (11.5.10.2) to R12 (12.1.3). Was kindly requesting if you could email me the upgradation doc including screenshots at rajabtambwe@gmail.com

Thanks in advance.

Unknown said...

Hi,
could you please share the step by step upgrade screenshots document of 11i to r12.
my id is sudhirreddy12@gmail.com

Thanks & Regards,
Sudheer

Unknown said...

Hello Ajikumar,

Ajikumar could you plz send me the upgrade 11i to r12 screen shots doc. my email id is sudhirreddy12@gmail.com

kind Regards,
Sudheer

Anonymous said...

Hi, I'm doing an upgrade from 11i to 12.1.3 right now. This is very good article. Could you please send me the complete step by step document with screen shots ..
My address is :- ksranji@gmail.com Many thanks, Anji

Anonymous said...

Hi Ajikumar..Kindly send me the upgrade document with screenshots. My email is rajabtambwe@gmail.com

Unknown said...

Hi Ajit,
Thanks for taking time to do this.
I truly appreciate your effort.
If you could, please email the step by step upgrade to 12.1.3 along with the screen shots to ksatyendra.4s@gmail.com

Thanks and Regards,
Satyendra

Unknown said...

Hi Ajit,
Thanks for taking time to do this.
I truly appreciate your effort.
If you could, please email the step by step upgrade to 12.1.3 with screen shots to ksatyendra.4s@gmail.com

Thanks and Regards,
Satyendra

Unknown said...

Hi Ajit,
Thanks for taking time to do this.
I truly appreciate your effort.
If you could, please email the step by step upgrade to 12.1.3 with screen shots to ksatyendra.4s@gmail.com
Thanks and Regards,

Anonymous said...

Hi Ajikumar,

Can you please send me the 11i to R12 document at rajabtambwe@gmail.com

Anonymous said...

Hi Ajikumar,

Please mail me upgradation doc of 11i to R12 including screen shots at rajabtambwe@gmail.com

cmschetan said...

Hi Ajit,

Excellent Work - Please send me step by step detailed doc of the upgrade at cmschetan@gmail.com

Nirmal Kumar said...

Please send me the R12 Upgrade from 11.5.10.2 documentation with screenshots to
cooolnirmal@gmail.com

Many Thanks,
Nirmal

Nirmal Kumar said...

Hi Ajikumar,

Please send me the R12.1 upgrade from
11.5.10.2 documentation with screenshots to cooolnirmal@gmail.com

Many Thanks,
Nirmal

Nilesh said...

Hi Ajikumar,

We are looking for feasible solution for upgrade from 11i to 12i with platform migration from HP-UX to Linux.

Current Versions :

DB : 9.2.0.3
Apps : 11.5.9.2

Kindly send me upgrade paths for the same on my email : nilesh.shilvant@gmail.com

Regards,

Unknown said...

Hi Ajit,

Your each post helped me lot in troubleshooting and gaining knowledge in oracle product.

currently we are planing to upgrade from 11i to r12(12.1.1) in out company(TCS).

I will be grateful if you are able to send me the DOC with screenshot to my mail id (saroj.dba@gmail.com)

Thnaks
Saroj

Anonymous said...

Hello,
Excellent Note!!,

Can you please send me the detailed step by step notes to my email address technology.system@gmail.com

Thanks a Lot!!

sumanth said...


Hi,

This is very good article. Could you please send me the complete step by step document with screen shots TO my mail :g.sumanthreddy03@gmail.com

Thanks
Sumanth

Anonymous said...

Hi do u have oracle virtual box image of 11.5.10.2

PS said...

Hi Ajitkumar, Could you please send me a copy of this document. Really appreciate it: saifparkar@gmail.com

Tronlegacy said...

Hi,
I'm going to start explore how to upgrade 11i to 12.1 right now. This is very good article. Please send the screen shot at appsdba.vikas@gmail.com

Regard
Vikas.

Unknown said...

Hi, I'm doing an upgrade from 11i to 12.1.3 right now. This is very good article. Could you please send me the complete step by step document with screen shots ..
My address is :- sandeep27.negi@gmail.com

Many thanks.

Anonymous said...

Dear

Kindly send me step by step Document for upgrade from 11i to R12 at amrsharhsera1@hotmail.com

Thanks in advance

Regards

Murthy said...

Hi Ajikumar,

Excellant document

Can you please send me the detailed upgrade document of 11i to R12.1.1 with step by step notes to my Email ID madhumurthy23@gmail.com

Thanks in advance

Anonymous said...

Hello Ajikumar,
Can you pls. send me the all step doc. at dcraig@rediffmail.com

Thanks & Regards!

Unknown said...

Dear AjilKuamr,
first of all let me say greets, hats -off and lot of Thanks for your kind of helping as a Mentor in online blog Management for us.

Sir i am very new to the Oracle AppsDBA so could you please help on this Upgradation from 11i to R12.1.3.
i am kindly requesting you please send me detailed Document as u said on Upgrade from 11i to R12 to my G-mail as soon as possible.


I am waiting for your reply on Gmail...once Again thanks A lot.

I never forget your Help on this.I get chance definitely i can do a re-help to you. I am waiting for this chance also.

Hope you understand my humble request.

My mailID: madhu.kondamoori@gmail.com


Thanking you sir

Anonymous said...

Hello Ajikumar,
Can you pls. send me the all step doc. at ashraf083@gmail.com

Thanks in Advance.

Regards,

Ashraf N

amaann said...

Hi Ajikumar,

Could you please share me the upgrade doc of 11i to R12 including screen shots.

Appreciate this for you in advance

Regards,
haleempasha@gmail.com

amaann said...

Hi Ajikumar,

Could you please share me the upgrade doc of 11i to R12 including screen shots.

Appreciate this for you in advance

Regards,
haleempasha@gmail.com

Anonymous said...

Hi AjithKumar,

Excellent article about upgrade.
Can you please send me the step by step upgrade document with screenshots to my email id: reachme.vivek@gmail.com

Thanks,
Vivek

Shiva said...

Dear AjilKuamr,

Please provide me your valuble documentation koti.1437@gmail.com

Thanks In advance.

Anonymous said...

Hi !
First of all, thanks for providing so kindly a step by step update guide, that helps me to become a better DBA.
Could you please send it to mukhdoomfawad@gmail.com ; I'll be very grateful

Unknown said...

Hello Ajikumar,
Can you pls. send me the all step doc. at 653asd@gmail.com
Thanks & Regards!

Unknown said...

Dear Ajith please send me the Oracle Database 11gR2 Installation & Upgradation Notes from 9.2.0.6 to 11gR2 for Oracle Apps 11.5.10.2 to 12.1.3 - step by step screen shots document to pvajairamchandra@gmail.com

Regards
P.V.Ajairamchandra

Unknown said...

Hi Ajith,

Good Article...can you please send the detailed version on this mail id...fakruddin.ebs@gmail.com...Thank you.

Sathiyaseelan said...

Hello Ajikumar,

Great work sir.
I am relatively new to oracle apps.
It will be very helpful if you share the detailed steps for upgrade from 11i to R12.

Mail ID: sathyaseelan29@gmail.com

Regards,
Sathiyaseelan M