RMAN 9i Fails selecting from v$session_longops

Oracle Database: 9.2.0.5

Error:
RMAN-10006: error running SQL statement: select sofar, context, start_time
from v$session_longops where (start_time > nvl(:1, sysdate-100) or
start_time = nvl(:2, sysdate+100)) and sid = :3 and serial#
= :4 and opname like 'RMAN:%' order by start_time desc, context
desc
RMAN-10002: ORACLE : ORA-01041: internal error. hostdef extension doesn't exist

Cause:
It is possible for longop statistics to be corrupted and possibly
cause internal errors or core dumps. This problem can also result in NULL values in V$SESSION_LONGOPS.

Solution:
1) Restart instance may solve the problem.
2) Bug 3123232 is fixed in 9.2.0.6 so apply 9206 PSR.
3) Use the workaround:
Add to the init.ora/spfile of the target database. Switch off long-op statistics by setting the following (9.2 specific) settings in the (s)pfile:

optimizer_features_enable=9.2.0.1
_subquery_pruning_mv_enabled=false

Instance will have to be restarted.