静默升级oracle（文档）to 10.2.0.4 from 10.2.0.1

静默升级oracle（文档）

1、 停止所有服务

emctl stop dbconsole

isqlplus stop

lsnrctl stop

sqlplus /nolog

conn /as sysdba

shutdown immediate

export ORACLE_SID=+ASM

sqlplus /nolog

conn /as sysdba

shutdown immediate

# $ORACLE_HOME/bin/crsctl stop crs

2、 备份数据

备份：tar -zcvf full_tar.gz $ORACLE_BASE/

恢复：tar –zxvf full_tar.gz –C $ORACLE_BASE/

3、 静默升级Opatch

a)  编辑responseFile文件…/Disk1/response 目录下的patchset.rsp

vi patchset.rsp 并添加以下内容

UNIX_GROUP_NAME=oinstall

FROM_LOCATION=/opt/Disk1/stage/products.xml

ORACLE_HOME=/opt/oracle/product/10.2.0/db_2

ORACLE_HOME_NAME=OraDb10g_home1

b)  执行静默升级Opatch

$/opt/Disk1/runInstaller -silent -responseFile /opt/Disk1/response/patchset.rsp –force

root用户执行脚本：/opt/oracle/product/10.2.0/db_2/root.sh

c)  检测Opatch升级情况

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

4、 升级数据库

lsnrctl start

SQL> startup upgrade

SQL> @?/rdbms/admin/catupgrd.sql  ---升级

SQL> startup

SQL> @?/rdbms/admin/utlrp.sql  ---重新编译无效的plsql包

5、 检验升级组件状态

select comp_name, version, status from sys.dba_registry;

6、 如果使用了Oracle Recovery Manager catalog

$rman catalog username/password@alias

7、 升级EM

emca –upgrade db

 

 

附表：（升级全过程）

 

1、升级前数据库状态

sys@TEST> select comp_name, version, status from sys.dba_registry;

COMP_NAME                                VERSION              STATUS

---------------------------------------- -------------------- --------------------

Oracle Database Catalog Views            10.2.0.1.0           VALID

Oracle Database Packages and Types       10.2.0.1.0           VALID

Oracle Workspace Manager                 10.2.0.1.0           VALID

JServer JAVA Virtual Machine             10.2.0.1.0           VALID

Oracle XDK                               10.2.0.1.0           VALID

Oracle Database Java Packages            10.2.0.1.0           VALID

Oracle Expression Filter                 10.2.0.1.0           VALID

Oracle Data Mining                       10.2.0.1.0           VALID

Oracle Text                              10.2.0.1.0           VALID

Oracle XML Database                      10.2.0.1.0           VALID

Oracle Rules Manager                     10.2.0.1.0           VALID

Oracle interMedia                        10.2.0.1.0           VALID

OLAP Analytic Workspace                  10.2.0.1.0           VALID

Oracle OLAP API                          10.2.0.1.0           VALID

OLAP Catalog                             10.2.0.1.0           VALID

Spatial                                  10.2.0.1.0           VALID

Oracle Enterprise Manager                10.2.0.1.0           VALID

17 rows selected.

 

2、关闭所有进程

emctl stop dbconsole

isqlplus stop

lsnrctl stop

sqlplus /nolog

conn /as sysdba

shutdown immediate

export ORACLE_SID=+ASM

sqlplus /nolog

conn /as sysdba

shutdown immediate

# $ORACLE_HOME/bin/crsctl stop crs

3、备份数据

备份：tar -zcvf full_tar.gz $ORACLE_BASE/

恢复：tar –zxvf full_tar.gz –C $ORACLE_BASE/

 

4、静默升级Opatch

a)编辑responseFile文件…/Disk1/response 目录下的patchset.rsp

vi patchset.rsp 并添加以下内容

UNIX_GROUP_NAME=oinstall

FROM_LOCATION=/opt/Disk1/stage/products.xml

ORACLE_HOME=/opt/oracle/product/10.2.0/db_3

