oracle 11g 11.1.0.6.0升級到11g 11.1.0.7.0 for aix 5L操作步驟

   1.執行收集資訊工具,裡面會記錄相關資訊,比如用到的系統表空間是否足夠

1. Start the database, either in normal mode or in upgrade mode:

   SQL> STARTUP
   

   or

   SQL> STARTUP UPGRADE
   

2. Set the system to spool results to a log file for later analysis:

   SQL> SPOOL upgrade_info.log 
   

3. Run the Pre-Upgrade Information Tool:

   SQL> @?/rdbms/admin/utlu111i.sql
   

4. Turn off the spooling of script. results to the log file:

   SQL> SPOOL OFF

輸出的資訊如下:

Oracle Database 11.1 Pre-Upgrade Information Tool    06-15-2007 09:14:02
.
**********************************************************************
Database:
**********************************************************************
--&gt name:          ORCL
--&gt version:       10.2.0.1.0
--&gt compatible:    10.2.0.1
--&gt blocksize:     8192
--&gt timezone file: V2
.
**********************************************************************
Tablespaces: [make adjustments in the current environment]
**********************************************************************
WARNING: --&gt SYSTEM tablespace is not large enough for the upgrade.
.... currently allocated size: 560 MB
.... minimum required size: 910 MB
.... increase current size by: 350 MB
.... tablespace is NOT AUTOEXTEND ENABLED.
--&gt UNDOTBS1 tablespace is adequate for the upgrade.
.... minimum required size: 457 MB
.... AUTOEXTEND additional space required: 352 MB
--&gt SYSAUX tablespace is adequate for the upgrade.
.... minimum required size: 617 MB
.... AUTOEXTEND additional space required: 287 MB
--&gt TEMP tablespace is adequate for the upgrade.
.... minimum required size: 61 MB
.... AUTOEXTEND additional space required: 41 MB
--&gt EXAMPLE tablespace is adequate for the upgrade.
.... minimum required size: 69 MB
.
**********************************************************************
Update Parameters: [Update Oracle Database 11.1 init.ora or spfile]
**********************************************************************
WARNING: --&gt "sga_target" needs to be increased to at least 388 MB
.
**********************************************************************
Renamed Parameters: [Update Oracle Database 11.1 init.ora or spfile]
**********************************************************************
WARNING: --&gt "plsql_compiler_flags" old value was "INTERPRETED";
new name is "plsql_code_type" new value is "INTERPRETED"
.
**********************************************************************
Obsolete/Deprecated Parameters: [Update Oracle Database 11.1 init.ora or spfile]
**********************************************************************
--&gt "max_enabled_roles"
--&gt "remote_os_authent"
--&gt "background_dump_dest" replaced by "diagnostic_dest"
--&gt "user_dump_dest" replaced by "diagnostic_dest"
--&gt "core_dump_dest" replaced by "diagnostic_dest"
.
**********************************************************************
Components: [The following database components will be upgraded or installed]
**********************************************************************
--&gt Oracle Catalog Views         [upgrade]  VALID
--&gt Oracle Packages and Types    [upgrade]  VALID
--&gt JServer JAVA Virtual Machine [upgrade]  VALID
--&gt Oracle XDK for Java          [upgrade]  VALID
--&gt Oracle Workspace Manager     [upgrade]  VALID
--&gt Messaging Gateway            [upgrade]  VALID
--&gt OLAP Analytic Workspace      [upgrade]  VALID
--&gt OLAP Catalog                 [upgrade]  VALID
--&gt Oracle Label Security        [upgrade]  VALID
--&gt EM Repository                [upgrade]  VALID
--&gt Oracle Text                  [upgrade]  VALID
--&gt Oracle XML Database          [upgrade]  VALID
--&gt Oracle Java Packages         [upgrade]  VALID
--&gt Oracle interMedia            [upgrade]  VALID
--&gt Spatial                      [upgrade]  VALID
--&gt Data Mining                  [upgrade]  VALID
--&gt Oracle Ultra Search          [upgrade]  VALID
--&gt Expression Filter            [upgrade]  VALID
--&gt Rule Manager                 [upgrade]  VALID
--&gt Oracle Application Express   [upgrade]  VALID
--&gt Oracle OLAP API              [upgrade]  VALID
.
**********************************************************************
Miscellaneous Warnings
**********************************************************************
WARNING: --&gt 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: --&gt 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
....   WMSYS
....   CTXSYS
WARNING: --&gt Database contains INVALID objects prior to upgrade.
.... USER PUBLIC has 7 INVALID objects.
.... USER FLOWS_010600 has 1 INVALID objects.
.... USER SYS has 1 INVALID objects.
WARNING: --&gt Database contains schemas with objects dependent on network packages.
.... Refer to the 11g Upgrade Guide for instructions to configure Network ACLs.
.... USER WKSYS has dependent objects.
.... USER SYSMAN has dependent objects.
WARNING: --&gt 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. 
 
2.執行升級軟體  
  關閉資料庫和監聽,如果還有asm,dbconsole都要關閉
  執行清理記憶體,釋放相關程式命令
  /usr/sbin/slibclean
  xhost +
  su - ora11g
  export Display=ip地址:0.0
  cd /soft/11gpatch/Disk1
  ./runInstaller
3.升級資料庫
  SQL> STARTUP UPGRADE
  SQL> SPOOL patch.log
  SQL> @?/rdbms/admin/catupgrd.sql
  SQL> SPOOL OFF
4.編譯失效物件
   SQL> @?/rdbms/admin/utlrp.sql
5.檢查是否升級成功用以下指令碼
  SELECT COMP_NAME, VERSION, STATUS FROM SYS.DBA_REGISTRY;