4 Replies Latest reply on Aug 6, 2014 3:37 PM by Shalle

    Upgrade oracle database from to on RHEL 6



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

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



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

          Pl see the Upgrade Doc - Contents


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



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

            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

            Target database is on RHEL6 and Oracle


            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.



            • 3. Re: Upgrade oracle database from to 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 to on RHEL 6

                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.