当前位置：首页 -> 基础 -> 数据库编程

探索Oracle之数据库升级二11.2.0.3升级到11.2.0.4完整步骤(八)

2015-02-02 23:09:37 · 作者: · 浏览: 79
标签: 探索 Oracle 数据库 升级 11.2.0.3 11.2.0.4 完整 步骤
. ********************************************************************** 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.

11、执行升级操作 

SQL> shutdown immediate

Database closed.
Database dismounted.
ORACLE instance shut down.

SQL> startup upgrade;

ORACLE instance started.
Total System Global Area2872786944 bytes
Fixed Size                  2256712 bytes
Variable Size            2634023096 bytes
Database Buffers          218103808 bytes
Redo Buffers               18403328 bytes
Database mounted.

Database opened.

SQL> set echo on
SQL> spool/home/oracle/upgrade.log
SQL> set time on;

03:28:37 SQL>@?/rdbms/admin/catupgrd.sql  ---该脚本会运行十分钟左右
……..

Oracle Database 11.2Post-Upgrade Status Tool          10-04-2014 04:01:36
.
Component                               Current      Version     Elapsed Time
Name                                    Status       Number      HH:MM:SS
.
Oracle Server
.                                        VALID      11.2.0.4.0  00:08:38
JServer JAVA Virtual Machine
.                                        VALID      11.2.0.4.0  00:04:26
Oracle Workspace Manager
.                                        VALID      11.2.0.4.0  00:00:25
OLAP Analytic Workspace
.                                        VALID      11.2.0.4.0  00:01:27
OLAP Catalog
.                                        VALID      11.2.0.4.0  00:00:32
Oracle OLAP API
.                                        VALID      11.2.0.4.0  00:00:19
Oracle Enterprise Manager
.                                        VALID      11.2.0.4.0  00:06:25
Oracle XDK
.                                         VALID      11.2.0.4.0  00:00:26
Oracle Text
.                                        VALID      11.2.0.4.0  00:00:24
Oracle XML Database
.                                        VALID      11.2.0.4.0  00:01:46
Oracle Database JavaPackages
.                                         VALID      11.2.0.4.0  00:00:08
Oracle Multimedia
.                                        VALID      11.2.0.4.0  00:01:43
Spatial
.                                        VALID      11.2.0.4.0  00:05:34
Oracle Expression Filter
.                                        VALID      11.2.0.4.0  00:00:06
Oracle Rules Manager
.                                        VALID      11.2.0.4.0  00:00:07
Oracle Application Express
.                                        VALID     3.2.1.00.12
Final Actions
.                                                               00:00:00
Total Upgrade Time: 00:32:35

 
PL/SQL proceduresuccessfully completed.

 
04:01:36 SQL>






 
04:01:36 SQL> SETSERVEROUTPUT OFF
04:01:36 SQL> SET VERIFYON
04:01:36 SQL> commit;

 
Commit complete.

 

04:01:36 SQL> 
04:01:36 SQL> shutdownimmediate;

Database closed.
Database dismounted.
ORACLE instance shut down.

04:01:54 SQL> 
04:01:54 SQL> 
04:01:54 SQL> DOC
04:01:54 DOC>#######################################################################
04:01:54DOC>#######################################################################
04:01:54 DOC>
04:01:54 DOC>   The ab