Friday, September 9, 2011

How to install oracle text

SQL> @?/ctx/admin/catctx.sql oracle SYSAUX TEMP NOLOCK


sql> connect CTXSYS/oracle


SQL> @?/ctx/admin/defaults/dr0defin.sql "AMERICAN";

SQL> connect /as sysdba

SQL> alter user ctxsys account lock password expire;


SQL> select comp_name,version,status from dba_registry;

COMP_NAME VERSION STATUS
------------------------------------------------------------ ------------------------------ -----------
Oracle Text 10.2.0.5.0 VALID
Oracle XML Database 10.2.0.5.0 VALID
Oracle Enterprise Manager 10.2.0.5.0 VALID
Oracle Database Catalog Views 10.2.0.5.0 VALID
Oracle Database Packages and Types 10.2.0.5.0 VALID

SQL> select * from ctxsys.ctx_version;

VER_DICT VER_CODE
---------- ----------
10.2.0.5.0 10.2.0.5.0


SQL> select substr(ctxsys.dri_version,1,10) VER_CODE from dual;

VER_CODE
----------
10.2.0.5.0

SQL> select count(*) from dba_objects where owner='CTXSYS';

COUNT(*)
----------
339

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

no rows selected

No comments: