My Oracle Support Banner

SQL Error (1461). Can't Create More Than MAX_PREPARED_STMT_COUNT Statements (Current Value: 120000) (Doc ID 2239331.1)

Last updated on APRIL 09, 2020

Applies to:

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


Replicat running against MYSQL database was failed by the following message:

2016-04-29 08:53:32 ERROR OGG-00768 Oracle GoldenGate Delivery for MySQL, rtest.prm: DYNSQL: Preparing SQL statement (ID = 0) failed. SQL error (1461). Can't create more than max_prepared_stmt_count statements (current value: 120000).

In the translate, there are a lot of prepare update statement against some tables. Even setting the max_prepared_stmt_count to 120000 did not help


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

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