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]

[[email protected] ~]$ 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][[email protected] ~]$ 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]