【Oracle】Oracle Text组件安装

简介

在配置arcgis时报的一个错误：
Oracle Text package is not installed.
XML support not enabled for the database instance.
经查：
Oracle text译为全文检索技术，是智能信息管理的关键技术之一，Oracle Text作为Oracle的一个组件，提供了强大的全文检索功能，用Oracle做后台数据库，就可以充分利用其全文检索技术，构建复杂的大型文档管理系统。
然后我们就需要配置oracle text这个组件

安装配置说明

1.创建CTXSYS用户

dba执行

@?/ctx/admin/catctx.sql change_on_install SYSAUX TEMP NOLOCK

日志：

[oracle@yyq-n-2 ~]$ sqlplus SYS/sys123 as SYSDBA

SQL*Plus: Release 11.2.0.4.0 Production on Mon May 17 14:52:32 2021

Copyright (c) 1982, 2013, Oracle.  All rights reserved.


Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> spool text_install.txt
SQL> @?/ctx/admin/catctx.sql change_on_install SYSAUX TEMP NOLOCK

...creating user CTXSYS

User created.
Grant succeeded.
Grant succeeded.
Grant succeeded.
--一段很长的执行日志
……

Procedure created.
Grant succeeded.
Session altered.
PL/SQL procedure successfully completed.
PL/SQL procedure successfully completed.
Session altered.
SQL> 

2.登录CTXSYS用户

更改ctxsys密码并赋权登录ctxsys用户

SQL>  conn / as sysdba
Connected.
SQL> alter user ctxsys identified by 123;

User altered.

SQL> 
SQL> grant dba to ctxsys;

Grant succeeded.

SQL> conn ctxsys/ctxsys123;
Connected.
SQL> 

3.创建Oracle Text

ctxsys用户执行以下sql

@$ORACLE_HOME/ctx/admin/defaults/drdefus.sql

日志：

SQL> @$ORACLE_HOME/ctx/admin/defaults/drdefus.sql
Creating lexer preference...

PL/SQL procedure successfully completed.

Creating wordlist preference...

PL/SQL procedure successfully completed.

Creating stoplist...

PL/SQL procedure successfully completed.


PL/SQL procedure successfully completed.

Creating default policy...

PL/SQL procedure successfully completed.

SQL> 

4.验证安装情况

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

参考：
1.ORACLE TEXT安装与卸载
2.Oracle text介绍