探索Oracle之,探索Oracle之数据库升级二 11.2.0.3升级到11.2.0.4完整步骤--测试成功版本...

[oracle@db01 dbs]$ sqlplus /as sysdba   SQL*Plus: Release 11.2.0.4.0Production on Sat Oct 4 02:26:01 2014 Copyright (c) 1982, 2013,Oracle.  All rights reserved. Connected to an idleinstance.   SQL> startup upgrade;

ORACLE instance started. Total System Global Area2037673984 bytes Fixed Size                  2254704 bytes Variable Size            1811941520 bytes Database Buffers          218103808 bytes Redo Buffers                5373952 bytes Database mounted. Database opened.

SQL>@?/rdbms/admin/utlu112i.sql    ---执行升级前检查

Oracle Database 11.2Pre-Upgrade Information Tool 10-04-2014 02:27:38 Script Version: 11.2.0.4.0Build: 001 . ********************************************************************** Database: **********************************************************************

--> name:          WOO --> version:       11.2.0.3.0 --> compatible:    11.2.0.0.0 --> blocksize:     8192 --> platform:      Linux x86 64-bit --> timezone file: V14 . ********************************************************************** Tablespaces: [makeadjustments in the current environment] **********************************************************************

--> SYSTEM tablespace isadequate for the upgrade. .... minimum required size:917 MB --> SYSAUX tablespace isadequate for the upgrade. .... minimum required size:646 MB --> UNDOTBS1 tablespaceis adequate for the upgrade. .... minimum required size:400 MB --> TEMP tablespace isadequate for the upgrade. .... minimum required size:60 MB . ********************************************************************** Flashback: OFF **********************************************************************

********************************************************************** Update Parameters: [UpdateOracle Database 11.2 init.ora or spfile] Note: Pre-upgrade tool wasrun on a lower version 64-bit database. **********************************************************************

--> If Target Oracle is32-Bit, refer here for Update Parameters: WARNING: -->"shared_pool_size" needs to be increased to at least 236 MB . --> If Target Oracle is64-Bit, refer here for Update Parameters: WARNING: -->"shared_pool_size" needs to be increased to at least 472 MB . ********************************************************************** Renamed Parameters: [UpdateOracle Database 11.2 init.ora or spfile] ********************************************************************** -- No renamed parametersfound. No changes are required. . ********************************************************************** Obsolete/DeprecatedParameters: [Update Oracle Database 11.2 init.ora or spfile] ********************************************************************** -- No obsolete parametersfound. No changes are required

. ********************************************************************** Components: [The followingdatabase components will be upgraded or installed] **********************************************************************

--> Oracle CatalogViews         [upgrade]  VALID --> Oracle Packages andTypes    [upgrade]  VALID --> JServer JAVA VirtualMachine [upgrade]  VALID --> Oracle XDK forJava          [upgrade]  VALID --> Oracle WorkspaceManager     [upgrade]  VALID --> OLAP Analytic Workspace      [upgrade] VALID --> OLAP Catalog                 [upgrade]  VALID --> EM Repository                [upgrade]  VALID --> Oracle Text                  [upgrade]  VALID --> Oracle XMLDatabase          [upgrade]  VALID --> Oracle Java Packages         [upgrade]  VALID --> OracleinterMedia            [upgrade]  VALID --> Spatial                      [upgrade]  VALID --> ExpressionFilter            [upgrade]  VALID --> Rule Manager                 [upgrade]  VALID --> Oracle ApplicationExpress   [upgrade]  VALID ... APEX will only beupgraded if the version of APEX in ... the target Oracle homeis higher than the current one. --> Oracle OLAP API              [upgrade]  VALID . ********************************************************************** Miscellaneous Warnings **********************************************************************

WARNING: --> Your recyclebin is turned on and currently contains no objects. .... Because it is REQUIREDthat the recycle bin be empty prior to upgrading .... and your recycle bin isturned on, you may need to execute the command:         PURGE DBA_RECYCLEBIN .... prior to executing yourupgrade to confirm the recycle bin is empty. WARNING: --> Databasecontains schemas with objects dependent on DBMS_LDAP package. .... Refer to the 11gUpgrade Guide for instructions to configure Network ACLs. .... USER APEX_030200 hasdependent objects. .

********************************************************************** Recommendations **********************************************************************

Oracle recommends gatheringdictionary statistics prior to upgrading the database. To gather dictionarystatistics execute the following command while connected as SYSDBA:

EXECUTE dbms_stats.gather_dictionary_stats;

********************************************************************** Oracle recommends removingall hidden parameters prior to upgrading. To view existing hiddenparameters execute the following command while connected AS SYSDBA:       SELECT name,description fromSYS.V$PARAMETER WHERE name         LIKE '\_%' ESCAPE '\'

Changes will need to be madein the init.ora or spfile. **********************************************************************

Oracle recommends reviewingany defined events prior to upgrading. To view existing non-defaultevents execute the following commands while 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' ANDisdefault='FALSE'   Changes will need to be madein the init.ora or spfile.