Oracle 10g 安装Ultra Search

windows server 2003 32位 9.2.0.6升级到windows server 2003 64位 10.2.0.4之后，查看数据库中各组件状态显示如下，可以看到Oracle Ultra Search处于NO SCRIPT状态。
[quote]Oracle Database 10.2 Upgrade Status Utility 05-06-2010 12:30:59
.
Component Status Version HH:MM:SS
Oracle Database Server VALID 10.2.0.4.0 00:11:13
JServer JAVA Virtual Machine VALID 10.2.0.4.0 00:07:49
Oracle XDK VALID 10.2.0.4.0 00:01:15
Oracle Database Java Packages VALID 10.2.0.4.0 00:00:30
Oracle Text VALID 10.2.0.4.0 00:00:52
Oracle XML Database VALID 10.2.0.4.0 00:02:55
Oracle Workspace Manager VALID 10.2.0.4.3 00:01:02
Oracle Data Mining VALID 10.2.0.4.0 00:00:19
OLAP Analytic Workspace VALID 10.2.0.4.0 00:00:18
OLAP Catalog VALID 10.2.0.4.0 00:00:56
Oracle OLAP API VALID 10.2.0.4.0 00:00:29
Oracle interMedia VALID 10.2.0.4.0 00:04:14
Spatial VALID 10.2.0.4.0 00:04:20
[color=red]Oracle Ultra Search NO SCRIPT [/color] 9.2.0.6.0 00:00:00[/quote]


进一步查看其他数据库，这里我们选择企业版，首次安装即为10g的数据库，可以看到Oracle Ultra Search并没有出现在企业版的组件中。
[quote]
[ora10g@mcprod ~]$ sqlplus "/as sysdba"

SQL*Plus: Release 10.2.0.3.0 - Production on Fri May 7 09:02:34 2010

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


Connected to:
Oracle Database 10g [color=red]Enterprise Edition Release[/color] 10.2.0.3.0 - Production
With the Partitioning, OLAP and Data Mining options

Oracle interMedia 10.2.0.3.0 VALID
Oracle XML Database 10.2.0.3.0 VALID
Oracle Expression Filter 10.2.0.3.0 VALID
Oracle Rules Manager 10.2.0.3.0 VALID
Oracle Workspace Manager 10.2.0.1.0 VALID
Oracle Database Catalog Views 10.2.0.3.0 VALID
Oracle Database Packages and Types 10.2.0.3.0 VALID
JServer JAVA Virtual Machine 10.2.0.3.0 VALID
Oracle XDK 10.2.0.3.0 VALID
Oracle Database Java Packages 10.2.0.3.0 VALID
Oracle Real Application Clusters 10.2.0.3.0 INVALID[/quote]


进一步查看Oracle 9i企业版组件，组件Oracle Ultra Search在其中
[quote][oracle@mcprod ~]$ sqlplus "/as sysdba"

SQL*Plus: Release 9.2.0.4.0 - Production on Fri May 7 08:59:31 2010

Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.


Connected to:
Oracle9i Enterprise Edition Release 9.2.0.4.0 - Production
With the Partitioning and Oracle Data Mining options
JServer Release 9.2.0.4.0 - Production

