手工安装ORACLE TEXT

[oracle@dm01db01 ~]$ sqlplus / as sysdba


SQL*Plus: Release 11.2.0.3.0 Production on Mon Dec 31 14:09:50 2012


Copyright (c) 1982, 2011, Oracle.  All rights reserved.




Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options


SQL>  spool text_install.txt
SQL> @?/ctx/admin/catctx.sql oracle SYSAUX TEMP NOLOCKc
...creating user CTXSYS
old   2: identified by &pass default tablespace &tbs temporary tablespace &ttbs
new   2: identified by oracle default tablespace SYSAUX temporary tablespace TEMP


User created.




Grant succeeded.




Grant succeeded.




Grant succeeded.

Grant succeeded.

。。。。。

SQL>

SQL> spool text_install.txt
SQL> @?/ctx/admin/catctx.sql oracle SYSAUX TEMP NOLOCK
...creating user CTXSYS
old   2: identified by &pass default tablespace &tbs temporary tablespace &ttbs
new   2: identified by oracle default tablespace SYSAUX temporary tablespace TEMP


User created.




Grant succeeded.

。。。。。

SQL> connect "CTXSYS"/"oracle"
Connected.
SQL> @?/ctx/admin/defaults/dr0defin.sql "AMERICAN";
old   1: SELECT DECODE('&nls_language',
new   1: SELECT DECODE('AMERICAN',


LA
--
us


Creating lexer preference...


PL/SQL procedure successfully completed.


Creating wordlist preference...


PL/SQL procedure successfully completed.

。。。。

SQL> set pages 1000
SQL> col object_name format a40
SQL> col object_type format a20
SQL> col comp_name format a30
SQL> column library_name format a8
SQL> column file_spec format a60 wrap
SQL> spool text_install_verification.log
SQL> select comp_name, status, substr(version,1,10) as version from dba_registry where comp_id = 'CONTEXT';


SQL> 
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> 
SQL> select * from ctxsys.ctx_version;


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


SQL> 
SQL> 
SQL> select substr(ctxsys.dri_version,1,10) VER_CODE from dual;


VER_CODE
--------------------
11.2.0.3.0


SQL> 
SQL> 
SQL> select count(*) from dba_objects where owner='CTXSYS';


  COUNT(*)
----------
       388


SQL> 
SQL> 
SQL> select object_type, count(*) from dba_objects where owner='CTXSYS' group by object_type;


OBJECT_TYPE            COUNT(*)
-------------------- ----------
SEQUENCE                      3
PROCEDURE                     2
OPERATOR                      6
LOB                           2
LIBRARY                       1
PACKAGE                      74
PACKAGE BODY                 63
TYPE BODY                     6
TABLE                        50
INDEX                        63
VIEW                         77
FUNCTION                      2
INDEXTYPE                     4
TYPE                         35


14 rows selected.


SQL> 
SQL> 
SQL> 
SQL> select object_name, object_type, status from dba_objects where owner='CTXSYS' and status != 'VALID' order by object_name;


no rows selected


SQL> 
SQL> 
SQL> spool off

参考文档：

《Manual installation, deinstallation Oracle Text 11gR2 (Doc ID 970473.1)》