Oracle-Text-组件-说明(2)

Text dictionary,schema name CTXSYS, is removed by calling following script from SQL*Plusconnected as SYSDBA:
--调用如下脚本删除Text dictionary，CTXSYS用户：

SQL> connect SYS/password as SYSDBASQL> spool text_deinstall.logSQL> @?/ctx/admin/catnoctx.sqlSQL> dropproceduresys.validate_context;SQL> spool off
Review the output file text_deinstall.log for errors.
注意事项：（1）ORA-04043 for droppingsys.validate_context can be ignored, as in base release version this procedurewas owned by ctxsys and needs to be owned by sys.
（2）When Data Mining is not installedand we deinstall Oracle Text, catnoctx.sql will not drop the Data Mining publicsynonyms and they must be removed manually
--如
果没有安装Data Mining 组件，那么在删除Text 组件时，DataMining 的公共同义词不会被删除，需要手工的移除，命令如下：

-- Drop CTXSYS publicsynonyms using the commands:SQL> set hea o

Oracle相关教程

ffSQL> spool /path/drop_ctxsys_synonyms.sqlSQL> select 'Drop public synonym ' || SYNONYM_NAME || ' ;' from DBA_SYNONYMSwhere TABLE_OWNER = 'CTXSYS';SQL> spool offSQL> @/path/drop_ctxsys_synonyms.sql
Deinstallation of Oracle Text is now complete.

2.2 Oracle 11gR2 中重建
2.2.1 Manual installation of Text 11gR2 (11.2.0.1.0)
1. Text dictionary, schema name CTXSYS, iscreated by calling following script from SQL*Plus connected as SYSDBA:
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 userpasswordSYSAUX - is the default tablespace for ctxsysTEMP - is the temporary tablespace for ctxsysLOCK|NOLOCK - ctxsys user account will be locked or not2. The next step is to install appropriatelanguage-specific default preferences.
There is scriptwhich creates language-specific default preferences for every language OracleText 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 formdrdefXX.sql, where XX is the international license plate code.
To manuallyinstall American default preferences, for example, log into sqlplus as CTXSYS,and run following statement:

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

注意：Due to the usageoff Oracle Outside in HTML Export filtering technology on some platformsthe LD_LIBRARY_PATH or SHLIB_PATH or LIBPATH must be set properly in order towork.
--在一些系统上使用Text 必须指定相关参数。

The followingtable shows in which operating system the ctxhx relies on the shared librarypath setting and which environment variable needs to be set:
--下表列出了不同操作系统上ctxhx依赖的变量，这些变量必须指定：

Platform:Requires path set: ENV variable:--------------------- --------------------- -------------------Linux x86-64YESLD_LIBRARY_PATHSolaris SPARC64YESLD_LIBRARY_PATHIBMAIXYESLIBPATHHP PA-RISCYES SHLIB_PATHHP ItaniumYESLD_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

Run thefollowing command to check if the LD_LIBRARY_PATH environmental variable is setcorrectly:$ echo $LD_LIBRARY_PATH
2.2.2 Text 11gR2 (11.2.0.1.0) Installation verification--验证安装
1. Check to make sure
that all Text objectswere created in CTXSYS schema and correct version is installed2. Check to make sure that there are not invalid objects for

Oracle相关教程

CTXSYS.You should get: "no rows selected".
If there are then you can compile eachinvalid object manually.
------------------- 示例------------------------------connect SYS/password as SYSDBAset pages 1000col object_name format a40col object_type format a20col comp_name format a30column library_name format a8column file_spec format a60 wrapspool text_install_verification.log-- check on setupselect comp_name, status, substr(version,1,10) as version from dba_registrywhere comp_id = 'CONTEXT';select * from ctxsys.ctx_version;select substr(ctxsys.dri_version,1,10) VER_CODE from dual;select count(*) from dba_objects where owner='CTXSYS';-- Get a summary countselect object_type, count(*) from dba_objects where owner='CTXSYS' group byobject_type;-- Any invalid objectsselect object_name, object_type, status from dba_objects where owner='CTXSYS'and status != 'VALID' order by object_name;spool off------------------- cut here ------------------------------
（1）A valid 11.2.0.1.0 Text installation showsthe following output
SQL> select comp_name, status,substr(version,1,10) as version from dba_registry where comp_id = 'CONTEXT';COMP_NAME STATUS VERSION------------------- -------- ----------Oracle TextVALID 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_TYPECOUNT(*)------------------- ----------SEQUENCE3PROCEDURE2OPERATOR6PACKAGE73PACKAGEBODY62LIBRARY1LOB2TYPEBODY6VIEW71 …… 此处隐藏：5364字，全部文档内容请下载后查看。喜欢就下载吧 ……