This discussion is archived
12 Replies Latest reply: Dec 12, 2012 7:33 AM by Rob_J RSS

Oracle Upgrade From 11.2.0.1 to 11.2.0.3

940673 Newbie
Currently Being Moderated
Hi All,

I am perfoming a upgradation from 11.2.0.1 to 11.2.0.3. This is the first time I am performing this task, so I need help you to assist me in this.

Should I have to download latest software from Oracle Support i.e 11.2..0.3 for this as a initial task???

Any important links for this will be helpful for me. I tried searching this in google but those are helpful or may I am not able to understand. :(

Please help me in this..

Regards,
Arijit
  • 1. Re: Oracle Upgrade From 11.2.0.1 to 11.2.0.3
    Fran Guru
    Currently Being Moderated
    check:
    http://docs.oracle.com/cd/E11882_01/server.112/e23633/upgrade.htm#UPGRD52700
  • 2. Re: Oracle Upgrade From 11.2.0.1 to 11.2.0.3
    940673 Newbie
    Currently Being Moderated
    Hi Fran,

    Can I download the software available in OTN. I mean is the software version is 11.2.0.3, if it is so can I download it??

    Regards,
    Arijit
  • 3. Re: Oracle Upgrade From 11.2.0.1 to 11.2.0.3
    Fran Guru
    Currently Being Moderated
    yes.
    patch ID 10404530:
    https://updates.oracle.com/Orion/PatchDetails/process_form?patch_num=10404530

    Another interesting link:
    http://g-tech-blog.blogspot.com.es/2012/04/update-oracle-from-11201-to-11203.html
  • 4. Re: Oracle Upgrade From 11.2.0.1 to 11.2.0.3
    Rob_J Journeyer
    Currently Being Moderated
    Hello,

    I have written out my exact notes that I used when upgrading from 10g to 11g. Although there might be differences and you should most definitely check the documentation, there will be a lot of similarities and this guide will help you upgrade.

    [url http://www.ora00600.com/articles/10g-to-11g-database-upgrade.html] Oracle 10g to 11g upgrade

    Also, this might not be relevant to you because you are already on 11g but there was a new [url http://www.ora00600.com/scripts/11g/10g-to-11g-upgrade.html]Resource Manager Plan in 11g which was enabled by default and it caught me out after we had rolled the upgrade to PROD so check for that.

    Hope it helps,
    Rob
  • 5. Re: Oracle Upgrade From 11.2.0.1 to 11.2.0.3
    P.Forstmann Guru
    Currently Being Moderated
    You can only download 11.2.0.3 patchset from My Oracle Support site. You cannot download it from OTN.
    README with media gives high level upgrade instructions.

    You need also to use Upgrade Guide: http://docs.oracle.com/cd/E11882_01/server.112/e23633/toc.htm.
  • 6. Re: Oracle Upgrade From 11.2.0.1 to 11.2.0.3
    940673 Newbie
    Currently Being Moderated
    HI,

    As per your reply Oracle 11.2.0.3 software is not readily available in ORCALE Site. Only I can download the patch set of 11.2.0.3, which I wil be surely download for the site.

    My first task wil be of creating a new ORACLE_HOME for the latest version. How can I do it if I dont have the software??

    Please assist me as I am compeletly new to it..

    Regards,
    Arijit
  • 7. Re: Oracle Upgrade From 11.2.0.1 to 11.2.0.3
    Srini Chavali-Oracle Oracle ACE Director
    Currently Being Moderated
    Pl post your OS details. As noted above, 11.2.0.3 is only available from MOS for those customers who have a paid support contract with Oracle.

    The Install Guides for 11.2.0.3 are at http://www.oracle.com/pls/db112/portal.portal_db?selected=11&frame=

    Upgrade Guide is at http://docs.oracle.com/cd/E11882_01/server.112/e23633/toc.htm

    HTH
    Srini
  • 8. Re: Oracle Upgrade From 11.2.0.1 to 11.2.0.3
    940673 Newbie
    Currently Being Moderated
    Hi,

    Thanks for all your reply. I am using teh below OS version:-

    Linux blrulvremoradb01 2.6.18-194.el5 #1 SMP Tue Mar 16 21:52:39 EDT 2010 x86_64 x86_64 x86_64 GNU/Linux

    I will download the mentioned patch sets as I have metalink support id with Oracle Support. I will let you know if I face any issues.

    Regards,
    Arijit
  • 9. Re: Oracle Upgrade From 11.2.0.1 to 11.2.0.3
    940673 Newbie
    Currently Being Moderated
    HI All,

    Steps I have done is given below till now:-

    Step 1:- I have created a new oracle home as "/u01/app_new/oracle/product/11.2.0.3/db_1" for the latest version.

    My existing oracle home is at "/u01/app/oracle/product/11.2.0/db_1".

    Step 2: Earlier I have downloaded 11.2.0.1 binaries and kept it in a location. I have start the runInstaller file and chosen the upgrade existing database.

    Am I in a right track??

    Regards,
    Arijit
  • 10. Re: Oracle Upgrade From 11.2.0.1 to 11.2.0.3
    Srini Chavali-Oracle Oracle ACE Director
    Currently Being Moderated
    You need to download 11.2.0.3 from MOS and install it in the new ORACLE_HOME "/u01/app_new/oracle/product/11.2.0.3/db_1" before you can start the upgrade.

    Pl follow the steps in the Upgrade Guide linked above.

    HTH
    Srini
  • 11. Re: Oracle Upgrade From 11.2.0.1 to 11.2.0.3
    Rob_J Journeyer
    Currently Being Moderated
    Read through all the guides and write down the parts which apply to your environment and do the necessary checks. Once complete, you should have a full list of what needs to be done and in what order. Then double check it. Only then should you start attempting to upgrade your DB, even if it's DEV. An Oracle upgrade is where the saying "If you fail to plan, you plan to fail" comes from...If you don't plan it out properly I can guarantee you that it will not work first time.
  • 12. Re: Oracle Upgrade From 11.2.0.1 to 11.2.0.3
    940673 Newbie
    Currently Being Moderated
    Thanks for your suggestions. I am downloading the patches from the link given. Post that I will go through the upgradation guide and do the needful.

    I'll let you know if I face any problems.

    Thanks again all for your help..

    Regards,
    Arijit

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points