DBAsupport.com Forums - Powered by vBulletin
Page 2 of 2 FirstFirst 12
Results 11 to 18 of 18

Thread: RAC 11g: ORA-01000: maximum open cursors exceeded

  1. #11
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    Have you monitored what is in v$open_cursor when you see this error?

  2. #12
    Join Date
    Mar 2001
    Location
    Ireland/Dublin
    Posts
    688
    Quote Originally Posted by pando
    Have you monitored what is in v$open_cursor when you see this error?
    Yes, I have only one session as this user (checked 2 nodes) and the result is bellow:

    Code:
    SQL> select sid,serial#,machine,program from v$session where username='USER';
    
           SID    SERIAL# MACHINE                                                          PROGRAM
    ---------- ---------- ---------------------------------------------------------------- ------------------------------------------------
           274      43685 MY MACHINE                                               sqlplus.exe
    
    SQL> select count(*) from v$open_cursor where user_name='USER';
    
      COUNT(*)
    ----------
           617
    Best wishes!
    Dmitri

  3. #13
    Join Date
    Mar 2001
    Location
    Ireland/Dublin
    Posts
    688
    Quote Originally Posted by hrishy
    Hi

    very curious about this problem.
    Have you considered opening a TAR with Oracle support on this and see what they have to say.

    regards
    Hrishy
    Thank you, this will be my next step.
    Best wishes!
    Dmitri

  4. #14
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    I dont mean count(*)

    Look what SQL are being executed in v$open_cursor

  5. #15
    Join Date
    Mar 2001
    Location
    Ireland/Dublin
    Posts
    688
    Quote Originally Posted by pando
    I dont mean count(*)

    Look what SQL are being executed in v$open_cursor
    Yes, I did look at it, only system queries, I can't say too much about it
    Attached Files Attached Files
    Best wishes!
    Dmitri

  6. #16
    Join Date
    Nov 2008
    Posts
    1
    Hello KGB

    Did you find solution to your problem after moving to RAC , as we are having similar issues

    Thanks

    -Jas

  7. #17
    Join Date
    Mar 2001
    Location
    Ireland/Dublin
    Posts
    688
    Quote Originally Posted by jasvinders
    Hello KGB

    Did you find solution to your problem after moving to RAC , as we are having similar issues

    Thanks

    -Jas
    Not yet, today I have contacted Oracle - will see what they say ...
    Best wishes!
    Dmitri

  8. #18
    Join Date
    Mar 2001
    Location
    Ireland/Dublin
    Posts
    688
    I found that tehy released 11.0.1.7, and they fixed somethign related to that error, will update.
    5377060 ORA-604 ORA-1000 when selecting from DBA_JAVA_CLASSES
    377060 ORA-604 ORA-1000 when selecting from DBA_JAVA_CLASSES
    6711477 ORA-1000 from repeated use of a REF CURSOR which is already open
    Best wishes!
    Dmitri

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width