Wednesday, April 6, 2011

Install Oracle Text on Oracle Database 11gR2

We have prepared below steps to install Oracle Text on our Oracle Database 11gR2.
For details please follow MOS Note:ID 970473.1

1. Install Oracle Text

SQL> connect SYS/password as SYSDBA
SQL> spool text_install.txt
SQL> @?/ctx/admin/catctx.sql welcome SYSAUX TEMP NOLOCK

2. install language

SQL> connect CTXSYS/welcome
SQL> @?/ctx/admin/defaults/dr0defin.sql "AMERICAN";
SQL> connect SYS/password as SYSDBA
SQL> alter user ctxsys account lock password expire;
SQL> spool off

3. verify

SQL> select comp_name, status, substr(version,1,10) as version from dba_registry where comp_id = 'CONTEXT';

COMP_NAME STATUS VERSION
------------------- -------- ----------
Oracle Text VALID 11.2.0.1.0

SQL> select * from ctxsys.ctx_version;

VER_DICT VER_CODE
---------- ----------
11.2.0.1.0 11.2.0.1.0

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

VER_CODE
----------
11.2.0.1.0

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

COUNT(*)
----------
366

- Get a summary count

SQL> select object_type, count(*) from dba_objects where owner='CTXSYS' group by object_type;

OBJECT_TYPE COUNT(*)
------------------- ----------
SEQUENCE 3
PROCEDURE 2
OPERATOR 6
PACKAGE 73
PACKAGE BODY 62
LIBRARY 1
LOB 2
TYPE BODY 6
VIEW 71
INDEXTYPE 4
FUNCTION 2
TABLE 47
INDEX 56
TYPE 31


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

no rows selected

16 comments:

  1. This worked really well for us! Thanks for the detailed instructions.

    ReplyDelete
  2. It's works! Many thanks...

    ReplyDelete
  3. This was very fast and worked well - thank you so much!

    ReplyDelete
  4. Small remark. (in my case its Ora 11gr2)

    In case of hardened instsallations you need to:

    GRANT EXECUTE ON DBMS_LOB TO PUBLIC;

    Before you go for dr0defin.sql.

    And in my case I had some strange issues with having some default preferences missing, for dr0defin.sql.
    Running @?/ctx/admin/ctxdef.sql before dr0defin.sql did the trick.

    Hope this helps someone.

    Cheers,
    vik

    ReplyDelete
  5. Great instructions, worked perfectly! cjp

    ReplyDelete
  6. Works just great. Many thanks!

    ReplyDelete
  7. Hi In my case the DR$INDEX_ERROR table is grown to 32 GB. Can I do something about this? Thanks in advance

    ReplyDelete
  8. Hi Sushant,
    I didn't face that issue.
    I did a simple googling and found something similar like you; you can check below link, it may help you:
    https://groups.google.com/forum/#!topic/comp.databases.oracle.server/i6SCSXhIca0

    ReplyDelete
  9. Simple and perfect article.
    Very helpful.

    ReplyDelete
  10. Hi,
    I am getting some error
    ERROR at line 1:
    ORA-39705: component 'CONTEXT' not found in registry
    ORA-06512: at "SYS.DBMS_SYS_ERROR", line 86
    ORA-06512: at "SYS.DBMS_REGISTRY", line 563
    ORA-06512: at line 1


    BEGIN sys.validate_context; END;

    *
    ERROR at line 1:
    ORA-06550: line 1, column 11:
    PLS-00905: object SYS.VALIDATE_CONTEXT is invalid
    ORA-06550: line 1, column 7:
    PL/SQL: Statement ignored

    any idea on the same?

    Thanks,
    Debaditya

    ReplyDelete
  11. MuchĂ­simas gracias, me fue muy Ăștil!!!

    ReplyDelete
  12. Really well explained - wonderful.

    ReplyDelete
  13. Thanks a lot guys!! Your extremely valid support helped me to get out of slime with a Client!!
    Have the best! good luck.

    ReplyDelete