DanBrother的部落格

How to Install Oracle Text Option on Oracle 11gR2 Database?

1. Install Oracle Text
SQL> conn / as sysdba
SQL> set trimspool on trimout on pagesize 50000
SQL> spool /home/oracle/text_inst_log.txt
@?/ctx/admin/catctx.sql my_pass SYSAUX TEMP NOLOCK

2. Install Language
SQL> accept pwd hide
SQL> conn CTXSYS/&pwd
SQL> @?/ctx/admin/defaults/dr0defin.sql
SQL> conn / as sysdba
SQL> alter user ctxsys account lock password expire;
SQL> spool off

3. Verification
SQL> col comp_name format a20
SQL> col status format a10
SQL> col version format a10
SQL> 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

SQL> col ver_dict format a10
SQL> col ver_code format a10
SQL> select ver_dict,ver_code from ctxsys.ctx_version;

VER_DICT VER_CODE
---------- ----------
11.2.0.3.0 11.2.0.3.0

Note: Oracle Text Option for the repository database is required when installing Oracle Portal 11g.

[Reference]
1. http://toddlerdba.blogspot.tw/2011/04/install-oracle-text-oracle-database.html

2. RCU Fails During Portal Configuration Assistant: RCU-6130 Action Failed RCU-6135 [ID 1099572.1]