My Oracle Support Banner

Oracle Text 11.2.0.3 and 11.2.0.4 Support Note for Lexer Feature Updates (Doc ID 1354793.1)

Last updated on FEBRUARY 04, 2020

Applies to:

Oracle Text - Version 11.2.0.3 to 11.2.0.4 [Release 11.2]
Information in this document applies to any platform.

Details

The following Oracle Text features will stop functioning for customers upgrading to 11.2.0.3 or 11.2.0.4 and will fail giving a "feature not available error" - DRG-11135: feature not generally available

- AUTO_LEXER Lexer Type
- Entity Extraction Functionality (CTX_ENTITY PL/SQL package)
- The following values of INDEX_STEMS attribute of BASIC_LEXER Lexer Type (26): ARABIC, BOKMAL, CATALAN, CROATIAN, CZECH, DANISH, DERIVATIONAL_NEW, DUTCH_NEW, ENGLISH_NEW, FINNISH, FRENCH_NEW, GERMAN_NEW, GREEK, HEBREW, HUNGARIAN, ITALIAN_NEW, NYNORSK, POLISH, PORTUGUESE, ROMANIAN, RUSSIAN, SERBIAN, SLOVAK, SLOVENIAN, SPANISH_NEW, SWEDISH

 

*** Note ***
- Possible errors ORA-29855 ORA-20000 DRG-10502 DRG-11135, may return when above features are used.
- Above features are enabled in 12.1.0.2 release.
- The technology for all the features listed in this note has been changed to a new implementation in 12.1.0.1.0 and 12.1.0.2.0.
  For this reason, indexes created before 12.1.0.1.0 that use these features could see different results, and will not be supported.
  Oracle recommends that all such indexes be rebuilt so that the same technology is used for lexing during indexing and querying.

 

Actions

This is only a run-time disablement. Customers who are using the features are allowed to re-enable these features after help from Oracle Support.

The following steps (1 and 2) are needed by the customer:

1. Enabling the feature

For customer on non-Windows platform, on 11.2.0.3 apply <Patch 12811829>  and for 11.2.0.4 apply <Patch 17402822> .
Contact Oracle Support if the patch is not available for your platform.

*** Note for for Microsoft Windows platform ***

Above Text fixes are included in 11.2.0.3 Bundle Patch 30 and higher and in 11.2.0.4 Bundle Patch 6 (BP 11.2.0.4.6) and higher. See <Note 2285559.1> for finding the latest Windows Bundle Patch.

 

*** Note ***
If you have installed <Patch 17402822> and Patch 19689469 then you can enable AUTO_LEXER while setting below event at session or system level.
Example for setting it at the session level:

alter session set events '30579 trace name context forever, level 67108864';

This event is not available on 12cR1 release, as this feature is enabled by default.

 

2. Running the Report to verify if your application uses these features.

Please run the following report from SQL*Plus connected as CTXSYS. If the queries do not return any results then no further action is required.

SQL> connect ctxsys

set echo on
spool report.txt
show user

-- TO IDENTIFY EXISTING PREFERENCES USING AUTO_LEXER OR
-- BASIC_LEXER WITH INXIGHT-BASED INDEX_STEMS ARE IN USE

SELECT DISTINCT (P.PRE_OWNER||'.'|| P.PRE_NAME ) AS PREFERENCE_NAME
FROM CTX_PREFERENCES P, CTX_PREFERENCE_VALUES PV
WHERE NOT(P.PRE_NAME = 'DEFAULT_EXTRACT_LEXER' AND P.PRE_OWNER='CTXSYS') AND
P.PRE_OWNER=PV.PRV_OWNER AND P.PRE_NAME=PV.PRV_PREFERENCE AND
P.PRE_CLASS='LEXER' AND (P.PRE_OBJECT='AUTO_LEXER' OR
(P.PRE_OBJECT= 'BASIC_LEXER' AND
PV.PRV_ATTRIBUTE='INDEX_STEMS' AND
PV.PRV_VALUE IN('ARABIC',
'BOKMAL',
'CATALAN',
'CROATIAN',
'CZECH',
'DANISH',
'DERIVATIONAL_NEW',
'DUTCH_NEW',
'ENGLISH_NEW',
'FINNISH',
'FRENCH_NEW',
'GERMAN_NEW',
'GREEK',
'HEBREW',
'HUNGARIAN',
'ITALIAN_NEW',
'NYNORSK',
'POLISH',
'PORTUGUESE',
'ROMANIAN',
'RUSSIAN',
'SERBIAN',
'SLOVAK',
'SLOVENIAN',
'SPANISH_NEW',
'SWEDISH') ));

-- TO IDENTIFY IF ENTITY-EXTRACTION, AUTO_LEXER OR
-- BASIC_LEXER WITH INXIGHT-BASED INDEX_STEMS ARE IN USE

SELECT DISTINCT (IXV_INDEX_OWNER || '.'||IXV_INDEX_NAME) AS NAME,
(CASE I.IDX_TEXT_NAME WHEN 'PLT_POLICY' THEN 'POLICY'
ELSE 'INDEX' END) AS TYPE
FROM CTX_INDEXES I, CTX_INDEX_VALUES IV
WHERE I.IDX_NAME=IV.IXV_INDEX_NAME AND
I.IDX_OWNER = IV.IXV_INDEX_OWNER AND
IV.IXV_CLASS='LEXER' AND
(IV.IXV_OBJECT='AUTO_LEXER' OR
IV.IXV_OBJECT='DEFAULT_EXTRACT_LEXER' OR
(IV.IXV_OBJECT='BASIC_LEXER' AND
IV.IXV_ATTRIBUTE='INDEX_STEMS' AND
IV.IXV_VALUE IN ('ARABIC',
'BOKMAL',
'CATALAN',
'CROATIAN',
'CZECH',
'DANISH',
'DERIVATIONAL_NEW',
'DUTCH_NEW',
'ENGLISH_NEW',
'FINNISH',
'FRENCH_NEW',
'GERMAN_NEW',
'GREEK',
'HEBREW',
'HUNGARIAN',
'ITALIAN_NEW',
'NYNORSK',
'POLISH',
'PORTUGUESE',
'ROMANIAN',
'RUSSIAN',
'SERBIAN',
'SLOVAK',
'SLOVENIAN',
'SPANISH_NEW',
'SWEDISH') ));

spool off

Contacts

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Details
Actions
Contacts
References

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.