preupgrade_fixups.sql

REM Pre-Upgrade Script Generated on: 2014-08-04 21:58:59
REM Generated by Version: 12.1.0.2 Build: 006
SET ECHO OFF SERVEROUTPUT ON FORMAT WRAPPED TAB OFF LINESIZE 750;

DECLARE
con_name varchar2(40);

BEGIN
execute immediate
  'select dbms_preup.get_con_name from sys.dual' into con_name;

IF con_name = 'CDB$ROOT' THEN

BEGIN
dbms_output.put_line ('Pre-Upgrade Fixup Script Generated on 2014-08-04 21:58:59  Version: 12.1.0.2 Build: 006');
dbms_output.put_line ('Beginning Pre-Upgrade Fixups...');
dbms_output.put_line ('Executing in container CDB$ROOT');
END;

BEGIN
dbms_preup.clear_run_flag(TRUE);
END;

BEGIN
-- *****************  Fixup Details ***********************************
-- Name:        APEX_UPGRADE_MSG
-- Description: Check that APEX will need to be upgraded.
-- Severity:    Informational
-- Action:      ^^^ MANUAL ACTION REQUIRED ^^^
-- Fix Summary:
--     Oracle Application Express can be manually upgraded prior to database upgrade.

dbms_preup.run_fixup_and_report('APEX_UPGRADE_MSG');
END;

BEGIN
dbms_output.put_line ('');
dbms_output.put_line ('**********************************************************************');
dbms_output.put_line ('                      [Pre-Upgrade Recommendations]');
dbms_output.put_line ('**********************************************************************');
dbms_output.put_line ('');
END;

BEGIN
dbms_output.put_line ('                        *****************************************');
dbms_output.put_line ('                        ********* Dictionary Statistics *********');
dbms_output.put_line ('                        *****************************************');
dbms_output.put_line ('');
dbms_output.put_line ('Please gather dictionary statistics 24 hours prior to');
dbms_output.put_line ('upgrading the database.');
dbms_output.put_line ('To gather dictionary statistics execute the following command');
dbms_output.put_line ('while connected as SYSDBA:');
dbms_output.put_line ('    EXECUTE dbms_stats.gather_dictionary_stats;');
dbms_output.put_line ('');
dbms_output.put_line ('^^^ MANUAL ACTION SUGGESTED ^^^');
dbms_output.put_line ('');
END;

BEGIN dbms_preup.fixup_summary(TRUE); END;

BEGIN
dbms_output.put_line ('**************** Pre-Upgrade Fixup Script Complete *********************');
END;

END IF;

END;
/
REM Pre-Upgrade Script Closed At: 2014-08-04 21:59:06
REM __________________________________________________________________________

REM Pre-Upgrade Script Generated on: 2014-08-04 21:59:22
REM Generated by Version: 12.1.0.2 Build: 006
SET ECHO OFF SERVEROUTPUT ON FORMAT WRAPPED TAB OFF LINESIZE 750;

DECLARE
con_name varchar2(40);

BEGIN
execute immediate
  'select dbms_preup.get_con_name from sys.dual' into con_name;

IF con_name = 'PDB$SEED' THEN

BEGIN
dbms_output.put_line ('Pre-Upgrade Fixup Script Generated on 2014-08-04 21:59:22  Version: 12.1.0.2 Build: 006');
dbms_output.put_line ('Beginning Pre-Upgrade Fixups...');
dbms_output.put_line ('Executing in container PDB$SEED');
END;

BEGIN
dbms_preup.clear_run_flag(TRUE);
END;

BEGIN
-- *****************  Fixup Details ***********************************
-- Name:        APEX_UPGRADE_MSG
-- Description: Check that APEX will need to be upgraded.
-- Severity:    Informational
-- Action:      ^^^ MANUAL ACTION REQUIRED ^^^
-- Fix Summary:
--     Oracle Application Express can be manually upgraded prior to database upgrade.

dbms_preup.run_fixup_and_report('APEX_UPGRADE_MSG');
END;

BEGIN
dbms_output.put_line ('');
dbms_output.put_line ('**********************************************************************');
dbms_output.put_line ('                      [Pre-Upgrade Recommendations]');
dbms_output.put_line ('**********************************************************************');
dbms_output.put_line ('');
END;

BEGIN
dbms_output.put_line ('                        *****************************************');
dbms_output.put_line ('                        ********* Dictionary Statistics *********');
dbms_output.put_line ('                        *****************************************');
dbms_output.put_line ('');
dbms_output.put_line ('Please gather dictionary statistics 24 hours prior to');
dbms_output.put_line ('upgrading the database.');
dbms_output.put_line ('To gather dictionary statistics execute the following command');
dbms_output.put_line ('while connected as SYSDBA:');
dbms_output.put_line ('    EXECUTE dbms_stats.gather_dictionary_stats;');
dbms_output.put_line ('');
dbms_output.put_line ('^^^ MANUAL ACTION SUGGESTED ^^^');
dbms_output.put_line ('');
END;

BEGIN dbms_preup.fixup_summary(TRUE); END;

BEGIN
dbms_output.put_line ('**************** Pre-Upgrade Fixup Script Complete *********************');
END;

END IF;

END;
/
REM Pre-Upgrade Script Closed At: 2014-08-04 21:59:27
REM __________________________________________________________________________