Oracle9i Catalog Views 9.2.0.4.0 VALID
Oracle9i Packages and Types 9.2.0.4.0 VALID
Oracle Workspace Manager 9.2.0.1.0 VALID
JServer JAVA Virtual Machine 9.2.0.4.0 VALID
Oracle XDK for Java 9.2.0.6.0 VALID
Oracle9i Java Packages 9.2.0.4.0 VALID
Oracle interMedia 9.2.0.4.0 VALID
Spatial 9.2.0.4.0 LOADED
Oracle Text 9.2.0.4.0 VALID
Oracle XML Database 9.2.0.4.0 VALID
[color=red]Oracle Ultra Search 9.2.0.4.0 VALID[/color]
Oracle Data Mining 9.2.0.1.0 LOADED
OLAP Analytic Workspace 9.2.0.4.0 LOADED
Oracle OLAP API 9.2.0.4.0 LOADED
OLAP Catalog 9.2.0.4.0 VALID[/quote]
莫非Oracle 10g将组件Ultra Search从企业版剥离出来了？因为从理论上来讲，兼容性考虑，Oracle 10g不可能不兼容Ultra Search。进而查看metalink，在375620.1中我们看到一句话
[quote]After upgrading database from 9.2.0.x or 10.1.0.x to 10.2.0.x the upgrade was successful but the upgrade log file is reporting a problem with the Oracle Ultra Search component.
...
Oracle Ultra Search ( ultrasearch ) was not installed in previous release and/or component has not been installed at all with the 10.2.0.1.0 version or with later 10.2 patchset installations, e.g. 10.2.0.2.0, 10.2.0.3.0.
...
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[/quote]

于是从网上下载Oracle Database 10g Companion CD Release 2
http://www.oracle.com/technology/software/products/database/oracle10g/htdocs/10201winsoft.html

可以看到Oracle Database 10g Companion包含以下内容
[quote]Oracle Database 10g Companion CD Introduction
The Oracle Database 10g Companion CD provides software that you can install to extend and enhance your Oracle Database installation. It provides the following installation types:

Oracle Database 10g Products: Includes Oracle Database Examples, natively compiled Java libraries for Oracle JVM and Oracle interMedia, and knowledge bases for Oracle Text.

Oracle Database 10g Companion Products: Includes Oracle HTTP Server, Oracle Workflow, and Oracle HTML DB.[/quote]
截屏显示如下

[img]http://dl.iteye.com/upload/attachment/245541/4ee9fb68-6205-3d0e-b516-2730bf8b8469.jpg[/img]

关闭数据库和相关服务，安装Oracle Database 10g Companion，注意选择Oracle Home目录

[quote]正在检查 Oracle 主目录的不兼容性...
检查完成。此次检查的总体结果为: 失败 <<<<
问题: Oracle 10g Database Companion CD 产品只能安装到现有的 Oracle Database 10g Oracle 主目录中。
建议案: 请选择一个现有的 Oracle Database 10g Oracle 主目录, 以安装本软件。
=======================================================================[/quote]
因为之前数据库已经升级至10.2.0.4，安装好Oracle Database 10g Companion之后仍需用p6810189_10204_MSWIN-x86-64.zip再次升级Oracle 软件。
软件升级完成之后，执行catupgrd.sql
[quote]SQL> @catupgrd.sql[/quote]

数据字典刷新之后显示，可以看到Oracle Ultra Search 已经安装成功
[quote]Oracle Database 10.2 Upgrade Status Utility 05-07-2010 10:08:52
.
Component Status Version HH:MM:SS
Oracle Database Server VALID 10.2.0.4.0 00:11:05
JServer JAVA Virtual Machine VALID 10.2.0.4.0 00:07:27
Oracle XDK VALID 10.2.0.4.0 00:01:06
Oracle Database Java Packages VALID 10.2.0.4.0 00:00:31
Oracle Text VALID 10.2.0.4.0 00:01:08
Oracle XML Database VALID 10.2.0.4.0 00:03:03
Oracle Workspace Manager VALID 10.2.0.4.3 00:01:02
Oracle Data Mining VALID 10.2.0.4.0 00:00:20
OLAP Analytic Workspace VALID 10.2.0.4.0 00:00:22
OLAP Catalog VALID 10.2.0.4.0 00:00:58
Oracle OLAP API VALID 10.2.0.4.0 00:00:30
Oracle interMedia VALID 10.2.0.4.0 00:04:12
Spatial VALID 10.2.0.4.0 00:03:53
[color=red]Oracle Ultra Search VALID 10.2.0.4.0 00:00:48[/color]
.[/quote]