ORACLE_HOME_NAME=OraDb10g_home1

 

b)执行静默安装Opatch

[ora@dg-ss response]$ /opt/Disk1/runInstaller -silent -responseFile /opt/Disk1/response/patchset.rsp -force

正在启动 Oracle Universal Installer...

正在检查安装程序要求...

检查操作系统版本: 必须是redhat-3, SuSE-9, SuSE-10, redhat-4, redhat-5, UnitedLinux-1.0, asianux-1, asianux-2 or asianux-3

                                      通过

所有安装程序要求均已满足。

准备从以下地址启动 Oracle Universal Installer /tmp/OraInstall2012-10-29_10-42-39AM. 请稍候...[ora@dg-ss response]$ Oracle Universal Installer, 版本 10.2.0.4.0 正式版

版权所有 (c) 1999, 2008, Oracle。保留所有权利。

 

本次安装会话的日志可见于:

 /opt/oraInventory/logs/installActions2012-10-29_10-42-39AM.log

.................................................................................................... 100% 已完成。

正在加载产品信息

......................................................................................................... 100% 已完成。

开始执行先决条件...

Total No of checks: 2

Performing check for checkToInstallCCR

检查 Oracle 主目录中已安装的组件

检查完成。此次检查的总体结果为: 通过

Check complete: 通过

=======================================================================

Performing check for CompatibilityChecks

正在检查 Oracle 主目录的不兼容性...

检查完成。此次检查的总体结果为: 通过

Check complete: 通过

=======================================================================

PrereqChecks complete

分析相关性

............................................................................................................ 100% 已完成。

-----------------------------------------------------------------------------

概要

全局设置

    来源: /opt/Disk1/stage/products.xml

    Oracle 主目录: /opt/oracle/product/10.2.0/db_2 (OraDb10g_home1)

产品语言

   简体中文

   英语

空间要求

   / 要求空间 1.09GB (包括 42MB 临时空间) : 可用空间 3.06GB

