ORA-00600 when searching structures in E-Notebook

ORA-00600 when searching structures in E-Notebook

PROBLEM:

Sometimes the following error occurs when searching structures in E-Notebook 13.x with Oracle 12.1:

Sorry, an error occurred while executing a database operation: ORA-00600: internal error code, arguments: [17090], [], [], [], [], [], [], [], [], [], [], [].


SOLUTION:

Apply Oracle patches 21171382 and 22652097 to mimic the behavior of the 12.2c release.



The adaptive features controlled by parameter optimizer_adaptive_features will be split in two, and the parameter made obsolete. The new parameters are:

optimizer_adaptive_plans for in place adaptation where certain optimization decisions are deferred to run-time based on statistics collector output. This applies to join method selection, adaptive distribution methods and bitmap plans used by the star transformations. This parameter is TRUE by default.

optimizer_adaptive_statistics for adaptations based on statistics collected at run-time and used during later re-optimizations for the same query or different queries with similar constructs. This applies to automatic re-optimization based on cardinality or performance, sql plan directives, dynamic sampling. This parameter is FALSE by default.