Z $11g_ORACLE_HOME/rdbms/admin/ je potřeba překopírovat utilitu utlu112i.sql na zdrojový server a spustit na zdrojové databázi, abychom zjistili, co je potřeba nastavit a nainstalovat před vlastním upgradem.SQL> @utlu112i.sqlOracle Database 11.2 Pre-Upgrade Information Tool 02-28-2011 09:16:21Script Version: 11.2.0.2.0 Build: 001.**********************************************************************Database:**********************************************************************–> name: orcl–> version: 9.2.0.8.0–> compatible: 9.2.0.0.0–> blocksize: 8192–> timezone file: V1.**********************************************************************Logfiles: [make adjustments in the current environment]**********************************************************************–> The existing log files are adequate. No changes are required..**********************************************************************Tablespaces: [make adjustments in the current environment]**********************************************************************–> SYSTEM tablespace is adequate for the upgrade….. minimum required size: 703 MB–> UNDOTBS1 tablespace is adequate for the upgrade….. minimum required size: 263 MBWARNING: –> TEMP tablespace is not large enough for the upgrade….. currently allocated size: 40 MB…. minimum required size: 61 MB…. increase current size by: 21 MB…. tablespace is NOT AUTOEXTEND ENABLED.–> DRSYS tablespace is adequate for the upgrade….. minimum required size: 29 MB–> XDB tablespace is adequate for the upgrade….. minimum required size: 57 MB
.**********************************************************************Update Parameters: [Update Oracle Database 11.2 init.ora or spfile]Note: Pre-upgrade tool was run on a lower version 32-bit database.**********************************************************************–> If Target Oracle is 32-Bit, refer here for Update Parameters:WARNING: –> „compatible“ must be set to at least 10.1.0WARNING: –> „shared_pool_size“ needs to be increased to at least 252 MBWARNING: –> „java_pool_size“ needs to be increased to at least 64 MBWARNING: –> „db_cache_size“ needs to be increased to at least 50331648 bytes.–> If Target Oracle is 64-Bit, refer here for Update Parameters:WARNING: –> „compatible“ must be set to at least 10.1.0WARNING: –> „shared_pool_size“ needs to be increased to at least 488 MBWARNING: –> „java_pool_size“ needs to be increased to at least 128 MBWARNING: –> „db_cache_size“ needs to be increased to at least 50331648 bytes.**********************************************************************Renamed Parameters: [Update Oracle Database 11.2 init.ora or spfile]**********************************************************************– No renamed parameters found. No changes are required..**********************************************************************Obsolete/Deprecated Parameters: [Update Oracle Database 11.2 init.ora or spfile]**********************************************************************–> hash_join_enabled 10.1 OBSOLETE–> background_dump_dest 11.1 DEPRECATED replaced by „diagnostic_dest“–> user_dump_dest 11.1 DEPRECATED replaced by „diagnostic_dest“.**********************************************************************Components: [The following database components will be upgraded or installed]**********************************************************************–> Oracle Catalog Views [upgrade] VALID–> Oracle Packages and Types [upgrade] VALID–> JServer JAVA Virtual Machine [upgrade] VALID–> Oracle XDK for Java [upgrade] VALID–> Oracle Workspace Manager [upgrade] VALID–> Oracle Text [upgrade] VALID–> Oracle XML Database [upgrade] VALID–> Oracle Java Packages [upgrade] VALID–> Oracle interMedia [upgrade] VALID–> Spatial [upgrade] VALID–> Oracle Ultra Search [upgrade] VALID.**********************************************************************Miscellaneous Warnings**********************************************************************WARNING: –> Passwords exist in some database links….. Passwords will be encrypted during the upgrade….. Downgrade of database links with passwords is not supported.WARNING: –> Deprecated CONNECT role granted to some user/roles….. CONNECT role after upgrade has only CREATE SESSION privilege.WARNING: –> Database is using a timezone file older than version 14….. After the release migration, it is recommended that DBMS_DST package…. be used to upgrade the 9.2.0.8.0 database timezone version…. to the latest version which comes with the new release.WARNING: –> Database contains INVALID objects prior to upgrade….. The list of invalid SYS/SYSTEM objects was written to…. registry$sys_inv_objs….. The list of non-SYS/SYSTEM objects was written to…. registry$nonsys_inv_objs….. Use utluiobj.sql after the upgrade to identify any new invalid…. objects due to the upgrade….. USER CORE has 10 INVALID objects….. USER CTXSYS has 135 INVALID objects….. USER HR has 4 INVALID objects….. USER MDSYS has 177 INVALID objects….. USER MONEY_IN has 23 INVALID objects….. USER MONEY_OUT has 12 INVALID objects….. USER ORDPLUGINS has 28 INVALID objects….. USER ORDSYS has 48 INVALID objects….. USER SYS has 108 INVALID objects….. USER WEB has 9 INVALID objects….. USER WKSYS has 112 INVALID objects….. USER WMSYS has 29 INVALID objects….. USER XDB has 195 INVALID objects..**********************************************************************Recommendations**********************************************************************Oracle recommends gathering dictionary statistics prior toupgrading the database.To gather dictionary statistics execute the following commandswhile connected as SYSDBA: EXECUTE dbms_stats.gather_schema_stats(‚DBSNMP‘,options=>’GATHER‘ ,estimate_percent=>DBMS_STATS.AUTO_SAMPLE_SIZE ,method_opt=>’FOR ALL COLUMNS SIZE AUTO‘ ,cascade=>TRUE); EXECUTE dbms_stats.gather_schema_stats(‚OUTLN‘,options=>’GATHER‘ ,estimate_percent=>DBMS_STATS.AUTO_SAMPLE_SIZE ,method_opt=>’FOR ALL COLUMNS SIZE AUTO‘ ,cascade=>TRUE); EXECUTE dbms_stats.gather_schema_stats(‚ORDPLUGINS‘,options=>’GATHER‘ ,estimate_percent=>DBMS_STATS.AUTO_SAMPLE_SIZE ,method_opt=>’FOR ALL COLUMNS SIZE AUTO‘ ,cascade=>TRUE); EXECUTE dbms_stats.gather_schema_stats(‚ORDSYS‘,options=>’GATHER‘ ,estimate_percent=>DBMS_STATS.AUTO_SAMPLE_SIZE ,method_opt=>’FOR ALL COLUMNS SIZE AUTO‘ ,cascade=>TRUE); EXECUTE dbms_stats.gather_schema_stats(‚WKSYS‘,options=>’GATHER‘ ,estimate_percent=>DBMS_STATS.AUTO_SAMPLE_SIZE ,method_opt=>’FOR ALL COLUMNS SIZE AUTO‘ ,cascade=>TRUE); EXECUTE dbms_stats.gather_schema_stats(‚XDB‘,options=>’GATHER‘ ,estimate_percent=>DBMS_STATS.AUTO_SAMPLE_SIZE ,method_opt=>’FOR ALL COLUMNS SIZE AUTO‘ ,cascade=>TRUE); EXECUTE dbms_stats.gather_schema_stats(‚CTXSYS‘,options=>’GATHER‘ ,estimate_percent=>DBMS_STATS.AUTO_SAMPLE_SIZE ,method_opt=>’FOR ALL COLUMNS SIZE AUTO‘ ,cascade=>TRUE); EXECUTE dbms_stats.gather_schema_stats(‚MDSYS‘,options=>’GATHER‘ ,estimate_percent=>DBMS_STATS.AUTO_SAMPLE_SIZE ,method_opt=>’FOR ALL COLUMNS SIZE AUTO‘ ,cascade=>TRUE); EXECUTE dbms_stats.gather_schema_stats(‚WMSYS‘,options=>’GATHER‘ ,estimate_percent=>DBMS_STATS.AUTO_SAMPLE_SIZE ,method_opt=>’FOR ALL COLUMNS SIZE AUTO‘ ,cascade=>TRUE); EXECUTE dbms_stats.gather_schema_stats(‚SYSTEM‘,options=>’GATHER‘ ,estimate_percent=>DBMS_STATS.AUTO_SAMPLE_SIZE ,method_opt=>’FOR ALL COLUMNS SIZE AUTO‘ ,cascade=>TRUE); EXECUTE dbms_stats.gather_schema_stats(‚SYS‘,options=>’GATHER‘ ,estimate_percent=>DBMS_STATS.AUTO_SAMPLE_SIZE ,method_opt=>’FOR ALL COLUMNS SIZE AUTO‘ ,cascade=>TRUE);**********************************************************************Oracle recommends removing all hidden parameters prior to upgrading.To view existing hidden parameters execute the following commandwhile connected AS SYSDBA: SELECT name,description from SYS.V$PARAMETER WHERE name LIKE ‚\_%‘ ESCAPE ‚\’Changes will need to be made in the init.ora or spfile.**********************************************************************Oracle recommends reviewing any defined events prior to upgrading.To view existing non-default events execute the following commandswhile connected AS SYSDBA: Events: SELECT (translate(value,chr(13)||chr(10),‘ ‚)) FROM sys.v$parameter2 WHERE UPPER(name) =’EVENT‘ AND isdefault=’FALSE‘ Trace Events: SELECT (translate(value,chr(13)||chr(10),‘ ‚)) from sys.v$parameter2 WHERE UPPER(name) = ‚_TRACE_EVENTS‘ AND isdefault=’FALSE’Changes will need to be made in the init.ora or spfile.********************************************************************************************************************************************SYSAUX Tablespace:[Create tablespace in the Oracle Database 11.2 environment]**********************************************************************–> New „SYSAUX“ tablespace…. minimum required size for database upgrade: 500 MB.SQL>