新安装组件 (80 个产品)

   Oracle Notification Service Patch 10.2.0.4.0

   Database Configuration and Upgrade Assistants Patch 10.2.0.4.0

   Character Set Migration Utility Patch 10.2.0.4.0

   Oracle Database 10g Patch 10.2.0.4.0

   Oracle JDBC/OCI Instant Client Patch 10.2.0.4.0

   Oracle Database 10g Patch 10.2.0.4.0

   Enterprise Manager plugin Common Files Patch 10.2.0.4.0

   SQL*Plus 10.2.0.4.0

   HAS Common Files Patch 10.2.0.4.0

   HAS Files for DB Patch 10.2.0.4.0

   Oracle Java Client Patch 10.2.0.4.0

   Oracle JVM Patch 10.2.0.4.0

   Oracle Internet Directory Client Patch 10.2.0.4.0

   iSQL*Plus 10.2.0.4.0

   Oracle Advanced Security Patch 10.2.0.4.0

   Oracle Net Patch 10.2.0.4.0

   Oracle Net Listener Patch 10.2.0.4.0

   Oracle Wallet Manager Patch 10.2.0.4.0

   Precompiler Common Files Patch 10.2.0.4.0

   Secure Socket Layer Patch 10.2.0.4.0

   Oracle ODBC Driver Patch 10.2.0.4.0

   Oracle OLAP Patch 10.2.0.4.0

   Oracle OLAP API Patch 10.2.0.4.0

   OLAP SQL Scripts Patch 10.2.0.4.0

   Oracle interMedia Client Option Patch 10.2.0.4.0

   Oracle Database 10g interMedia Files Patch 10.2.0.4.0

   Oracle interMedia Patch 10.2.0.4.0

   PL/SQL Embedded Gateway Patch 10.2.0.4.0

   Oracle XML Development Kit Patch 10.2.0.4.0

   Oracle Text Patch 10.2.0.4.0

   Oracle Clusterware RDBMS Files Patch 10.2.0.4.0

   Database SQL Scripts Patch 10.2.0.4.0

   Oracle Data Mining RDBMS Files Patch 10.2.0.4.0

   Generic Connectivity Common Files Patch 10.2.0.4.0

   Installation Common Files Patch 10.2.0.4.0

   Oracle Starter Database Patch 10.2.0.4.0

   Sample Schema Data Patch 10.2.0.4.0

   Oracle interMedia Locator RDBMS Files Patch 10.2.0.4.0

   Oracle Call Interface (OCI) Patch 10.2.0.4.0

   Oracle OLAP RDBMS Files Patch 10.2.0.4.0

   Oracle Partitioning Patch 10.2.0.4.0

   PL/SQL 10.2.0.4.0

   Oracle Recovery Manager Patch 10.2.0.4.0

   Oracle Database Utilities Patch 10.2.0.4.0

   Oracle interMedia Locator Patch 10.2.0.4.0

   XML Parser for Java Patch 10.2.0.4.0

   Assistant Common Files Patch 10.2.0.4.0

   Oracle JDBC Thin Driver for JDK 1.2 Patch 10.2.0.4.0

   Oracle JDBC Thin Driver for JDK 1.4 Patch 10.2.0.4.0

   Oracle interMedia Java Advanced Imaging Patch 10.2.0.4.0

   SQLJ Runtime Patch 10.2.0.4.0

   XML Parser for Oracle JVM Patch 10.2.0.4.0

   Enterprise Manager Agent DB 10.2.0.4.0

   Enterprise Manager Baseline 10.2.0.4.0

   Oracle Enterprise Manager Console DB 10.2.0.4.0

   XDK Required Support Files Patch 10.2.0.4.0

   Agent Required Support Files Patch 10.2.0.4.0

   DBJAVA Required Support Files Patch 10.2.0.4.0

   LDAP Required Support Files Patch 10.2.0.4.0

   Precompiler Required Support Files Patch 10.2.0.4.0

   Oracle RAC Required Support Files-HAS Patch 10.2.0.4.0

   RDBMS Required Support Files for Instant Client Patch 10.2.0.4.0

   RDBMS Required Support Files Patch 10.2.0.4.0

   SQL*Plus Required Support Files Patch 10.2.0.4.0

   SSL Required Support Files for InstantClient Patch 10.2.0.4.0

   Oracle Net Required Support Files Patch 10.2.0.4.0

   Oracle Globalization Support Patch 10.2.0.4.0

   Oracle Core Required Support Files Patch 10.2.0.4.0

   Platform Required Support Files 10.2.0.4.0

   Oracle Message Gateway Common Files Patch 10.2.0.4.0

   Enterprise Manager Agent Core Patch 10.2.0.4.0a

   Enterprise Manager Common Core Patch 10.2.0.4.0a

   Enterprise Manager Repository Core patch 10.2.0.4.0a

   Oracle Containers for Java 10.2.0.4.0

   Enterprise Manager Repository DB 10.2.0.4.0

   Oracle LDAP administration patch 10.2.0.4.0

   JDBC Common Files 10.2.0.4.0

   Database Workspace Manager 10.2.0.4.0

   Oracle Configuration Manager 10.2.7.1.0

   Oracle Real Application Testing 10.2.0.4.0

升级组件 (5 个产品)

   Oracle Universal Installer 10.2.0.4.0

   Oracle One-Off Patch Installer 10.2.0.4.0

   Installer SDK Component 10.2.0.4.0

   Java Runtime Environment 1.4.2.14.0

   Sun JDK 1.4.2.14.0

