Upgrading to Oracle Database 11g-2

来源:互联网 发布:制作推文用什么软件 编辑:程序博客网 时间:2024/04/30 13:56

Pre-Upgrade Validation Checks

The "$ORACLE_HOME/rdbms/admin/utlu111i.sql" script performs pre-update validation checks on an existing instance. The script checks a number of areas to make sure the instance is suitable for upgrade including:
  • Database version.
  • Tablespace sizes.
  • Updated, renamed and deprecated initialization parameters.
  • Database components.
  • SYSAUX tablespace present (if missing).
  • Miscellaneous information.
The issues indicated by this script should be resolved before a manual upgrade is attempted. The type of output you can expect is displayed below.
SQL> conn / as sysdbaConnected.SQL> spool /tmp/upgrade.txtSQL> @utlu111i.sqlOracle Database 11.1 Pre-Upgrade Information Tool    08-11-2008 11:04:25.**********************************************************************Database:**********************************************************************--> name:          DB10G--> version:       10.2.0.1.0--> compatible:    10.2.0.1.0--> blocksize:     8192--> platform:      Linux IA (32-bit)--> timezone file: V2.**********************************************************************Tablespaces: [make adjustments in the current environment]**********************************************************************--> SYSTEM tablespace is adequate for the upgrade..... minimum required size: 720 MB.... AUTOEXTEND additional space required: 240 MB--> UNDOTBS1 tablespace is adequate for the upgrade..... minimum required size: 460 MB.... AUTOEXTEND additional space required: 435 MB--> SYSAUX tablespace is adequate for the upgrade..... minimum required size: 412 MB.... AUTOEXTEND additional space required: 182 MB--> TEMP tablespace is adequate for the upgrade..... minimum required size: 61 MB.... AUTOEXTEND additional space required: 41 MB.**********************************************************************Update Parameters: [Update Oracle Database 11.1 init.ora or spfile]**********************************************************************WARNING: --> "sga_target" needs to be increased to at least 336 MB.**********************************************************************Renamed Parameters: [Update Oracle Database 11.1 init.ora or spfile]**********************************************************************-- No renamed parameters found. No changes are required..**********************************************************************Obsolete/Deprecated Parameters: [Update Oracle Database 11.1 init.ora or spfile]**********************************************************************--> "background_dump_dest" replaced by  "diagnostic_dest"--> "user_dump_dest" replaced by  "diagnostic_dest"--> "core_dump_dest" 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--> OLAP Analytic Workspace      [upgrade]  VALID--> OLAP Catalog                 [upgrade]  VALID--> EM Repository                [upgrade]  VALID--> Oracle Text                  [upgrade]  VALID--> Oracle XML Database          [upgrade]  VALID--> Oracle Java Packages         [upgrade]  VALID--> Oracle interMedia            [upgrade]  VALID--> Spatial                      [upgrade]  VALID--> Data Mining                  [upgrade]  VALID--> Expression Filter            [upgrade]  VALID--> Rule Manager                 [upgrade]  VALID--> Oracle OLAP API              [upgrade]  VALID.**********************************************************************Miscellaneous Warnings**********************************************************************WARNING: --> Database is using an old timezone file version..... Patch the 10.2.0.1.0 database to timezone file version 4.... BEFORE upgrading the database.  Re-run utlu111i.sql after.... patching the database to record the new timezone file version.WARNING: --> Database contains stale optimizer statistics..... Refer to the 11g Upgrade Guide for instructions to update.... statistics prior to upgrading the database..... Component Schemas with stale statistics:....   SYS....   SYSMAN....   CTXSYS....   XDBWARNING: --> Database contains schemas with objects dependent on networkpackages..... Refer to the 11g Upgrade Guide for instructions to configure Network ACLs..... USER SYSMAN has dependent objects.WARNING: --> EM Database Control Repository exists in the database..... Direct downgrade of EM Database Control is not supported. Refer to the.... 11g Upgrade Guide for instructions to save the EM data prior to upgrade..PL/SQL procedure successfully completed.SQL> spool off

Database Upgrade Assistant (DBUA)

The Database Upgrade Assistant (DBUA) is a GUI tool that guides the user through the whole upgrade process, including all the steps listed in the manual upgrade process. The assistant is started using the dbua command in UNIX and Linux environments or from the Start menu (Start > Programs > Oracle - HOME_NAME > Configuration and Migration Tools > Database Upgrade Assistant) in Windows environments.

Once the assistant has started it leads the user through the several steps including:
  • Selecting the instance to upgrade.
  • Analyzing the existing database to make sure it is suitable for upgrade.
  • Creating the SYSAUX tablespace which is required for 11g.
  • Deciding whether to recompile all invalid objects when the upgrade is complete.
  • Selecting a backup option for the database.
  • Deciding how the database should be managed (OEM Console or Grid Control) and defining the appropriate authentication.
  • Defining the flash recovery area.
  • Performing any necessary network configuration.
  • Performing the upgrade process.
  • Checking the upgrade results.
  • Listing the changes in default behaviour between the old and new versionsof the database.
  • Completing the upgrade procedure.
The DBUA can also be started in silent mode provided all the necessary parameters are provided.

For more information see:
  • Oracle Database Upgrade Guide 11g Release 1 (11.1)
Hope this helps. Regards Tim...
0 0