GoldenGate, Streams and Distributed Database (MOSC)

MOSC Banner

Streams and CDC Capture process generating ORA-24335 errors but tables have less than 1000 columns

edited May 17, 2013 7:03AM in GoldenGate, Streams and Distributed Database (MOSC) 2 commentsAnswered
i posted this to the Database Administration Community first, but it probably belongs here

Platform: Linux X64

Database Version: 11.2.0.3

We have upgraded all of our non-production databases from 10.2.0.5 to 11.2.0.3 and not encountered this problem. We upgraded our production databases to 11.2.0.3 and started encountering this error:

In the Streams and CDC Capture processes, the following error occurs:

Streams CAPTURE CP02 for CDC$C_CDCCHGSOURCE with pid=110, OS id=23456 stopped
Errors in file /oradata/PRDORA01/admin/bdump/diag/rdbms/prdora01/PRDORA01/trace/PRDORA01_cp02_23456.trc:
ORA-24335: cannot support more than 1000 columns

From the .trc file:

++ KRVXOA Dump Begin:
Object Number: 1351290 BaseObjNum: 1351290 BaseObjVersion: 1

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

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

Category Leaderboard

Top contributors this month

Instructions for posting

×

1. Select a discussion category from the picklist.


2. Enter a title that clearly identifies the subject of your question.


3. In the body, insert detailed information, including Oracle product and version.


Please abide by the Oracle Community guidelines and refrain from posting any customer or personally identifiable information (PI/CI).


Cloud / Fusion customers - Our Cloud community has moved! Please go to Cloud Customer Connect .


New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center