已安装 (78 个产品)

   Oracle Notification Service 10.1.0.3.0

   Database Configuration and Upgrade Assistants 10.2.0.1.0

   Character Set Migration Utility 10.2.0.1.0

   Oracle Database 10g 10.2.0.1.0

   Oracle JDBC/OCI Instant Client 10.2.0.1.0

   Oracle Database 10g 10.2.0.1.0

   Enterprise Manager plugin Common Files 10.2.0.1.0

   SQL*Plus 10.2.0.1.0

   HAS Common Files 10.2.0.1.0

   HAS Files for DB 10.2.0.1.0

   Oracle Java Client 10.2.0.1.0

   Oracle JVM 10.2.0.1.0

   Oracle Internet Directory Client 10.2.0.1.0

   iSQL*Plus 10.2.0.1.0

   Oracle Advanced Security 10.2.0.1.0

   Oracle Net 10.2.0.1.0

   Oracle Net Listener 10.2.0.1.0

   Oracle Wallet Manager 10.2.0.1.0

   Precompiler Common Files 10.2.0.1.0

   Secure Socket Layer 10.2.0.1.0

   Oracle ODBC Driver 10.2.0.1.0

   Oracle OLAP 10.2.0.1.0

   Oracle OLAP API 10.2.0.1.0

   OLAP SQL Scripts 10.2.0.1.0

   Oracle interMedia Client Option 10.2.0.1.0

   Oracle Database 10g interMedia Files 10.2.0.1.0

   Oracle interMedia 10.2.0.1.0

   PL/SQL Embedded Gateway 10.2.0.1.0

   Oracle XML Development Kit 10.2.0.1.0

   Oracle Text 10.2.0.1.0

   Oracle Clusterware RDBMS Files 10.2.0.1.0

   Database SQL Scripts 10.2.0.1.0

   Oracle Data Mining RDBMS Files 10.2.0.1.0

   Generic Connectivity Common Files 10.2.0.1.0

   Installation Common Files 10.2.0.1.0

   Oracle Starter Database 10.2.0.1.0

   Sample Schema Data 10.2.0.1.0

   Oracle interMedia Locator RDBMS Files 10.2.0.1.0

   Oracle Call Interface (OCI) 10.2.0.1.0

   Oracle OLAP RDBMS Files 10.2.0.1.0

   Oracle Partitioning 10.2.0.1.0

   PL/SQL 10.2.0.1.0

   Oracle Recovery Manager 10.2.0.1.0

   Oracle Database Utilities 10.2.0.1.0

   Oracle interMedia Locator 10.2.0.1.0

   XML Parser for Java 10.2.0.1.0

   Assistant Common Files 10.2.0.1.0

   Oracle JDBC Thin Driver for JDK 1.2 10.2.0.1.0

   Oracle JDBC Thin Driver for JDK 1.4 10.2.0.1.0

   Oracle interMedia Java Advanced Imaging 10.2.0.1.0

   SQLJ Runtime 10.2.0.1.0

   XML Parser for Oracle JVM 10.2.0.1.0

   Enterprise Manager Agent DB 10.2.0.1.0

   Enterprise Manager Baseline 10.2.0.1.0

   Oracle Enterprise Manager Console DB 10.2.0.1.0

   XDK Required Support Files 10.2.0.1.0

   Agent Required Support Files 10.2.0.1.0

   DBJAVA Required Support Files 10.2.0.1.0

   LDAP Required Support Files 10.2.0.1.0

   Precompiler Required Support Files 10.2.0.1.0

   Oracle RAC Required Support Files-HAS 10.2.0.1.0

   RDBMS Required Support Files for Instant Client 10.2.0.1.0

   RDBMS Required Support Files 10.2.0.1.0

   SQL*Plus Required Support Files 10.2.0.1.0

   SSL Required Support Files for InstantClient 10.2.0.1.0

   Oracle Net Required Support Files 10.2.0.1.0

   Oracle Globalization Support 10.2.0.1.0

   Oracle Core Required Support Files 10.2.0.1.0

   Platform Required Support Files 10.2.0.1.0

   Oracle Message Gateway Common Files 10.2.0.1.0

   Enterprise Manager Agent Core 10.2.0.1.0

   Enterprise Manager Common Files 10.2.0.1.0

   Enterprise Manager Repository Core 10.2.0.1.0

   Oracle Containers for Java 10.2.0.1.0

   Enterprise Manager Repository DB 10.2.0.1.0

   Oracle LDAP administration 10.2.0.1.0

   JDBC Common Files 10.2.0.1.0

   Database Workspace Manager 10.2.0.1.0

