In your inisid.ora file increase the number of OPEN_CURSORS = parameter to some reasonable value.

You can find this file unser $ORACLE_BASE/admin/SID/pfile/


Sam