ORA-1461 encountered when generating server alert SMG-3500
Change the parameter SESSION_CACHED_CURSORS = 0
(at some places it will solve your problem but not be effective everywhere)
Some work around with this:
Its a bug in 10.2.0.3 specifically in RAC and is fixed in 10.2.0.4.
So Upgrade 10.2.0.3 to 10.2.0.4
Apply Patch 6602742
this issue does not bring any loss of service or data(but not sure) until your next downtime.