-----------------------------------------------------------------------------

正在进行卸装 (2012年10月29日星期一 上午10时42分48秒 CST)

...............................................................   0% 已完成。

...............................................................  18% 已完成。

...............................................................  37% 已完成。

...............................................................  56% 已完成。

...............................................................  75% 已完成。

.................                                               100% 已完成。

卸装成功

正在安装 (2012年10月29日星期一 上午10时42分48秒 CST)

...............................................................  18% 已完成。

...............................................................  37% 已完成。

...............................................................  56% 已完成。

...............................................................  75% 已完成。

.........................................                        88% 已完成。

安装成功

正在进行链接 (2012年10月29日星期一 上午10时43分32秒 CST)

..                                                               88% 已完成。

链接成功

正在进行设置 (2012年10月29日星期一 上午10时43分53秒 CST)

........                                                        100% 已完成。

设置成功

安装阶段结束。(2012年10月29日 星期一上午10时43分55秒 CST)

WARNING:

以下配置脚本需要以 "root" 用户的身份执行。

#!/bin/sh

#Root script to run

/opt/oracle/product/10.2.0/db_2/root.sh

要执行配置脚本, 请执行以下操作:

    1. 打开终端窗口

    2. 以 "root" 身份登录

    3. 运行脚本

Oracle Database 10g Release 2 Patch Set 3 的 安装 已成功。

请查看 '/opt/oraInventory/logs/silentInstall2012-10-29_10-42-39AM.log' 以获取详细资料。

 

c)root执行脚本root.sh

[root@dg-ss ~]# /opt/oracle/product/10.2.0/db_2/root.sh

Running Oracle10 root.sh script...

The following environment variables are set as:

    ORACLE_OWNER= ora

    ORACLE_HOME=  /opt/oracle/product/10.2.0/db_2

Enter the full pathname of the local bin directory: [/usr/local/bin]:

The file "dbhome" already exists in /usr/local/bin.  Overwrite it? (y/n)

[n]:

The file "oraenv" already exists in /usr/local/bin.  Overwrite it? (y/n)

[n]:

The file "coraenv" already exists in /usr/local/bin.  Overwrite it? (y/n)

[n]:

Entries will be added to the /etc/oratab file as needed by

Database Configuration Assistant when a database is created

Finished running generic part of root.sh script.

Now product-specific root actions will be performed.

 

5、检测升级的Opatch

[ora@dg-ss response]$ sqlplus /nolog

SQL*Plus: Release 10.2.0.4.0 - Production on Mon Oct 29 10:45:01 2012

Copyright (c) 1982, 2007, Oracle.  All Rights Reserved.

SQL> conn /as sysdba

Connected to an idle instance.

SQL> startup upgrade

ORACLE instance started.

Total System Global Area  457179136 bytes

Fixed Size                  1268052 bytes

Variable Size             142608044 bytes

Database Buffers          310378496 bytes

Redo Buffers                2924544 bytes

Database mounted.

Database opened.

SQL> spool upgrade_info.log

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

Oracle Database 10.2 Upgrade Information Utility    10-29-2012 10:45:17

**********************************************************************

Database:

**********************************************************************

--> name:       TEST

--> version:    10.2.0.1.0

--> compatible: 10.2.0.1.0

--> blocksize:  8192

**********************************************************************

Tablespaces: [make adjustments in the current environment]

**********************************************************************

--> SYSTEM tablespace is adequate for the upgrade.

.... minimum required size: 487 MB

.... AUTOEXTEND additional space required: 7 MB

--> UNDOTBS1 tablespace is adequate for the upgrade.

