手工安裝Oracle全文檢索工具

在Oraclei Rlease中Oracle的全文檢索技術被稱為:Oracle Text功能十分強大Oracle Text是Oraclei采用的新名稱在Oracle/i中它被稱作Oracle interMedia Text在Oracle以前它的名稱是Oracle ConText Cartridge
Oracle Text組件可以在安裝數據庫的時候選擇缺省是安裝的如果沒有安裝那麼可以按照以下方式手動安裝Oracle Text
創建存儲表空間

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

創建相關對象

　　SQL> spool textlog SQL> connect sys/oracleHURRAY as sysdba Connected SQL> start ?/ctx/admin/drcsys password oratext temp creating user CTXSYS creating role CTXAPP SQL> connect ctxsys/password Connected SQL> start ?/ctx/admin/drinst ?/ctx/lib/libctxxso ============== ConText Database Objects Installation ============== This script must be run as CTXSYS This script will exit below if run as any other user User 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 interface drop public synonym contains * ERROR at line : ORA: public synonym to be dropped does not exist drop public synonym score * ERROR at line : ORA: public synonym to be dropped does not exist creating CTXCAT interface drop public synonym catsearch * ERROR at line : ORA: public synonym to be dropped does not exist creating CTXRULE interface drop 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 driobjpkh No errors loading drdefpkh No errors loading drigpkh No errors Install DR Internal package specs loading driutlpkh No errors loading driaccpkh No errors loading driadmpkh No errors loading driconpkh No errors loading dridisppkh No errors loading dridmlpkh No errors loading dridocpkh No errors loading drierrpkh No errors loading driddlpkh No errors loading driddlppkh No errors loading driddlcpkh No errors loading driddlrpkh No errors loading driddlxpkh No errors loading drilistpkh No errors loading driloadpkh No errors loading drioptpkh No errors loading dripipepkh No errors loading driprefpkh No errors loading drirecpkh No errors loading drireppkh No errors loading drirepmpkh No errors loading drirepspkh No errors loading drireptpkh No errors loading drirepzpkh No errors loading drithspkh No errors loading drithscpkh No errors loading drithsdpkh No errors loading drithslpkh No errors loading drithsxpkh No errors loading drivalpkh No errors loading driexppkh No errors loading driimppkh No errors loading driparsepkh No errors loading drixtabpkh No errors loading drixtabcpkh No errors loading drixtabrpkh No errors loading drixtabxpkh No errors Install ConText public API specs loading dradmpkh No errors loading drddlpkh No errors loading drdocpkh No errors loading droutpkh No errors loading drquerypkh No errors loading drthespkh No errors loading drreporpkh No errors loading drulexpkh No errors loading drclspkh No errors loading package bodies ================== Package Installation ========================== Install DR Internal package bodies loading driaccplb No errors loading driadmplb No errors loading driconplb No errors loading dridispplb No errors loading dridmlplb No errors loading dridocplb No errors loading drierrplb No errors loading driddlplb No errors loading driddlpplb No errors loading driddlcplb No errors loading driddlrplb No errors loading driddlxplb No errors loading drilistplb No errors loading driloadplb No errors loading dripipeplb No errors loading drioptplb No errors loading driprefplb No errors loading drirecplb No errors loading drirepplb No errors loading drirepmplb No errors loading drirepsplb No errors loading drireptplb No errors loading drirepzplb No errors loading drithsplb No errors loading drithscplb No errors loading drithsdplb No errors loading drithslplb No errors loading drithsxplb No errors loading driutlplb No errors loading drivalplb No errors loading driexpplb No errors loading driimpplb No errors loading driparseplb No errors loading drixtabplb No errors loading drixtabcplb No errors loading drixtabrplb No errors loading drixtabxplb No errors loading driprocplb No errors Install ConText public API bodies loading dradmplb No errors loading drddlplb No errors loading drdocplb No errors loading droutplb No errors loading drqueryplb No errors loading drthesplb No errors loading drreporplb No errors loading drclsplb No errors ======================================================== creating CONTEXT interface body No errors No errors creating CTXCAT interface body No errors creating CTXRULE interface body No errors creating CTXXPATH interface body No errors creating CONTEXT index type drop public synonym context * ERROR at line : ORA: public synonym to be dropped does not exist creating CTXCAT index type drop public synonym ctxcat * ERROR at line : ORA: public synonym to be dropped does not exist creating CTXRULE index type drop public synonym ctxrule * ERROR at line : ORA: public synonym to be dropped does not exist creating CTXXPATH index type drop public synonym ctxxpath * ERROR at line : ORA: public synonym to be dropped does not exist creating objects Removing old object definitions Creating new object definitions creating default preferences Create default preferences System Parameters ======================================================== SQL> start ?/ctx/admin/defaults/drdefussql; Creating lexer preference Creating wordlist preference Creating stoplist Creating default policy SQL> spool off SQL> exit Disconnected from Oraclei Enterprise Edition Release bit Production With the Partitioning OLAP and Oracle Data Mining options JServer Release Production

請注意如果漏掉drdefussql腳本使用過程中將會出現以下類似錯誤

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

　　 這樣就完成了手工安裝全文檢索工具

From:http://tw.wingwit.com/Article/program/Oracle/201311/17795.html