oracle组件升级,Oracle教程——9.2.0.4 升级到10.2.0.5升级后 Oracle Ultra Search 组件NO&n...

9.2.0.4 升级到10.2.0.5

升级后Oracle Ultra Search

组件NO

SCRIPT 客户 有个库需要从9.2.0.4 升级到10.2.0.5 ，再执行catupgrd.sql 后有个显示：

Oracle Database 10.2 Upgrade Status

Utility 11-22-2013 14:18:11

.

Component Status Version HH:MM:SS

Oracle Database

Server INVALID 10.2.0.4.0 00:06:55

JServer JAVA Virtual

Machine VALID 10.2.0.4.0 00:03:22

Oracle

XDK VALID 10.2.0.4.0 00:01:08

Oracle Database Java

Packages VALID 10.2.0.4.0 00:00:09

Oracle

Text VALID 10.2.0.4.0 00:00:28

Oracle XML

Database VALID 10.2.0.4.0 00:00:57

Oracle Workspace

Manager VALID 10.2.0.4.3 00:00:36

Oracle Data

Mining VALID 10.2.0.4.0 00:00:12

Oracle

interMedia VALID 10.2.0.4.0 00:03:49

Spatial VALID 10.2.0.4.0 00:03:28

Oracle Ultra

Search NO

SCRIPT 9.2.0.4.0 00:00:00

.

Total Upgrade Time: 00:21:10

Alert.log 里有显示。

SERVER COMPONENT id=SDO: status=VALID,

version=10.2.0.4.0, timestamp=2014-04-03 11:23:32

SERVER COMPONENT id=WK: Upgrade skipped - script

?/ultrasearch/admin/wkdbmig.sql not found

SERVER COMPONENT id=WK: status=NO SCRIPT,

version=9.2.0.4.0, timestamp=2014-04-03 11:23:32

参考Status Of 'Oracle Ultra

Search' is 'No Script' After Upgrading to 10.2 (Doc ID

375620.1)

1. Check whether Oracle Ultra

Search has been installed:

invoke runinstaller and then click on the

Installed Products button.

$ opatch lsinventory -detail

2. Install the Oracle Ultra

Search option from the companion directory located on the 10.2.0

Oracle Data Server DVD or download it from OTN or

edelivery.oracle.com

Run the Universal Installer:

$ /runInstaller

When the "Select a Product to Install" screen appears, select

"Oracle Database 10g Products 10.2.0.1.0". This

will install several components: jdbc drivers, SQLJ, Database

examples, Oracle Text Knowledge, NCOMP, Intermedia Image

Accelerator,

Ultrasearch and Workflow.

Note: it is not possible to install only Oracle

Ultra Search component.

3. Reapply the patchset if you already applied one

4. Rerun the catupgrd.sql script.

You can ignore the errors errors regarding the unique constraints

violation which occur because

catupgrd.sql was run twice

Then Ultrasearch should be upgraded and status will be VALID.

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

原因为这个组件在10g安装包里面没有，需要额外安装companion包，ID

375620.1有说明

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

…The ‘JServer JAVA Virtual Machine’ JAccelerator (NCOMP)

…is required to be installed from the 10g Companion CD.

–> 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] LOADED

–> OLAP

Catalog [upgrade] VALID

–> Oracle OLAP

API [upgrade] LOADED

–> Oracle

interMedia [upgrade] VALID

…The ‘Oracle interMedia Image Accelerator’ is

…required to be installed from the 10g Companion CD.

–>

Spatial [upgrade] VALID

–> Oracle Ultra

Search [upgrade] VALID

… To successfully upgrade Ultra Search, install it from

… the 10g Companion CD.

在升级前，运行升级预检脚本utlu102i.sql时，已经有提示

Companion 包只有10.2.0.1介质，在已经升级到10.2.0.5之后，安装过程如下：

1.runInstaller调出oui，选择升级完成后的oracle_home

2.选择10.2.0.1的数据库组件

3.安装完后，再打10.2.0.5patch

4.完成后应用其他补丁

5.startup upgrade

@?/rdbms/admin/catupgrd.sql

6.

Oracle Database 10.2 Upgrade Status

Utility .

Component Status Version HH:MM:SS

Oracle Database

Server VALID 10.2.0.5.0 00:08:18

JServer JAVA Virtual

Machine VALID 10.2.0.5.0 00:00:00

Oracle

XDK VALID 10.2.0.5.0 00:00:00

Oracle Database Java

Packages VALID 10.2.0.5.0 00:00:00

Oracle

Text VALID 10.2.0.5.0 00:00:00

Oracle XML

Database VALID 10.2.0.5.0 00:00:00

Oracle Workspace

Manager VALID 10.2.0.5.0 00:00:00

Oracle Data

Mining