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