AutoSys Workload Automation

Expand all | Collapse all

ORA-01000 maximum open cursors exceeded

  • 1.  ORA-01000 maximum open cursors exceeded

    Posted 08-27-2018 08:59 PM

    we have increased the cursors connection 300-2000, still we are getting this error, is there bug with R11.3.6.SP7

    ORA-01000

    -bash-4.2$ autoflags -a
    1589 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)



  • 2.  Re: ORA-01000 maximum open cursors exceeded

    Posted 08-28-2018 12:56 PM

    Hi,

     

    This is Autosys issue and looks like by mistake it is listed in DE community. Updated it accordingly.

     

    Ravi Kiran



  • 3.  Re: ORA-01000 maximum open cursors exceeded

     
    Posted 08-31-2018 06:20 AM

    Hi Kiran

     

    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.

     

    https://docops.ca.com/ca-workload-automation-ae/11-4-2/en/ca-wcc-help-systems/ca-wcc-configuration-application/preferences-section-in-the-configuration-application#PreferencesSectionintheConfigurationApplication-ConfigurationPreferences

     

    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,

     

    Faouzia



  • 4.  Re: ORA-01000 maximum open cursors exceeded

    Posted 09-07-2018 08:34 AM

    Hello Donny

     

    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

     

    Regards

    Jean Paul

     

     

     



  • 5.  Re: ORA-01000 maximum open cursors exceeded

    Posted 09-10-2018 10:00 PM

    Hi Donny,

     

    Have you been able to make the changes recommended herein and see if it resolves the reported issue?

     

    Thank you,

    Chandru



  • 6.  Re: ORA-01000 maximum open cursors exceeded

    Posted 10-08-2018 05:46 AM

    Hello Donny

    Did you apply my workaround?

     

    Did it help?

     

    Regards

    Jean Paul