.... minimum required size: 400 MB

.... AUTOEXTEND additional space required: 375 MB

--> SYSAUX tablespace is adequate for the upgrade.

.... minimum required size: 250 MB

.... AUTOEXTEND additional space required: 10 MB

--> TEMP tablespace is adequate for the upgrade.

.... minimum required size: 58 MB

.... AUTOEXTEND additional space required: 38 MB

**********************************************************************

Update Parameters: [Update Oracle Database 10.2 init.ora or spfile]

**********************************************************************

-- No update parameter changes are required.

**********************************************************************

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]

**********************************************************************

-- No obsolete parameters found. No changes are required

**********************************************************************

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 Java Packages         [upgrade]  VALID

--> Oracle Text                  [upgrade]  VALID

--> Oracle XML Database          [upgrade]  VALID

--> Oracle Workspace Manager     [upgrade]  VALID

--> Oracle Data Mining           [upgrade]  VALID

--> OLAP Analytic Workspace      [upgrade]  VALID

--> OLAP Catalog                 [upgrade]  VALID

--> Oracle OLAP API              [upgrade]  VALID

--> Oracle interMedia            [upgrade]  VALID

--> Spatial                      [upgrade]  VALID

--> Expression Filter            [upgrade]  VALID

--> EM Repository                [upgrade]  VALID

--> Rule Manager                 [upgrade]  VALID

.

**********************************************************************

Miscellaneous Warnings

**********************************************************************

WARNING: --> Database contains INVALID objects prior to upgrade.

.... USER DMSYS has 1 INVALID objects.

.... USER PUBLIC has 44 INVALID objects.

.... USER CTXSYS has 1 INVALID objects.

.... USER EXFSYS has 12 INVALID objects.

.... USER SYS has 138 INVALID objects.

PL/SQL procedure successfully completed.

SQL> spool off

 

6、升级数据库

a)开启监听

lsnrctl start

[ora@dg-ss response]$ lsnrctl start

LSNRCTL for Linux: Version 10.2.0.4.0 - Production on 29-OCT-2012 10:45:34

Copyright (c) 1991, 2007, Oracle.  All rights reserved.

Starting /opt/oracle/product/10.2.0/db_2/bin/tnslsnr: please wait...

TNSLSNR for Linux: Version 10.2.0.4.0 - Production

System parameter file is /opt/oracle/product/10.2.0/db_2/network/admin/listener.ora

Log messages written to /opt/oracle/product/10.2.0/db_2/network/log/listener.log

Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=dg-ss)(PORT=1521)))

Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC0)))

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=dg-ss)(PORT=1521)))

STATUS of the LISTENER

------------------------

Alias                     LISTENER

Version                   TNSLSNR for Linux: Version 10.2.0.4.0 - Production

Start Date                29-OCT-2012 10:45:34

Uptime                    0 days 0 hr. 0 min. 0 sec

Trace Level               off

Security                  ON: Local OS Authentication

SNMP                      OFF

Listener Parameter File   /opt/oracle/product/10.2.0/db_2/network/admin/listener.ora

Listener Log File         /opt/oracle/product/10.2.0/db_2/network/log/listener.log

Listening Endpoints Summary...

  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=dg-ss)(PORT=1521)))

  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC0)))

Services Summary...

Service "PLSExtProc" has 1 instance(s).

  Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...

The command completed successfully

b)升级数据字典

[ora@dg-ss response]$ sqlplus /nolog

SQL*Plus: Release 10.2.0.4.0 - Production on Mon Oct 29 10:45:46 2012

Copyright (c) 1982, 2007, Oracle.  All Rights Reserved.

SQL> conn /as sysdba

SQL> startup upgrade

ORACLE instance started.

Total System Global Area  457179136 bytes

Fixed Size                  1268052 bytes

Variable Size             142608044 bytes

Database Buffers          310378496 bytes

Redo Buffers                2924544 bytes

Database mounted.

Database opened.

