1 2 Previous Next 17 Replies Latest reply on Jun 14, 2018 11:28 AM by Beauty_and_dBest

    EBS database preupgrade_fixups.sql

    Beauty_and_dBest

      EBS 12.0.6

      OL6

      Upgrading 10.2.0.5 to 12.1.0.2

       

       

       

      Hi ALL,

       

      As part of the upgrade process, I am now on steps to run >> preupgrade_fixups.sql

       

      $ sqlplus / as sysdba

       

      SQL> @/mnt/data/d01/oracle/PPAPROD/cfgtoollogs/ORADBNEW/preupgrade/preupgrade_fixups.sql

       

      Pre-Upgrade Fixup Script Generated on 2018-06-13 06:03:28  Version: 12.1.0.2 Build: 006

      Beginning Pre-Upgrade Fixups...

      Executing in container PPAPROD

       

      **********************************************************************

      Check Tag:     COMPATIBLE_PARAMETER

      Check Summary: Verify compatible parameter value is valid

      Fix Summary:   "compatible" parameter must be increased manually prior to upgrade.

      **********************************************************************

      Fixup Returned Information:

      ERROR: --> Compatible set too low

       

           "compatible" currently set at 10.2.0 and must

           be set to at least 11.0.0 prior to upgrading the database.

           Do not make this change until you are ready to upgrade

           because a downgrade back to 10.2 is not possible once compatible

           has been raised.

       

           Update your init.ora or spfile to make this change.

      **********************************************************************

       

       

       

      Where do I set the above parameter? Is it on source 10.2.0.5   or  on target  12.1.0.2   init.ora?

       

       

      Please help...

       

       

      Kind regards,

      jc

        1 2 Previous Next