CONTAINS Query Fails with ORA-29902, ORA-20000, ORA-14552 From Standby Database
(Doc ID 2753333.1)
Last updated on FEBRUARY 17, 2021
Applies to:Oracle Text - Version 18.104.22.168.0 and later
Information in this document applies to any platform.
Since upgrading to 19c, CONTAINS query from a Standby DB with Active Data Guard and Read-Only fails with the errors:
ORA-29902: error in executing ODCIIndexStart() routine
ORA-20000: Oracle Text error:
ORA-14552: cannot perform a DDL, commit or rollback inside a query or DML
The errors occur in the Standby database only and if NLS_SORT is set to value other than BINARY.
If NLS_SORT is set to BINARY, no error occurs. The same query also runs successfully from the Primary database.
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