11g安装oracle text组件

<span style="font-family: Arial, Helvetica, sans-serif; background-color: rgb(255, 255, 255);">因项目需要，所以要在原本只安装jvm组件的oracle数据库，添加组件xml db和oracle text！</span>

xml db的安装请参考http://blog.csdn.net/xionglang7/article/details/38034555

dbca创建是默认会创建这两个组件的。

设置环境变量

Platform:             Requires path set:    ENV variable:
--------------------- --------------------- -------------------
Linux x86-64          YES                   LD_LIBRARY_PATH
Solaris SPARC64       YES                   LD_LIBRARY_PATH
IBM AIX               YES                   LIBPATH
HP PA-RISC            YES                   SHLIB_PATH
HP Itanium            YES                   LD_LIBRARY_PATH

例如：

- If you have the C Shell (csh or tcsh), enter the following:
   $ setenv LD_LIBRARY_PATH $ORACLE_HOME/ctx/lib:$LD_LIBRARY_PATH

- If you have the Bourne shell (sh), Bash shell (bash), or Korn shell (ksh), enter the following:
   $ export LD_LIBRARY_PATH=$ORACLE_HOME/ctx/lib:$LD_LIBRARY_PATH

1，创建数据字典，用户等

SQL> connect SYS/password as SYSDBASQL> spool text_install.txtSQL> @?/ctx/admin/catctx.sql change_on_install SYSAUX TEMP NOLOCK

change_on_install - is the ctxsys user password
SYSAUX - is the default tablespace for ctxsys
TEMP - is the temporary tablespace for ctxsys
LOCK|NOLOCK - ctxsys user account will be locked or no

2，创建支持的语言特性，一般都选择英文

There is script which creates language-specific default preferences for every language Oracle Text supports in $O_H/ctx/admin/defaults directory, such as English(US), Danish(DK), Dutch(NL), Finnish(SF), French(F), German(D), Italian(IT), Portuguese(PT), Spanish(E), and Swedish(S). They are named in the form drdefXX.sql, where XX is the international license plate code.

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

3，对安装组件进行检查

各个版本显示结果不同

11.2.0.1显示结果：

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.0SQL> select * from ctxsys.ctx_version;VER_DICT   VER_CODE---------- ----------11.2.0.1.0 11.2.0.1.0SQL> select substr(ctxsys.dri_version,1,10) VER_CODE from dual;VER_CODE ----------11.2.0.1.0SQL> select count(*) from dba_objects where owner='CTXSYS';  COUNT(*)----------       366SQL> SQL> -- Get a summary countSQL> select object_type, count(*) from dba_objects where owner='CTXSYS' group by object_type;OBJECT_TYPE           COUNT(*)------------------- ----------SEQUENCE                     3PROCEDURE                    2OPERATOR                     6PACKAGE                     73PACKAGE BODY                62LIBRARY                      1LOB                          2TYPE BODY                    6VIEW                        71INDEXTYPE                    4FUNCTION                     2TABLE                       47INDEX                       56TYPE                        31SQL> SQL> -- Any invalid objectsSQL> select object_name, object_type, status from dba_objects where owner='CTXSYS' and status != 'VALID' order by object_name;no rows selectedSQL>

11.2.0.2显示结果

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.2.0SQL> select * from ctxsys.ctx_version;VER_DICT   VER_CODE---------- ----------11.2.0.2.0 11.2.0.2.0SQL> select substr(ctxsys.dri_version,1,10) VER_CODE from dual;  VER_CODE----------11.2.0.2.0SQL> select count(*) from dba_objects where owner='CTXSYS';  COUNT(*)----------       382SQL>SQL> -- Get a summary countSQL> select object_type, count(*) from dba_objects where owner='CTXSYS' group by object_type;OBJECT_TYPE           COUNT(*)------------------- ----------SEQUENCE                     3PROCEDURE                    2OPERATOR                     6LOB                          2LIBRARY                      1PACKAGE                     74PACKAGE BODY                63TYPE BODY                    6TABLE                       49INDEX                       59VIEW                        76FUNCTION                     2INDEXTYPE                    4TYPE                        35SQL>SQL> -- Any invalid objectsSQL> select object_name, object_type, status from dba_objects where owner='CTXSYS' and status != 'VALID' order by object_name;no rows selectedSQL>

11.2.0.3显示结果

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.3.0SQL> select * from ctxsys.ctx_version;VER_DICT    VER_CODE----------- -----------11.2.0.3.0  11.2.0.3.0SQL> select substr(ctxsys.dri_version,1,10) VER_CODE from dual;VER_CODE----------11.2.0.3.0SQL> select count(*) from dba_objects where owner='CTXSYS';  COUNT(*)----------       388SQL> select object_type, count(*) from dba_objects where owner='CTXSYS' group by object_type order by 1;OBJECT_TYPE           COUNT(*)------------------- ----------FUNCTION                     2INDEX                       63INDEXTYPE                    4LIBRARY                      1LOB                          2OPERATOR                     6PACKAGE                     74PACKAGE BODY                63PROCEDURE                    2SEQUENCE                     3TABLE                       50TYPE                        35TYPE BODY                    6VIEW                        7714 rows selected.SQL>SQL> -- Any invalid objectsSQL> select object_name, object_type, status from dba_objects where owner='CTXSYS' and status != 'VALID' order by object_name;no rows selectedSQL>

删除oracle text组件也很简单

SQL> connect SYS/password as SYSDBASQL> spool text_deinstall.logSQL> @?/ctx/admin/catnoctx.sqlSQL> drop procedure sys.validate_context;SQL> spool off