Manually install ORACLE TEXT
Manually install ORACLE TEXT
Grant CREATE TABLE to student
Grant CREATE SEQUENCE to student
ORACLE TEXT installation and uninstallation
1. Create a CTXSYS user
Execute the following script as the SYS user:
SQL > connect SYS/password as SYSDBA
SQL > spool text_install.txt
SQL > @? / ctx/admin/catctx.sql change_on_install SYSAUX TEMP NOLOCK
The meaning of each parameter:
Change_on_install-sets the ctxsys user password
SYSAUX-set ctxsys user default tablespace
TEMP-sets the ctxsys user default temporary tablespace
LOCK | NOLOCK-sets ctxsys user lock and unlock
two。 Specify the default installation language
SYS@jzh > conn ctxsys/oracle
Connected.
Execute the following script as the ctxsys user:
CTXSYS@jzh > @ $ORACLE_HOME/ctx/admin/defaults/drdefus.sql
In version 11.2.0.3, if you do not execute the above script, you will encounter the following error when executing the script dr0defin.sql or creating an index:
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 "
Set american as the default language
SYS@jzh > @? / ctx/admin/defaults/dr0defin.sql "AMERICAN"
Old 1: SELECT DECODE ('& nls_language'
New 1: SELECT DECODE ('AMERICAN'
Note: relevant variables must be specified when using text on some systems, as listed below:
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. Verification
Execute the following script as a sys user logging in to the database:
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 (*)
-
three hundred and eighty eight
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
If there are invalid objects, you can recompile them manually.
4. Uninstall Oracle text
? Execute the following script as the sys user
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
