ORA-12842: Cursor invalidated during parallel execution on Exadata

Hi,

I got ORA-12842: Cursor invalidated during parallel execution error during parallel execution on Exadata.

To solve this problem, use the “_fix_control” hidden parameter.

The syntax for using _FIX_CONTROL is:

"_fix_control"='Bugno:ON'    (OR)   "_fix_control"="Bugno:1"

"_fix_control"='Bugno:OFF'  (OR)   "_fix_control"="Bugno:0"

In this case, we encounter the 7170213 bug. So I will disable it for the related session as follows.

ALTER SESSION SET "_FIX_CONTROL"='7170213:OFF';

When i use this parameter, our problem has been solved.

You can set it for the database as follows.

ALTER SYSTEM SET "_FIX_CONTROL"='7170213:OFF' scope=spfile sid='*';

Do you want to learn Oracle Database for Beginners, then read the following articles.

https://ittutorial.org/oracle-database-19c-tutorials-for-beginners/