4 Replies Latest reply on Apr 30, 2014 7:46 AM by tvCa-Oracle

    Upgrading: 11.2.0.3.0 or 11.2.0.4.0

    A_zaza

      Spec:

       

      Linux 5.10 & Windows 2003

      Oracle 10g

      Here is my concern or should I say problem?

      I have started my upgrade process. I have upgraded all my test and development environments to Oracle 11.2.0.3.0 from 10.2.0.5.0 and developers are currently carrying on testing for all of our application (most of them legacy).

      While doing some research and waiting for the test to complete, I realized that I could upgrade to 11.2.0.4.0 instead of 11.2.0.3.0.

       

      I know it will be in my interest to upgrade to 11.2.0.4.0, considering I don't have to upgrade in the next 2 years or more.

      My concern/question is can I directly upgrade my prooduction to 11.2.0.4.0 even though I did not test base on it?

      NOTE: Our production environment is very delicate, payroll and HRM information are includded and so I need to really take all the maximum precuation to cut down down time.

       

      Thanks for your input,

      Albert

        • 1. Re: Upgrading: 11.2.0.3.0 or 11.2.0.4.0
          Srini Chavali-Oracle

          If you have conducted all of your testing on 11.2.0.3, then that is the version you should target for production also. Performing a production upgrade that is different than all of your other upgrades is not recommended

          1 person found this helpful
          • 2. Re: Upgrading: 11.2.0.3.0 or 11.2.0.4.0
            Ashishk-Oracle

            For a production database, it is a must to first test any changes which will be applied on it, so it is not recommended to go directly to 11.2.0.4.

             

            For any technical query or upgrade path, you may refer to below article -

             

            837570.1 - Complete Checklist for Manual Upgrades to 11gR2

             

             

            Thanks,

            Ashish

            • 3. Re: Upgrading: 11.2.0.3.0 or 11.2.0.4.0
              Ratnesh Kumar Roy

              Hi,

               

              If you are going for upgrade, then first you have to choose how do u want to upgrade

              1. using dbua

              2. using catupgrd script

               

               

               

              But in both situations, i would recommend you to first run the preugrade tool to check the prerequisites

               

              Regards

              • 4. Re: Upgrading: 11.2.0.3.0 or 11.2.0.4.0
                tvCa-Oracle

                In my opinion, either:

                 

                - You have an upgrade to 11.2.0.3, which is tested (?) and working. On those test-environments, you can ADD an upgrade from 11.2.0.3 to 11.2.0.4.

                But, to know that this one works, you need to have enough time after doing this upgrade and before you start anything on production.

                And, the idea is to NOT mix both upgrades, since a combined upgrade is what you've never tested (see below)

                 

                - Don't change the 11.2.0.3 upgrade at all, and patch production to 11.2.0.3

                 

                - Clone all non-production environments (from production) back to 10g, and run an 11.2.0.4 upgrade on all and each, and allow AT LEAST the same time for testing and debugging on non-production, as you have let the 11.2.0.3 testing being done already.

                 

                Other options are dangerous (untested)