7 Replies Latest reply: Feb 22, 2013 12:28 PM by EdStevens RSS

    Upgrade GI from 11.2.0.1 to 11.2.0.3 on Stand alone DB

    John-MK
      Hello,

      I want to upgrade GI/ASM from 11.2.0.1 to 11.2.0.3 (out of place). RHL5

      I did not find any link regarding the exact upgrade. I will be highly thankful, if you could answer my simple questions.

      - Pre-requisite patch to install to 11.2.0.1 GI_HOME on Standalone before upgrading?
      - from the 11.2.0.3 NEW_GI_HOME, I will invoke ./runInstaller and choose upgrade GI/ASM for Standalone, and following the steps, thats it right, no second time GUI for example ASMCA or ASMUA

      - I am confused here that will ASM instance be upgraded also within the same GI upgrade GUI steps or do I need to start again GUI from new GI home with ASMUA option or so?

      Thanks a lot for your inputs in advance.

      Best Regards,

      Edited by: John-MK on Feb 19, 2013 12:27 PM

      Edited by: John-MK on Feb 19, 2013 3:07 PM
        • 1. Re: Upgrade GI from 11.2.0.1 to 11.2.0.3 on Stand alone DB
          asahide
          Hi,
          11gR2 an upgrade of GI can only be executed as an out-of-place upgrade.
          <<http://camoraict.files.wordpress.com/2012/08/upgrade-grid-infrastructure-from-11-2-0-2-to-11-2-0-3-on-linux.pdf>>

          Regards,
          • 2. Re: Upgrade GI from 11.2.0.1 to 11.2.0.3 on Stand alone DB
            John-MK
            Hi,

            Thank you very much for the effort. But the link you gave me explains upgrade from 11.2.0.2 to 11.2.0.3 and I need upgrade guide/reference from 11.2.0.1 to 11.2.0.3

            Best Regards,

            Edited by: John-MK on Feb 20, 2013 12:39 PM
            • 3. Re: Upgrade GI from 11.2.0.1 to 11.2.0.3 on Stand alone DB
              EdStevens
              John-MK wrote:
              Hello,

              I want to upgrade GI/ASM from 11.2.0.1 to 11.2.0.3 (out of place). RHL5

              I did not find any link regarding the exact upgrade. I will be highly thankful, if you could answer my simple questions.

              - Pre-requisite patch to install to 11.2.0.1 GI_HOME on Standalone before upgrading?
              - from the 11.2.0.3 NEW_GI_HOME, I will invoke ./runInstaller and choose upgrade GI/ASM for Standalone, and following the steps, thats it right, no second time GUI for example ASMCA or ASMUA

              - I am confused here that will ASM instance be upgraded also within the same GI upgrade GUI steps or do I need to start again GUI from new GI home with ASMUA option or so?

              Thanks a lot for your inputs in advance.

              Best Regards,

              Edited by: John-MK on Feb 19, 2013 12:27 PM

              Edited by: John-MK on Feb 19, 2013 3:07 PM
              I feel your pain. I just went through upgrading a standalone ASM from 11.2.0.1 to 11.2.0.2. I felt that some of the references tended to be circular, and figuring out what I could ignore because I was NOT clustered was very challenging. However, I'd say you must start with the readme and release notes and whatever other docs are included in the actual 11.2.0.3 distribution.
              • 4. Re: Upgrade GI from 11.2.0.1 to 11.2.0.3 on Stand alone DB
                Victor Armbrust
                Even if you are using a Standalone configuration you can upgrade from 11.2.0.1/11.2.0.2 to 11.2.0.3 with the same procedure. I`ve done that way.

                Look at this tutorial: (I used the similar steps to upgrade a Standalone 11.2.0.1 to 11.2.0.3)

                http://www.gokhanatil.com/2011/09/upgrading-oracle-rac-database-11202-to.html


                Victor
                • 5. Re: Upgrade GI from 11.2.0.1 to 11.2.0.3 on Stand alone DB
                  Victor Armbrust
                  Even if you are using a Standalone configuration you can upgrade from 11.2.0.1/11.2.0.2 to 11.2.0.3 with the same procedure. I`ve done that way.

                  Look at this tutorial: (I used the similar steps to upgrade a Standalone 11.2.0.1 to 11.2.0.3)

                  http://www.gokhanatil.com/2011/09/upgrading-oracle-rac-database-11202-to.html


                  Victor
                  • 6. Re: Upgrade GI from 11.2.0.1 to 11.2.0.3 on Stand alone DB
                    AminChavarria
                    Hi John-MK,


                    1. Install Oracle GI software only.
                    2. To configure Grid Infrastructure for a Stand-Alone Server run the following command as the root user:
                    /u02/app/11.2.0/grid/perl/bin/perl -I/u02/app/11.2.0/grid/perl/lib -I/u02/app/11.2.0/grid/crs/install /u02/app/11.2.0/grid/crs/install/roothas.pl

                    [root@server> / ]#/u02/app/11.2.0/grid/perl/bin/perl -I/u02/app/11.2.0/grid/perl/lib -I/u02/app/11.2.0/grid/crs/install /u02/app/11.2.0/grid/crs/install/roothas.pl
                    Using configuration parameter file: /u02/app/11.2.0/grid/crs/install/crsconfig_params
                    Creating trace directory
                    LOCAL ADD MODE
                    Creating OCR keys for user 'grid', privgrp 'oinstall'..
                    Operation successful.
                    CSS appears healthy
                    Stopping CSSD.
                    Shutting down CSS daemon. ===> delete old CSS daemon (11.2.0.1)
                    Shutdown request successfully issued.
                    Shutdown has begun. The daemons should exit soon.
                    CRS-4664: Node dwmdm successfully pinned.
                    Adding Clusterware entries to inittab

                    dwmdm 2012/07/26 16:18:48 /u02/app/11.2.0/grid/cdata/dwmdm/backup_20120726_161848.olr
                    Successfully configured Oracle Grid Infrastructure for a Standalone Server

                    3.$ps -fea | grep d.bin
                    4. crsctl check has
                    5. crsctl stat resource

                    6. Delete LISTENER (11.2.0.1) - NETCA
                    7. Create LISTENER (11.2.0.3) - NETCA
                    8. Run ASMCA to upgrade 11.2.01 to 11.2.0.3. (ASMCA will detect a 11.2.0.1 ASM instance and set the new GRID_HOME for new ASM instance 11.2.0.3).
                    9. Click UPGRADE ASM.

                    Is best practice upgrade ASM with ASMCA, not with OUI-Oracle GI


                    regards
                    Amin

                    blog: http://www.amin.ol-e.com.mx
                    • 7. Re: Upgrade GI from 11.2.0.1 to 11.2.0.3 on Stand alone DB
                      EdStevens
                      >
                      <snip>
                      Is best practice upgrade ASM with ASMCA, not with OUI-Oracle GI
                      Quoting "Oracle Automatic Storage Mangement Administrator's Guide 11.2 (E16102-05)", section "Upgrading an Oracle ASM Instance with Oracle Universal Insaller", pg 3-17:

                      The recommended practice is to upgrade an Oracle ASM instance with Oracle Universal Installer (OUI).  OUI automatically defaults ot upgrade mode when it detects an Oracle ASM instance at a previous release level.
                      >
                      regards
                      Amin

                      blog: http://www.amin.ol-e.com.mx