Shulou(Shulou.com)06/01 Report--

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

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.