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
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