今天在将red hat enterprise linux AS 4.7环境下的  Oracle 10.2.0.1的stream测试环境升级到10.2.0.3后主库报错：
                                  Streams CAPTURE C001 with pid=23, OS id=7442 stopped
                                  Tue Mar 30 14:03:41 2010
                                  Errors in file /data/oracle/admin/source/bdump/source_c001_7442.trc:
                                  ORA-00604: error occurred at recursive SQL level 1
                                  ORA-06550: line 1, column 58:
                                  PLS-00302: component 'GET_CHECKPOINT_SCNS' must be declared
                                  ORA-06550: line 1, column 37:
                                  PL/SQL: Statement ignored
 
查看metalink发现问题的原因是升级过后有些相关的脚本未运行。
 
解决问题的办法：
依次运行$ORACLE_HOME/rdbms/admin下的脚本
prvthlut.plb
prvtblut.plb
prvtlms.plb
catcap.sql
运行脚本后错误消失。