Hi,
I have the following situation

Oracle Database 10.2 Upgrade Status Utility 02-11-2007 09:54:05
..
Component Status Version HH:MM:SS
Oracle Database Server VALID 10.2.0.3.0 00:16:47
JServer JAVA Virtual Machine VALID 10.2.0.3.0 00:04:21
Oracle XDK VALID 10.2.0.3.0 00:00:26
Oracle Database Java Packages VALID 10.2.0.3.0 00:00:37
Oracle Text VALID 10.2.0.3.0 00:00:20
Oracle XML Database VALID 10.2.0.3.0 00:01:55
Oracle Data Mining VALID 10.2.0.3.0 00:00:31
OLAP Analytic Workspace VALID 10.2.0.3.0 00:00:39
OLAP Catalog VALID 10.2.0.3.0 00:01:03
Oracle OLAP API VALID 10.2.0.3.0 00:01:01
Oracle interMedia VALID 10.2.0.3.0 00:06:00
Spatial VALID 10.2.0.3.0 00:00:54
Oracle Ultra Search INVALID 9.2.0.6.0 00:00:00
Oracle Enterprise Manager VALID 10.2.0.3.0 00:01:21



the ultrasearch is sitting at 9.2 in my 10.2 database. I need to totally
remove ultrasearch and reinstall it.

Which scripts do i need to execute to do this.


Steve

steve wrote:
> Hi,
> I have the following situation
>
> Oracle Database 10.2 Upgrade Status Utility 02-11-2007 09:54:05
> .
> Component Status Version HH:MM:SS
> Oracle Database Server VALID 10.2.0.3.0 00:16:47
> JServer JAVA Virtual Machine VALID 10.2.0.3.0 00:04:21
> Oracle XDK VALID 10.2.0.3.0 00:00:26
> Oracle Database Java Packages VALID 10.2.0.3.0 00:00:37
> Oracle Text VALID 10.2.0.3.0 00:00:20
> Oracle XML Database VALID 10.2.0.3.0 00:01:55
> Oracle Data Mining VALID 10.2.0.3.0 00:00:31
> OLAP Analytic Workspace VALID 10.2.0.3.0 00:00:39
> OLAP Catalog VALID 10.2.0.3.0 00:01:03
> Oracle OLAP API VALID 10.2.0.3.0 00:01:01
> Oracle interMedia VALID 10.2.0.3.0 00:06:00
> Spatial VALID 10.2.0.3.0 00:00:54
> Oracle Ultra Search INVALID 9.2.0.6.0 00:00:00
> Oracle Enterprise Manager VALID 10.2.0.3.0 00:01:21
>
>
>
> the ultrasearch is sitting at 9.2 in my 10.2 database. I need to totally
> remove ultrasearch and reinstall it.
>
> Which scripts do i need to execute to do this.
>
>
> Steve

You should verify with metalink but I'd look at these four scripts for
more information.

$ORACLE_HOME/rdbms/admin/c1002000.sql
$ORACLE_HOME/rdbms/admin/cmpdbmig.sql
$ORACLE_HOME/rdbms/admin/utlu102i.sql
$ORACLE_HOME/rdbms/admin/utlu102x.sql

Likely it is the second one but validate and test first.
--
Daniel A. Morgan
University of Washington
damorgan@x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org

On Mon, 12 Feb 2007 02:06:31 +0800, DA Morgan wrote
(in article <1171217190.547678@bubbleator.drizzle.com>):

> steve wrote:
>> Hi,
>> I have the following situation
>>
>> Oracle Database 10.2 Upgrade Status Utility 02-11-2007 09:54:05
>> .
>> Component Status Version HH:MM:SS
>> Oracle Database Server VALID 10.2.0.3.0 00:16:47
>> JServer JAVA Virtual Machine VALID 10.2.0.3.0 00:04:21
>> Oracle XDK VALID 10.2.0.3.0 00:00:26
>> Oracle Database Java Packages VALID 10.2.0.3.0 00:00:37
>> Oracle Text VALID 10.2.0.3.0 00:00:20
>> Oracle XML Database VALID 10.2.0.3.0 00:01:55
>> Oracle Data Mining VALID 10.2.0.3.0 00:00:31
>> OLAP Analytic Workspace VALID 10.2.0.3.0 00:00:39
>> OLAP Catalog VALID 10.2.0.3.0 00:01:03
>> Oracle OLAP API VALID 10.2.0.3.0 00:01:01
>> Oracle interMedia VALID 10.2.0.3.0 00:06:00
>> Spatial VALID 10.2.0.3.0 00:00:54
>> Oracle Ultra Search INVALID 9.2.0.6.0 00:00:00
>> Oracle Enterprise Manager VALID 10.2.0.3.0 00:01:21
>>
>>
>>
>> the ultrasearch is sitting at 9.2 in my 10.2 database. I need to totally
>> remove ultrasearch and reinstall it.
>>
>> Which scripts do i need to execute to do this.
>>
>>
>> Steve
>
> You should verify with metalink but I'd look at these four scripts for
> more information.
>
> $ORACLE_HOME/rdbms/admin/c1002000.sql
> $ORACLE_HOME/rdbms/admin/cmpdbmig.sql
> $ORACLE_HOME/rdbms/admin/utlu102i.sql
> $ORACLE_HOME/rdbms/admin/utlu102x.sql
>
> Likely it is the second one but validate and test first.
>


thanks DA, I spent rather a long time ploughing thru the 10g documentation,
skipping from one place to another all without sucess.