Upgrading to Oracle Database 11g-2
来源:互联网 发布:制作推文用什么软件 编辑:程序博客网 时间:2024/04/30 13:56
Pre-Upgrade Validation Checks
The "$ORACLE_HOME/rdbms/admin/utlu111i.sql" script performs pre-update validation checks on an existing instance. The script checks a number of areas to make sure the instance is suitable for upgrade including:
- Database version.
- Tablespace sizes.
- Updated, renamed and deprecated initialization parameters.
- Database components.
- SYSAUX tablespace present (if missing).
- Miscellaneous information.
The issues indicated by this script should be resolved before a manual upgrade is attempted. The type of output you can expect is displayed below.
SQL> conn / as sysdbaConnected.SQL> spool /tmp/upgrade.txtSQL> @utlu111i.sqlOracle Database 11.1 Pre-Upgrade Information Tool 08-11-2008 11:04:25.**********************************************************************Database:**********************************************************************--> name: DB10G--> version: 10.2.0.1.0--> compatible: 10.2.0.1.0--> blocksize: 8192--> platform: Linux IA (32-bit)--> timezone file: V2.**********************************************************************Tablespaces: [make adjustments in the current environment]**********************************************************************--> SYSTEM tablespace is adequate for the upgrade..... minimum required size: 720 MB.... AUTOEXTEND additional space required: 240 MB--> UNDOTBS1 tablespace is adequate for the upgrade..... minimum required size: 460 MB.... AUTOEXTEND additional space required: 435 MB--> SYSAUX tablespace is adequate for the upgrade..... minimum required size: 412 MB.... AUTOEXTEND additional space required: 182 MB--> TEMP tablespace is adequate for the upgrade..... minimum required size: 61 MB.... AUTOEXTEND additional space required: 41 MB.**********************************************************************Update Parameters: [Update Oracle Database 11.1 init.ora or spfile]**********************************************************************WARNING: --> "sga_target" needs to be increased to at least 336 MB.**********************************************************************Renamed Parameters: [Update Oracle Database 11.1 init.ora or spfile]**********************************************************************-- No renamed parameters found. No changes are required..**********************************************************************Obsolete/Deprecated Parameters: [Update Oracle Database 11.1 init.ora or spfile]**********************************************************************--> "background_dump_dest" replaced by "diagnostic_dest"--> "user_dump_dest" replaced by "diagnostic_dest"--> "core_dump_dest" replaced by "diagnostic_dest".**********************************************************************Components: [The following database components will be upgraded or installed]**********************************************************************--> Oracle Catalog Views [upgrade] VALID--> Oracle Packages and Types [upgrade] VALID--> JServer JAVA Virtual Machine [upgrade] VALID--> Oracle XDK for Java [upgrade] VALID--> Oracle Workspace Manager [upgrade] VALID--> OLAP Analytic Workspace [upgrade] VALID--> OLAP Catalog [upgrade] VALID--> EM Repository [upgrade] VALID--> Oracle Text [upgrade] VALID--> Oracle XML Database [upgrade] VALID--> Oracle Java Packages [upgrade] VALID--> Oracle interMedia [upgrade] VALID--> Spatial [upgrade] VALID--> Data Mining [upgrade] VALID--> Expression Filter [upgrade] VALID--> Rule Manager [upgrade] VALID--> Oracle OLAP API [upgrade] VALID.**********************************************************************Miscellaneous Warnings**********************************************************************WARNING: --> 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: --> 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.... SYSMAN.... CTXSYS.... XDBWARNING: --> Database contains schemas with objects dependent on networkpackages..... Refer to the 11g Upgrade Guide for instructions to configure Network ACLs..... USER SYSMAN has dependent objects.WARNING: --> 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..PL/SQL procedure successfully completed.SQL> spool off
Database Upgrade Assistant (DBUA)
The Database Upgrade Assistant (DBUA) is a GUI tool that guides the user through the whole upgrade process, including all the steps listed in the manual upgrade process. The assistant is started using the
Once the assistant has started it leads the user through the several steps including:
dbua
command in UNIX and Linux environments or from the Start menu (Start > Programs > Oracle - HOME_NAME > Configuration and Migration Tools > Database Upgrade Assistant) in Windows environments.Once the assistant has started it leads the user through the several steps including:
- Selecting the instance to upgrade.
- Analyzing the existing database to make sure it is suitable for upgrade.
- Creating the SYSAUX tablespace which is required for 11g.
- Deciding whether to recompile all invalid objects when the upgrade is complete.
- Selecting a backup option for the database.
- Deciding how the database should be managed (OEM Console or Grid Control) and defining the appropriate authentication.
- Defining the flash recovery area.
- Performing any necessary network configuration.
- Performing the upgrade process.
- Checking the upgrade results.
- Listing the changes in default behaviour between the old and new versionsof the database.
- Completing the upgrade procedure.
The DBUA can also be started in silent mode provided all the necessary parameters are provided.
For more information see:
For more information see:
- Oracle Database Upgrade Guide 11g Release 1 (11.1)
Hope this helps. Regards Tim...
0 0
- Upgrading to Oracle Database 11g-2
- Upgrading to Oracle Database 11g-1
- Upgrading to Oracle Database 10g
- oracle database 11g - create database
- Oracle Database 11g SQL
- Oracle Database 11g SQL
- oracle database 11g installtion
- Oracle database 11g安装
- 68.You are managing an Oracle Database 11g database. You want to ensure the recovery of the database
- 73.You are managing an Oracle Database 11g database. You configured the database to run in ARCHIVELO
- 78.You are managing an Oracle Database 11g database. The database is open, and you plan to perform R
- [Oracle]Oracle Database 11g 基础教程 第一章
- 《Oracle Database Concepts 11g Release 2》读书笔记(2)-table
- 《Oracle Database Concepts 11g Release 2》读书笔记(1)-schema
- oracle database 11g 版本2的安装
- Oracle Database 11g Release 2 on Ubuntu 12.04 HOWTO
- Pro Oracle Database 11g RAC on Linux 读书笔记2
- Oracle Database 11g Release 2 下载网址收藏
- 专家极力推荐的十大优秀学习习惯
- 帧锁定算法解决游戏同步
- 如何编写高效android代码
- 【翻译】安卓最新API文档——Services(The Basics基本概况)
- 文化产业商业计划书 双十一是垃圾消费么?垃圾短信你中了几条?
- Upgrading to Oracle Database 11g-2
- cocos2d-x_Android应用启动调用过程简析
- 网络游戏同步问题
- 线程的创建
- RTS游戏的行军算法
- 第25讲 UI组件之 AlertDialog 的各种实现
- Java中HashMap和HashSet存储机制
- 异常处理
- 去除VS2010对汉字的拼写检查后留下的红色波浪线