Symptoms
At start-up of processes, RMIServer logs show the following error:
AwE-5001 Database Query Error (9/15/12 8:43 AM)
Details: null
java.sql.SQLException: Stream has already been closed
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:179)
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:269)
Cause
There are two possibilities for this issue. It is possible that LONG or LONG RAW data type is being used in Oracle. Also check whether the user is on Oracle 11.2.0.2 or above and NOT on 8 SP6 or above.
Resolution
Insure that if the system is on Oracle 11.2.0.3, then the system must be at 8p6 at least. Contact support for further information if not the case.