手工安装与卸载 11gR1 的Oracle Text 组件

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

---

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/22782597/viewspace-618137/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/22782597/viewspace-618137/