Manual installation, deinstallation and verification of Oracle Text 11gR1(Doc ID 579601.1)
1.创建ctxsys用户与对像SQL> connect SYS/password as SYSDBA
SQL> spool text_install.txt
SQL> @?/ctx/admin/catctx.sql change_on_install SYSAUX TEMP NOLOCK
change_on_install :为ctxsys 用户的密码。
SYSAUX:为ctxsys用户的默认表空间。
TEMP :为系统的临时表空间。
2.安装Oracle Text组件
SQL> connect "CTXSYS"/"change_on_install"
SQL> @?/ctx/admin/defaults/dr0defin.sql "AMERICAN";
SQL> connect SYS/password as SYSDBA
SQL> alter user ctxsys account lock password expire;
SQL> spool off
3.设置LD_LIBRARY_PATH 环境变量
如果使用的是 C Shell (csh or tcsh),:
$ setenv LD_LIBRARY_PATH $ORACLE_HOME/ctx/lib:$LD_LIBRARY_PATH
如果使用的是Bourne shell (sh), Bash shell (bash), or Korn shell (ksh), enter the following:
$ export LD_LIBRARY_PATH=$ORACLE_HOME/ctx/lib:$LD_LIBRARY_PATH
4.检查安装
(1)确保已经正确创建CTXSYS用户及其所有对象。
(2)确保CTXSYS用户下没有"invalid" 状态的对象。
(3)执行下面的脚本,检查安装情况。
------------------- cut here ------------------------------
connect SYS/password as SYSDBA
set pages 1000
col object_name format a40
col object_type format a20
col comp_name format a30
column library_name format a8
column file_spec format a60 wrap
spool text_install_verification.log
-- check on setup
select comp_name, status, substr(version,1,10) as version from dba_registry where 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 wner='CTXSYS';
-- Get a summary count
select object_type, count(*) from dba_objects where wner='CTXSYS' group by object_type;
-- Any invalid objects
select object_name, object_type, status from dba_objects where wner='CTXSYS' and status != 'VALID' order by object_name;
spool off
------------------- cut here ------------------------------
卸载Oracle text 组件
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