WEB开发网
开发学院数据库Oracle Oracle 9206升级到10.2.0.2简要步骤 阅读

Oracle 9206升级到10.2.0.2简要步骤

 2007-05-05 12:04:45 来源:WEB开发网   
核心提示:1.安装oracle 10g r2的软件2.打oracle 10g最新的补丁,我打的是升级到10.2.0.2的补丁3.运行Pre-Upgrade Information Tool,Oracle 9206升级到10.2.0.2简要步骤,它用来分析升级到10g前你要做的一些操作,比如需要增加或减少的参数等,启动要升级的DB

1.安装oracle 10g r2的软件

2.打oracle 10g最新的补丁,我打的是升级到10.2.0.2的补丁

3.运行Pre-Upgrade Information Tool。它用来分析升级到10g前你要做的一些操作,比如需要增加或减少的参数等。

启动要升级的DB,用SYSDBA运行10g的ORACLE_HOME/rdbms/admin下的utlu102i.sql,查看产生的日志。

SQL> SPOOL info.log
SQL> @utlu102i.sql
SQL> SPOOL OFF

下面是我的info.log.

SQL> @d:utlu102i.sql;
Oracle Database 10.2 Upgrade Information Utility  01-17-2007 13:22:37    
.                                   
***********************************************************    
Database:                               
***********************************************************    
--> name:    ZHANGYE                        
--> version:  9.2.0.6.0                       
--> compatible: 9.2.0.0.0                       
--> blocksize: 8192                         
.                                   
***********************************************************    
Logfiles: [make adjustments in the current environment]        
***********************************************************    
--> The existing log files are adequate. No changes are required.  
.                                   
***********************************************************    
Tablespaces: [make adjustments in the current environment]      
***********************************************************    
--> SYSTEM tablespace is adequate for the upgrade.          
.... minimum required size: 248 MB               
--> TEMP tablespace is adequate for the upgrade.           
.... minimum required size: 58 MB                   
.... AUTOEXTEND additional space required: 18 MB           
.                                   
***********************************************************    
Update Parameters: [Update Oracle Database 10.2 init.ora or spfile]  
***********************************************************    
WARNING: --> "shared_pool_size" needs to be increased to at least 177861837  
WARNING: --> "java_pool_size" needs to be increased to at least 67108864    
WARNING: --> "streams_pool_size" is not currently defined and needs a value of 
at least 50331648                           
WARNING: --> "session_max_open_files" needs to be increased to at least 20   
.                                   
***********************************************************   
Renamed Parameters: [Update Oracle Database 10.2 init.ora or spfile] 
***********************************************************   
-- No renamed parameters found. No changes are required.       
.                                   
***********************************************************    
Obsolete/Deprecated Parameters: [Update Oracle Database 10.2 init.ora or spfile]
***********************************************************     
--> "hash_join_enabled"                        
--> "log_archive_start"                       
.                                   
***********************************************************     
Components: [The following database components will be upgraded or installed] 
***********************************************************   
--> Oracle Catalog Views     [upgrade] VALID          
--> Oracle Packages and Types  [upgrade] VALID          
.                                   
***********************************************************    
Miscellaneous Warnings                        
***********************************************************    
WARNING: --> Deprecated CONNECT role granted to some user/roles.  
.... CONNECT role after upgrade has only CREATE SESSION privilege.  
WARNING: --> Database contains stale optimizer statistics.      
.... Refer to the 10g Upgrade Guide for instructions to update  
.... statistics prior to upgrading the database.       
.... Component Schemas with stale statistics:          
....  SYS                           
.                               
************************************************************    
SYSAUX Tablespace:                   
[Create tablespace in the Oracle Database 10.2 environment]     
************************************************************ 
--> New "SYSAUX" tablespace               
.... minimum required size for database upgrade: 500 MB       
.

PL/SQL 过程已成功完成。

1 2 3  下一页

Tags:oracle 升级 简要

编辑录入:爽爽 [复制链接] [打 印]
赞助商链接