Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Error In Installing Oracle Text

B DaveMar 7 2012 — edited Mar 13 2012

Hi All.

I tried to install Oracle TEXT from sys using catctx.sql file

SQL> @$ORACLE_HOME/ctx/admin/catctx.sql CTXSYS SYSAUX TEMP NOLOCK

SQL> connect CTXSYS/password
SQL> @$ORACLE_HOME/ctx/admin/defaults/drdefus.sql

but I've got error like

select object_name, object_type, status from dba_objects where owner='CTXSYS' and status != 'VALID' order by object_name;

and output is

OBJECT_NAME	OBJECT_TYPE	STATUS
DRVODM	PACKAGE BODY	INVALID

and output of following query is
select comp_name, status, substr(version,1,10) as version from dba_registry where comp_id = 'CONTEXT';

COMP_NAME	STATUS	VERSION
Oracle Text	INVALID	10.1.0.4.0

I've spooled output of installation.

Let me know what I'm missing in this installation?

Thanks for help.
Regards,
dave.

This post has been answered by Barbara Boehmer on Mar 12 2012

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 10 2012

Added on Mar 7 2012

#database-key-features, #installation, #oracle, #text

9 comments

1,540 views