REM Pre-Upgrade Script Generated on: 2013-07-24 15:00:32 REM Generated by Version: 12.1.0.1 Build: 006 SET ECHO OFF SERVEROUTPUT ON FORMAT WRAPPED TAB OFF LINESIZE 750; BEGIN dbms_output.put_line ('Pre-Upgrade Fixup Script Generated on 2013-07-24 15:00:32 Version: 12.1.0.1 Build: 006'); dbms_output.put_line ('Beginning Pre-Upgrade Fixups...'); END; / BEGIN dbms_preup.clear_run_flag(TRUE); END; / BEGIN -- ***************** Fixup Details *********************************** -- Name: DEFAULT_PROCESS_COUNT -- Description: Verify min process count is not too low -- Severity: Warning -- Action: ^^^ MANUAL ACTION REQUIRED ^^^ -- Fix Summary: -- Review and increase if needed, your PROCESSES value. dbms_preup.run_fixup_and_report('DEFAULT_PROCESS_COUNT'); END; / BEGIN -- ***************** Fixup Details *********************************** -- Name: EM_PRESENT -- Description: Check if Enterprise Manager is present -- Severity: Warning -- Action: Fixup routine -- Fix Summary: -- Execute emremove.sql prior to upgrade. dbms_preup.run_fixup_and_report('EM_PRESENT'); END; / BEGIN -- ***************** Fixup Details *********************************** -- Name: DBMS_LDAP_DEPENDENCIES_EXIST -- Description: Check for dependency on DBMS_LDAP package -- Severity: Warning -- Action: ^^^ MANUAL ACTION REQUIRED ^^^ -- Fix Summary: -- Network Objects must be reviewed manually. dbms_preup.run_fixup_and_report('DBMS_LDAP_DEPENDENCIES_EXIST'); END; / BEGIN -- ***************** Fixup Details *********************************** -- Name: AMD_EXISTS -- Description: Check to see if AMD is present in the database -- Severity: Informational -- Action: ^^^ MANUAL ACTION REQUIRED ^^^ -- Fix Summary: -- Manually execute ORACLE_HOME/oraolap/admin/catnoamd.sql script to remove OLAP. dbms_preup.run_fixup_and_report('AMD_EXISTS'); 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; / REM Pre-Upgrade Script Closed At: 2013-07-24 15:00:48