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

Last updated on APRIL 06, 2017

Applies to:

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

Goal

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, reptrade.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
 

Solution

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms