手工安裝ORACLE TEXT

手工安裝ORACLE TEXT
grant CREATE TABLE to student;
grant CREATE SEQUENCE to student;
 ORACLE TEXT安裝與卸載
 1.創(chuàng)建CTXSYS用戶
以SYS用戶執(zhí)行以下腳本：
SQL> connect SYS/password as SYSDBA
SQL> spool text_install.txt
SQL> @?/ctx/admin/catctx.sql change_on_install SYSAUX TEMP NOLOCK
各參數(shù)含義：
change_on_install – 設(shè)置ctxsys用戶密碼
SYSAUX – 調(diào)置ctxsys用戶默認(rèn)表空間
TEMP – 設(shè)置ctxsys用戶默認(rèn)臨時(shí)表空間
LOCK|NOLOCK – 設(shè)置ctxsys用戶鎖定與不鎖定
2.指定默認(rèn)安裝語言
SYS@jzh>conn ctxsys/oracle
Connected.
以ctxsys用戶執(zhí)行如下腳本：
CTXSYS@jzh>@$ORACLE_HOME/ctx/admin/defaults/drdefus.sql
在11.2.0.3版本中，如果不執(zhí)行以上腳本，那么在執(zhí)行腳本dr0defin.sql或創(chuàng)建索引時(shí)會遇到如下錯(cuò)誤：
ERROR at line 1:
ORA-20000: Oracle Text error:
DRG-10700: preference does not exist: CTXSYS.DEFAULT_LEXER
ORA-06512: at "CTXSYS.DRUE", line 160
ORA-06512: at "CTXSYS.CTX_DDL", line 1140
ORA-06512: at line 2
SQL> CREATE INDEX "EXPERIAN2"."IX_COMP_SEARCH" ON "EBA05M5" ("COMPANY_NAME") INDEXTYPE IS "CTXSYS"."CONTEXT";
設(shè)置american為默認(rèn)語言
SYS@jzh>@?/ctx/admin/defaults/dr0defin.sql "AMERICAN";
old   1: SELECT DECODE('&nls_language',
new   1: SELECT DECODE('AMERICAN',
注意：在一些系統(tǒng)中使用text必須指定相關(guān)變量，如下列表：
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
Run the following command to check if the LD_LIBRARY_PATH environmental variable is set correctly:
$ echo $LD_LIBRARY_PATH
3. 驗(yàn)證
以sys用戶登陸數(shù)據(jù)庫執(zhí)行如下腳本：
SYS@jzh>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.0
SYS@jzh>select * from ctxsys.ctx_version;
VER_DICT                                 VER_CODE
---------------------------------------- ----------------------------------------
11.2.0.3.0                               11.2.0.3.0
SYS@jzh>select substr(ctxsys.dri_version,1,10) VER_CODE from dual;
VER_CODE
----------------------------------------
11.2.0.3.0
SYS@jzh>select count(*) from dba_objects where owner='CTXSYS';
  COUNT(*)
----------
       388
SYS@jzh>select object_type, count(*) from dba_objects where owner='CTXSYS' group by object_type order by 1;
OBJECT_TYPE           COUNT(*)
------------------- ----------
FUNCTION                     2
INDEX                       63
INDEXTYPE                    4
LIBRARY                      1
LOB                          2
OPERATOR                     6
PACKAGE                     74
PACKAGE BODY                63
PROCEDURE                    2
SEQUENCE                     3
TABLE                       50
OBJECT_TYPE           COUNT(*)
------------------- ----------
TYPE                        35
TYPE BODY                    6
VIEW                        77
14 rows selected.
SYS@jzh>select object_name, object_type, status from dba_objects where owner='CTXSYS' and status != 'VALID' order by object_name;
no rows selected
如果有無效對象，可手動重新編譯。
4. 卸載Oracle text
? 以sys用戶執(zhí)行如下腳本
SQL> connect SYS/password as SYSDBA
SQL> spool text_deinstall.log
SQL> @?/ctx/admin/catnoctx.sql
SQL> drop procedure sys.validate_context;
SQL> spool off