This content has been marked as final. Show 4 replies
Please let us know in which patch are you in.
And if this is consistently reproducible, please send us the export and tip.properties to email@example.com
Please refer to Tech Note : Latest B2B Patch
for latest patch details
Try this also
Set open_cursors to 500 or more, set scope=spfile if you hit error then set to scope=memory
C:\ sqlplus /as sysdba
SQL> alter system set open_cursors=500 scope=spfile;
SQL> shutdown immediate;
Restart you infra, midtire and B2B.
Change to 3000 as the value for open cursors. We hit the same issue with very low volumes.
It is possible that a newer patch solves the issue as well, but the setting above works in several installations I have worked with and lower values did not.
It depends on the volume, however safest bet would be a value of 2000.