My Oracle Support Banner

CONTAINS Query Fails with ORA-29902, ORA-20000, ORA-14552 From Standby Database (Doc ID 2753333.1)

Last updated on JULY 20, 2024

Applies to:

Oracle Text - Version 18.3.0.0.0 and later
Information in this document applies to any platform.

Symptoms

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.

 

Cause

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
Symptoms
Cause
Solution
References

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