4 Replies Latest reply: Aug 6, 2014 10:37 AM by Shalle RSS

    Upgrade oracle database from 11.2.0.3 to 11.2.0.4 on RHEL 6

    Shalle

      Hello,

      There was OS upgrade from RHEL5 to RHEL6 and Oracle 11gR2 ( 11.2.0.3) is running on rhel5, we need to upgrade to 11.2.0.4 on RHEL6.

      Do anyone know what are the exact steps to perform this task?

       

      Thanks

        • 1. Re: Upgrade oracle database from 11.2.0.3 to 11.2.0.4 on RHEL 6
          Srini Chavali-Oracle

          Pl see the Upgrade Doc - Contents

           

          You will need to install 11.2.0.4 into a new ORACLE_HOME and upgrade the database using DBUA

           

          HTH
          Srini

          • 2. Re: Upgrade oracle database from 11.2.0.3 to 11.2.0.4 on RHEL 6
            Shalle

            Hi Srini,

            Thanks for the reply. while i am performing RMAN duplicate target database using active database. I am getting the below errors.

            ==========================================================================================================

            RMAN-00571: ===========================================================

            RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============

            RMAN-00571: ===========================================================

            RMAN-00601: fatal error in recovery manager

            RMAN-03004: fatal error during execution of command

            RMAN-10041: Could not re-create polling channel context following failure.

            RMAN-10024: error setting up for rpc polling

            RMAN-10005: error opening cursor

            RMAN-10002: ORACLE error: ORA-03114: not connected to ORACLE

            RMAN-03002: failure of Duplicate Db command at 08/06/2014 11:48:22

            RMAN-05501: aborting duplication of target database

            RMAN-03015: error occurred in stored script Memory Script

            RMAN-06136: ORACLE error from auxiliary database: ORA-01092: ORACLE instance terminated. Disconnection forced

            ORA-00704: bootstrap process failure

            ORA-39700: database must be opened with UPGRADE option

            Process ID: 20877

            Session ID: 1 Serial number: 5

            ==============================================================================================================

            Source database is on RHEL5 and Oracle 11.2.0.3

            Target database is on RHEL6 and Oracle 11.2.0.4.

             

            I tried to start the startup the database with upgrade option but i am getting media recovery error.

            SQL> startup upgrade;

            ORACLE instance started.

             

            Total System Global Area 1603411968 bytes

            Fixed Size                  2253664 bytes

            Variable Size             603983008 bytes

            Database Buffers          989855744 bytes

            Redo Buffers                7319552 bytes

            Database mounted.

            ORA-01113: file 1 needs media recovery

            ORA-01110: data file 1: '/u02/oradata/NBFDEV1/system01.dbf'

             

            It would be great if you can help me to fix the issue.

             

            Thanks

            • 3. Re: Upgrade oracle database from 11.2.0.3 to 11.2.0.4 on RHEL 6
              Srini Chavali-Oracle

              Pl post RMAN related questions in the RMAN forum - https://community.oracle.com/community/database/high_availability/recovery_manager_%28rman%29_2

               

              Are you restoring a RMAN backup to a higher database version ? In that case, you will need to perform an upgrade before you can open the database. Pl see MOS Doc 790559.1

              • 4. Re: Upgrade oracle database from 11.2.0.3 to 11.2.0.4 on RHEL 6
                Shalle

                Thanks Srini, I was trying to use clone the database using active database feature. Let me try try other ways if this does not work.