Oracle GoldenGate Error Messages

OGG-01505

OCI Error ({0,number,0}, {1}) maximum cursors exceeded, unable to prepare new statement for table {2}, query = {3}


Cause

The maximum number of cursors allowed by the MAXSQLSTATEMENTS parameter has been reached.


Action

If the database cursor limit permits, and there will be enough cursors for other applications, you can increase the value of MAXSQLSTATEMENTS. However, see the Oracle GoldenGate reference documentation before changing this parameter.