Před vlastním upgradem spusťte na původní databázi pre-upgrade scripty, které vám řeknou, co je potřeba udělat před vlastním upgradem.

Upozorní vás i na to, že přímý upgrade z vaši databáze není možný. viz přiložený log i s tabulkou z které verze to jde.

$ cp /u01/app/oracle/product/12.1.0.1/db_1/rdbms/admin/preupgrd.sql /tmp/upgrade
$ cp /u01/app/oracle/product/12.1.0.1/db_1/rdbms/admin/utluppkg.sql /tmp/upgrade

SQL> @preupgrd.sql
Loading Pre-Upgrade Package...
Executing Pre-Upgrade Checks...
Pre-Upgrade Checks Complete.
      ************************************************************

Results of the checks are located at:
 /opt/oracle/app/cfgtoollogs/ORCL/preupgrade/preupgrade.log

Pre-Upgrade Fixup Script (run in source database environment):
 /opt/oracle/app/cfgtoollogs/ORCL/preupgrade/preupgrade_fixups.sql

Post-Upgrade Fixup Script (run shortly after upgrade):
 /opt/oracle/app/cfgtoollogs/ORCL/preupgrade/postupgrade_fixups.sql

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

         Fixup scripts must be reviewed prior to being executed.

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

      ************************************************************
                   ====>> USER ACTION REQUIRED  <<====
      ************************************************************

 The following are *** ERROR LEVEL CONDITIONS *** that must be addressed
                    prior to attempting your upgrade.
            Failure to do so will result in a failed upgrade.


 1) Check Tag:    UNSUPPORTED_VERSION
    Check Summary: Make sure we support a direct upgrade from this version
    Fixup Summary:
     "Database must be first upgraded to a supported release prior to upgrading to this release."
    +++ Source Database Manual Action Required +++


 2) Check Tag:    PURGE_RECYCLEBIN
    Check Summary: Check that recycle bin is empty prior to upgrade
    Fixup Summary:
     "The recycle bin will be purged."

           You MUST resolve the above errors prior to upgrade

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

db_upg

DOC nebo PDF



Komentáře