Re: Intermedia Text setup problem ORA8.1.7

From: Peter <noemail_at_noemail.com>
Date: Thu, 27 Mar 2003 11:57:55 +1000
Message-ID: <b5tlth$cp3$1@bunyip.cc.uq.edu.au>

This is what I used for 8.1.6.3.

A quick way to check to see if it is installed, is to check for the ctxsys user.

---

• as sys do the following

create tablespace drsys

   EXTENT MANAGEMENT LOCAL UNIFORM SIZE 128 K    DATAFILE '/db01/oradata/DBNAME/drsys_01.dbf'

      SIZE 64 M REUSE
      AUTOEXTEND ON NEXT 16 M
      MAXSIZE 2096 M

;

• The parameters in order are the password, default tablespace and temporary tablespace
• The following script creates the ctxsys user with appropriate tablespaces.

@?/ctx/admin/dr0csys PASSWORD drsys temp; @?/ctx/admin/dr0csys PASSWORD tools temp;

• connect as ctxsys user and run the below script

@?/ctx/admin/dr0inst /u01/app/oracle/product/8.1.6/ctx/lib/libctxx8.so; @?/ctx/admin/dr0inst /app01/oracle/product/9.2.0/ctx/lib/libctxx9.so;

• run this script for the appropriate language that you want, eg the last two
• letters of the script are for the uk, they could be others such as US.

@?/ctx/admin/defaults/drdefuk;

• Make sure that the parameter text_enable is set to false in the init.ora

text_enable = false

• To see if it has installed correctly, run the following query as ctxsys

SELECT * FROM user_libraries;

• Which should return the following results
• LIBRARY_NAME FILE_SPEC DYNAMIC STATUS
• DR$LIB N VALID
• DR$LIBX /u01/app/oracle/product/8.1.6/ctx/lib/libctxx8.so Y VALID
• This directory should be added to the path:

$ORACLE_HOME/ctx/lib

• Then create a user with connect, resource and also grant them ctxapp
• Do the following.

create table quick_clob (
 quick_id number primary key,
 text clob
);

insert into quick_clob
  ( quick_id, text )
 values
  ( 1, 'The cat sat on the mat' );

insert into quick_clob
  ( quick_id, text )
 values
  ( 2, 'The quick brown fox jumped over the lazy dog' );

commit;

create index quick_clob_idx on quick_clob ( text )  indextype is ctxsys.context;

SELECT
 score(20),
 text
FROM
 quick_clob
WHERE CONTAINS
 (text, 'near((quick, dog), 6)' ,20) > 0;

drop table quick_clob ;

• TROUBLESHOOTING
  • Ensure that the listener is started with the new IPC settings:

type: lsnrctl status

-> The important service summary item to check here is the service handler for PLSExtProc. This should return:

PLSExtProc has 1 service handler(s)

• Test the service handler for PLSExtProc with tnsping:

tnsping extproc_connection_data

• A quick way to test the Net8 configuration is to do:

exec ctx_output.start_log('log');
-- and to stop it

exec ctx_output.end_log();

• from the sqlplus prompt, if it returns an error, then there is a problem
• with the net8 listener

"TC3 Racer" <gordonchapman_nospam_at_hotmail.com> wrote in message news:JrB*HrgOp_at_relay.lsl.co.uk...

> All the documentation I can find tells me to run the dr0inst script with a
> parameter for the ctxx_library.
>
> There should be a ctx/lib dir with a file name something like libctxx8.so
>
> I have no /lib dir and therefore no file.
>
> Anybody had experience of this and know how to get around it
>
> Thanks
>
> GC
>
>

Received on Wed Mar 26 2003 - 19:57:55 CST