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                        VALID      10.2.0.5.0  00:00:00 
OLAP Analytic Workspace                   VALID      10.2.0.5.0  00:00:00 
OLAP Catalog                              VALID      10.2.0.5.0  00:00:00 
Oracle OLAP API                           VALID      10.2.0.5.0  00:00:00 
Oracle interMedia                         VALID      10.2.0.5.0  00:00:00 
Spatial                                   VALID      10.2.0.5.0  00:00:00 
Oracle Ultra Search                       VALID      10.2.0.5.0  00:00:34 
. 
Total Upgrade Time: 00:09:31

PL/SQL procedure successfully completed.

正常。