we have increased the cursors connection 300-2000, still we are getting this error, is there bug with R11.3.6.SP7
-bash-4.2$ autoflags -a1589 LINUX ORA 11.3.6 SP7 4d900a59
[08/26/2018 21:02:16] CAUAJM_E_18402 ORA-01000: maximum open cursors exceeded[08/26/2018 21:02:16] ORA-01000: maximum open cursors exceeded[08/26/2018 21:02:16] CAUAJM_I_18403 Processing OCI function not used(4)[08/26/2018 21:02:16] CAUAJM_E_18402 ORA-01000: maximum open cursors exceeded[08/26/2018 21:02:16] ORA-01000: maximum open cursors exceeded[08/26/2018 21:02:16] CAUAJM_I_18403 Processing OCI function not used(4)
This is Autosys issue and looks like by mistake it is listed in DE community. Updated it accordingly.
I did some search in our Base and I found a similar issue .
- max cursors can be resolved with oracle tuning
'SESSION_CACHED_CURSORS' and 'OPEN_CURSORS' Parameters Based on Usage ( Oracle Doc ID 208857.1 )
- Turning of WCC App Editor setting fixed the cursor issue.
Show Jobs from AE instead of WCC collector DB Displays jobs from AE even when they are not in the WCC collector database. Default: Clear
Please take a look and let me know if it resolves the problem
Thanks and best regards,
I am wondering if this problem might come from WCC Quick View.
Could you please open WCC, click the "Configuration" widget
In "Preferences", select "Quick View"
At the bottom of the list of options, uncheck "Show Jobs from AE instead of WCC Collector DB"
For follow up, I would recommend to open a case at CA support with the result of this above action
and ask also DBA to give us Oracle cursor related logs
Have you been able to make the changes recommended herein and see if it resolves the reported issue?
Did you apply my workaround?
Did it help?