The easiest setup program of Oracle's full-text retrieval (strong recommendation)
Li Shouliang SLLI@founder.com.cn
Last Version: 2003-02-25
You can now retrieve the full text of Oracle without installing JServer and iTermeia. When you install JServer and InterMedia, it is laborious, and the disk space does not say, and it is still specifically resource. Now there is a good way to install them, you can use the full text to retrieve it. Please follow the steps below to complete the full-text search settings in a few minutes.
SQL scripts are stored in $ oracle_home / ctx / admin, this document is separated by step card, but the operation process is coherent. This document creates a full-text index in Sun Soralris, AIX 8.1.7 environment verification, due to environmental reasons, no verification on other platforms and 9i, but the problem should not be large.
Please refer to the last full-text search setting scheme. This example is the server-side setting step. After operation, the default lexical analyzer is Chinese_vgram_lexer, which is a database encoded for the zhs16GBK. If you want to use Chinese_LEXER, you need to create it manually created by the last document. After creating an index (case myIndex), the SELECT DR $ MyIndex $ I table views the analysis result.
Example environment:
Platform: Sun Solaris
SID: SUNORA
Version: 8.1.7.3
Oracle_Home / Global / Data2 / Oracle / Orahome1
SQL default storage location: $ oracle_home / ctx / admin
Example installation process:
1, modify init.ra, modify shared_pool_size = 100m
2, restart the database to confirm the shared_pool_size value has taken effect
3. Create a Drsys table space, allocate 100M space
4, set ld_library_path
5, create a CTXSYS user as SYS
6, run $ oracle_home / ctx / admin / dr0inst.sql with ctxsys
7. Run $ oracle_home / ctx / admin / DRDEFZHOME / CTX / Admin / DRDEFZHOME / CTX / Admin / DRDE_HOME / CTX / Admin / DRDEFZHOME / CTX / Admin / DRDEFZHOME
Example:
1, modify init.ra, modify shared_pool_size = 100m
$ CD / GLOBAL / DATA2 / ORACLE / ORAHOME1 / DBS
$ cinora.ora. initsunora.ora.bak
$ vi initsunora.ora
#shared_pool_size = 20971520
Shared_pool_size = 100m
2, restart the database to confirm the shared_pool_size value has taken effect
$ SQLPLUS / NOLOG
SQL * Plus: Release 8.1.7.0.0 - Production on Tuesday February 25 14:39:23 2003
(c) CopyRight 2000 Oracle Corporation. All Rights Reserved.
SQL> Connect / as sysdba
connected.
SQL> Shutdown Immediate
Oracle routines have been closed
SQL> Startup
Oracle routines have been started.
Total System Global Area 979324604 BYtes
Fixed size 102076 bytes
Variable size 278478848 bytesdatabase buffers 700563456 BYTES
Redo buffers 180224 BYTES
The database is loaded.
The database has been opened.
SQL> show parameter shared_pool
Name Type Value
------------------------------------- -----------------------
Shared_pool_reserved_size string 11676108
Shared_pool_size string 233522175
3. Create a Drsys table space, allocate 100M space
SQL> CREATE TABLESPACE DRSYS
2 DataFile '/global/data2/oracle/space.drs.001.dbf' size 100m
3 online;
The table space has been created.
SQL> EXIT
4, set ld_library_path
$ Ld_library_path = $ oracle_home / lib: $ oracle_home / ctx / lib; export ld_library_path
(Or run
$ CD
$ v.profile
modify
LD_LIBRARY_PATH = $ ORACLE_HOME / LIB: $ ORACLE_HOME / CTX / LIB
Export ld_library_path
$ su - oracle
)
5, create a CTXSYS user as SYS
$ CD $ ORACLE_HOME / CTX / Admin
$ PWD
/ global / data2 / oracle / orahome1 / ctx / admin
$ SQLPLUS SYS / CHANGE_ON_INSTALL @. / Dr0csys.sql CTXSys Drsys Temp
SQL * Plus: Release 8.1.7.0.0 - Production on Tuesday 25 14:06:36 2003
(c) CopyRight 2000 Oracle Corporation. All Rights Reserved.
Connected to:
Oracle8i Enterprise Edition Release 8.1.7.0.0 - 64bit Production
WITH THE PartInog Option
Jserver Release 8.1.7.0.0 - 64bit Production
... CREATING User CTXSYS
... CREATING ROLE CTXAPP
SQL> EXIT
6, run $ oracle_home / ctx / admin / dr0inst.sql with ctxsys
$ sqlplus ctxsys / ctxsys @. / dr0inst.sql $ oracle_home / ctx / lib / libctxx8.so
SQL * Plus: Release 8.1.7.0.0 - Production on Tuesday 25 14:07:55 2003
(c) CopyRight 2000 Oracle Corporation. All Rights Reserved.
Connected to:
Oracle8i Enterprise Edition Release 8.1.7.0.0 - 64bit Production
WITH THE PartInog Option
Jserver Release 8.1.7.0.0 - 64bit production ============== CONTEXT DATABASE Objects Installation ==============
This Script Must Be Run As Ctxsys. This Script Will EXIT
BELOW IF Run as Any Other User.
User is ctxsys
... CREANG TABLES AND ORACLE OBJECT TYPES
... CREANG TABLE DR $ Parameter
... CREANG TABLE DR $ Class
... CREANG TABLE DR $ OBJECT
... CREANG TABLE DR $ Object_attribute
... CREANG TABLES AND ORACLE OBJECT TYPES
...
7. Run $ oracle_home / ctx / admin / DRDEFZHOME / CTX / Admin / DRDEFZHOME / CTX / Admin / DRDE_HOME / CTX / Admin / DRDEFZHOME / CTX / Admin / DRDEFZHOME
SQL> @. / Defaults / DRDEFZHS.SQL
Creating Lexer Preference ...
Creating WordList Preference ...
CREATING Stoplist ...
SQL> EXIT
Li Shouliang SLLI@founder.com.cn
2003-2-25