REM Pre-Upgrade Script Generated on: 2014-08-04 21:59:29
REM Generated by Version: 12.1.0.2 Build: 006
SET ECHO OFF SERVEROUTPUT ON FORMAT WRAPPED TAB OFF LINESIZE 750;

DECLARE
con_name varchar2(40);

BEGIN
execute immediate
  'select dbms_preup.get_con_name from sys.dual' into con_name;

IF con_name = 'PDB1' THEN

BEGIN
dbms_output.put_line ('Pre-Upgrade Fixup Script Generated on 2014-08-04 21:59:29  Version: 12.1.0.2 Build: 006');
dbms_output.put_line ('Beginning Pre-Upgrade Fixups...');
dbms_output.put_line ('Executing in container PDB1');
END;

BEGIN
dbms_preup.clear_run_flag(TRUE);
END;

BEGIN
-- *****************  Fixup Details ***********************************
-- Name:        APEX_UPGRADE_MSG
-- Description: Check that APEX will need to be upgraded.
-- Severity:    Informational
-- Action:      ^^^ MANUAL ACTION REQUIRED ^^^
-- Fix Summary:
--     Oracle Application Express can be manually upgraded prior to database upgrade.

dbms_preup.run_fixup_and_report('APEX_UPGRADE_MSG');
END;

BEGIN
dbms_output.put_line ('');
dbms_output.put_line ('**********************************************************************');
dbms_output.put_line ('                      [Pre-Upgrade Recommendations]');
dbms_output.put_line ('**********************************************************************');
dbms_output.put_line ('');
END;

BEGIN
dbms_output.put_line ('                        *****************************************');
dbms_output.put_line ('                        ********* Dictionary Statistics *********');
dbms_output.put_line ('                        *****************************************');
dbms_output.put_line ('');
dbms_output.put_line ('Please gather dictionary statistics 24 hours prior to');
dbms_output.put_line ('upgrading the database.');
dbms_output.put_line ('To gather dictionary statistics execute the following command');
dbms_output.put_line ('while connected as SYSDBA:');
dbms_output.put_line ('    EXECUTE dbms_stats.gather_dictionary_stats;');
dbms_output.put_line ('');
dbms_output.put_line ('^^^ MANUAL ACTION SUGGESTED ^^^');
dbms_output.put_line ('');
END;

BEGIN dbms_preup.fixup_summary(TRUE); END;

BEGIN
dbms_output.put_line ('**************** Pre-Upgrade Fixup Script Complete *********************');
END;

END IF;

END;
/
REM Pre-Upgrade Script Closed At: 2014-08-04 21:59:33
REM __________________________________________________________________________

REM Pre-Upgrade Script Generated on: 2014-08-04 21:59:35
REM Generated by Version: 12.1.0.2 Build: 006
SET ECHO OFF SERVEROUTPUT ON FORMAT WRAPPED TAB OFF LINESIZE 750;

DECLARE
con_name varchar2(40);

BEGIN
execute immediate
  'select dbms_preup.get_con_name from sys.dual' into con_name;

IF con_name = 'PDB2' THEN

BEGIN
dbms_output.put_line ('Pre-Upgrade Fixup Script Generated on 2014-08-04 21:59:35  Version: 12.1.0.2 Build: 006');
dbms_output.put_line ('Beginning Pre-Upgrade Fixups...');
dbms_output.put_line ('Executing in container PDB2');
END;

BEGIN
dbms_preup.clear_run_flag(TRUE);
END;

BEGIN
-- *****************  Fixup Details ***********************************
-- Name:        APEX_UPGRADE_MSG
-- Description: Check that APEX will need to be upgraded.
-- Severity:    Informational
-- Action:      ^^^ MANUAL ACTION REQUIRED ^^^
-- Fix Summary:
--     Oracle Application Express can be manually upgraded prior to database upgrade.

dbms_preup.run_fixup_and_report('APEX_UPGRADE_MSG');
END;

BEGIN
dbms_output.put_line ('');
dbms_output.put_line ('**********************************************************************');
dbms_output.put_line ('                      [Pre-Upgrade Recommendations]');
dbms_output.put_line ('**********************************************************************');
dbms_output.put_line ('');
END;

BEGIN
dbms_output.put_line ('                        *****************************************');
dbms_output.put_line ('                        ********* Dictionary Statistics *********');
dbms_output.put_line ('                        *****************************************');
dbms_output.put_line ('');
dbms_output.put_line ('Please gather dictionary statistics 24 hours prior to');
dbms_output.put_line ('upgrading the database.');
dbms_output.put_line ('To gather dictionary statistics execute the following command');
dbms_output.put_line ('while connected as SYSDBA:');
dbms_output.put_line ('    EXECUTE dbms_stats.gather_dictionary_stats;');
dbms_output.put_line ('');
dbms_output.put_line ('^^^ MANUAL ACTION SUGGESTED ^^^');
dbms_output.put_line ('');
END;

BEGIN dbms_preup.fixup_summary(TRUE); END;

BEGIN
dbms_output.put_line ('**************** Pre-Upgrade Fixup Script Complete *********************');
END;

END IF;

END;
/
REM Pre-Upgrade Script Closed At: 2014-08-04 21:59:39
REM __________________________________________________________________________
Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: