oracle 11g 11.1.6.0,oracle 11g 11.1.0.6.0升级到11g 11.1.0.7.0 for aix 5L操作步骤

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/slibcleanxhost +su - ora11gexport Display=ip地址:0.0cd /soft/11gpatch/Disk1./runInstaller3.升级数据库SQL> STARTUP UPGRADE

SQL> SPOOL patch.log

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

SQL> SPOOL OFF4.编译失效对象SQL> @?/rdbms/admin/utlrp.sql5.检查是否升级成功用以下脚本SELECT COMP_NAME, VERSION, STATUS FROM SYS.DBA_REGISTRY;