SQL> spool patch.log

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

。。。。。。。此处省略

Oracle Database 10.2 Upgrade Status Utility           10-29-2012 10:57:40

.

Component                                Status         Version  HH:MM:SS

Oracle Database Server                    VALID      10.2.0.4.0  00:04:31

JServer JAVA Virtual Machine              VALID      10.2.0.4.0  00:00:47

Oracle XDK                                VALID      10.2.0.4.0  00:00:15

Oracle Database Java Packages             VALID      10.2.0.4.0  00:00:08

Oracle Text                               VALID      10.2.0.4.0  00:00:10

Oracle XML Database                       VALID      10.2.0.4.0  00:00:35

Oracle Workspace Manager                  VALID      10.2.0.4.3  00:00:16

Oracle Data Mining                        VALID      10.2.0.4.0  00:00:09

OLAP Analytic Workspace                   VALID      10.2.0.4.0  00:00:08

OLAP Catalog                              VALID      10.2.0.4.0  00:00:25

Oracle OLAP API                           VALID      10.2.0.4.0  00:00:20

Oracle interMedia                         VALID      10.2.0.4.0  00:02:01

Spatial                                   VALID      10.2.0.4.0  00:00:42

Oracle Expression Filter                  VALID      10.2.0.4.0  00:00:05

Oracle Enterprise Manager                 VALID      10.2.0.4.0  00:00:45

Oracle Rule Manager                       VALID      10.2.0.4.0  00:00:03

.

Total Upgrade Time: 00:11:28

DOC>#######################################################################

DOC>#######################################################################

DOC>

DOC>   The above PL/SQL lists the SERVER components in the upgraded

DOC>   database, along with their current version and status.

DOC>

DOC>   Please review the status and version columns and look for

DOC>   any errors in the spool log file.  If there are errors in the spool

DOC>   file, or any components are not VALID or not the current version,

DOC>   consult the Oracle Database Upgrade Guide for troubleshooting

DOC>   recommendations.

DOC>

DOC>   Next shutdown immediate, restart for normal operation, and then

DOC>   run utlrp.sql to recompile any invalid application objects.

DOC>

DOC>#######################################################################

DOC>#######################################################################

SQL>spool off

 

7、升级结果检验

SQL> shutdown immediate;

Database closed.

Database dismounted.

ORACLE instance shut down.

SQL> startup

ORACLE instance started.

Total System Global Area  457179136 bytes

Fixed Size                  1268052 bytes

Variable Size             176162476 bytes

Database Buffers          276824064 bytes

Redo Buffers                2924544 bytes

Database mounted.

Database opened.

SQL> select comp_name, version, status from sys.dba_registry;

COMP_NAME                                VERSION    STATUS

---------------------------------------- ---------- ----------

Oracle Database Catalog Views            10.2.0.4.0 VALID

Oracle Database Packages and Types       10.2.0.4.0 VALID

Oracle Workspace Manager                 10.2.0.4.3 VALID

JServer JAVA Virtual Machine             10.2.0.4.0 VALID

Oracle XDK                               10.2.0.4.0 VALID

Oracle Database Java Packages            10.2.0.4.0 VALID

Oracle Expression Filter                 10.2.0.4.0 VALID

Oracle Data Mining                       10.2.0.4.0 VALID

Oracle Text                              10.2.0.4.0 VALID

Oracle XML Database                      10.2.0.4.0 VALID

Oracle Rule Manager                      10.2.0.4.0 VALID

Oracle interMedia                        10.2.0.4.0 VALID

OLAP Analytic Workspace                  10.2.0.4.0 VALID

Oracle OLAP API                          10.2.0.4.0 VALID

OLAP Catalog                             10.2.0.4.0 VALID

Spatial                                  10.2.0.4.0 VALID

Oracle Enterprise Manager                10.2.0.4.0 VALID

 

8、升级EM

[ora@dg-ss response]$ emca -upgrade db

 

OK 升级成功！！！