手工安装Oracle全文检索工具

在Oraclei Rlease中Oracle的全文检索技术被称为:Oracle Text功能十分强大Oracle Text是Oraclei采用的新名称在Oracle/i中它被称作Oracle interMedia Text在Oracle以前它的名称是Oracle ConText Cartridge

Oracle Text组件可以在安装数据库的时候选择缺省是安装的如果没有安装那么可以按照以下方式手动安装Oracle Text

创建存储表空间

$ sqlplus / as sysdbaSQL*Plus: Release Production on Sun May :: Copyright (c) Oracle Corporation All rights reservedConnected to:Oraclei Enterprise Edition Release bit ProductionWith the Partitioning OLAP and Oracle Data Mining optionsJServer Release ProductionSQL> select name from v$datafile;NAME/hlove/oracle/systemdbf/hlove/oracle/undotbsdbf/hlove/oracle/usersdbf rows selectedSQL> create tablespace oratext datafile /hlove/oracle/oratextdbf size m extent management local uniform size k ; Tablespace created

创建相关对象

SQL> spool textlogSQL> connect sys/oracleHURRAY as sysdbaConnectedSQL> start ?/ctx/admin/drcsys password oratext tempcreating user CTXSYScreating role CTXAPPSQL> connect ctxsys/passwordConnectedSQL> start ?/ctx/admin/drinst ?/ctx/lib/libctxxso============== ConText Database Objects Installation ==============This script must be run as CTXSYS This script will exitbelow if run as any other userUser is CTXSYS creating tables and Oracle object types creating table dr$parameter creating table dr$class creating table dr$object creating table dr$object_attribute creating table dr$object_attribute_lov creating table dr$preference creating table dr$preference_value creating table dr$index creating table dr$index_partition creating table dr$index_value creating table dr$policy_tab creating table dr$sqe creating table dr$ths creating table dr$ths_phrase creating table dr$ths_fphrase creating table dr$ths_bt creating table dr$section_group creating table dr$section creating table dr$stoplist creating table dr$stopword creating table dr$sub_lexer creating table dr$index_set creating table dr$index_set_index creating table dr$server creating table dr$pending creating table dr$waiting creating table dr$online_pending creating table dr$delete creating table dr$unindexed creating table dr$index_error creating table dr$parallel creating table dr$stats creating table dr$part_stats creating named data type ctx_feedback_item_type creating named data type ctx_feedback_type creating safe callout library creating CONTEXT interfacedrop public synonym contains *ERROR at line :ORA: public synonym to be dropped does not existdrop public synonym score *ERROR at line :ORA: public synonym to be dropped does not exist creating CTXCAT interfacedrop public synonym catsearch *ERROR at line :ORA: public synonym to be dropped does not exist creating CTXRULE interfacedrop public synonym matches *ERROR at line :ORA: public synonym to be dropped does not exist creating CTXXPATH interface loading package headers================== Package Installation ==========================Install Global Symbols loading driobjpkhNo errors loading drdefpkhNo errorsloading drigpkhNo errorsInstall DR Internal package specs loading driutlpkhNo errors loading driaccpkhNo errors loading driadmpkhNo errors loading driconpkhNo errors loading dridisppkhNo errors loading dridmlpkhNo errors loading dridocpkhNo errors loading drierrpkhNo errors loading driddlpkhNo errors loading driddlppkhNo errors loading driddlcpkhNo errors loading driddlrpkhNo errors loading driddlxpkhNo errors loading drilistpkhNo errors loading driloadpkhNo errors loading drioptpkhNo errors loading dripipepkhNo errors loading driprefpkhNo errors loading drirecpkhNo errors loading drireppkhNo errors loading drirepmpkhNo errors loading drirepspkhNo errors loading drireptpkhNo errors loading drirepzpkhNo errors loading drithspkhNo errors loading drithscpkhNo errors loading drithsdpkhNo errors loading drithslpkhNo errors loading drithsxpkhNo errors loading drivalpkhNo errors loading driexppkhNo errors loading driimppkhNo errors loading driparsepkhNo errors loading drixtabpkhNo errors loading drixtabcpkhNo errors loading drixtabrpkhNo errors loading drixtabxpkhNo errorsInstall ConText public API specs loading dradmpkhNo errors loading drddlpkhNo errors loading drdocpkhNo errors loading droutpkhNo errors loading drquerypkhNo errors loading drthespkhNo errors loading drreporpkhNo errors loading drulexpkhNo errors loading drclspkhNo errors loading package bodies================== Package Installation ==========================Install DR Internal package bodies loading driaccplbNo errors loading driadmplbNo errors loading driconplbNo errors loading dridispplbNo errors loading dridmlplbNo errors loading dridocplbNo errors loading drierrplbNo errors loading driddlplbNo errors loading driddlpplbNo errors loading driddlcplbNo errors loading driddlrplbNo errors loading driddlxplbNo errors loading drilistplbNo errors loading driloadplbNo errors loading dripipeplbNo errors loading drioptplbNo errors loading driprefplbNo errors loading drirecplbNo errors loading drirepplbNo errors loading drirepmplbNo errors loading drirepsplbNo errors loading drireptplbNo errors loading drirepzplbNo errors loading drithsplbNo errors loading drithscplbNo errors loading drithsdplbNo errors loading drithslplbNo errors loading drithsxplbNo errors loading driutlplbNo errors loading drivalplbNo errors loading driexpplbNo errors loading driimpplbNo errors loading driparseplbNo errors loading drixtabplbNo errors loading drixtabcplbNo errors loading drixtabrplbNo errors loading drixtabxplbNo errors loading driprocplbNo errorsInstall ConText public API bodies loading dradmplbNo errors loading drddlplbNo errors loading drdocplbNo errors loading droutplbNo errors loading drqueryplbNo errors loading drthesplbNo errors loading drreporplbNo errors loading drclsplbNo errors======================================================== creating CONTEXT interface bodyNo errorsNo errors creating CTXCAT interface bodyNo errors creating CTXRULE interface bodyNo errors creating CTXXPATH interface bodyNo errors creating CONTEXT index typedrop public synonym context *ERROR at line :ORA: public synonym to be dropped does not exist creating CTXCAT index typedrop public synonym ctxcat *ERROR at line :ORA: public synonym to be dropped does not exist creating CTXRULE index typedrop public synonym ctxrule *ERROR at line :ORA: public synonym to be dropped does not exist creating CTXXPATH index typedrop public synonym ctxxpath *ERROR at line :ORA: public synonym to be dropped does not exist creating objectsRemoving old object definitionsCreating new object definitionscreating default preferencesCreate default preferencesSystem Parameters========================================================SQL> start ?/ctx/admin/defaults/drdefussql;Creating lexer preferenceCreating wordlist preferenceCreating stoplistCreating default policySQL> spool offSQL> exitDisconnected from Oraclei Enterprise Edition Release bit ProductionWith the Partitioning OLAP and Oracle Data Mining optionsJServer Release Production

请注意如果漏掉drdefussql脚本使用过程中将会出现以下类似错误

ERROR atline :ORA: error occurred in the execution of ODCIINDEXCREATEroutineORA: interMedia Text error:DRG: preference does notexist: CTXSYSDEFAULT_LEXERORA: at CTXSYSDRUE line ORA:at CTXSYSTEXTINDEXMETHODS line ORA: at line

这样就完成了手工安装全文检索工具