今天在将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
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
运行脚本后错误消失。
prvtblut.plb
prvtlms.plb
catcap.sql
运行脚本后错误消失。
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/7314177/viewspace-630821/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/7314177/viewspace-630821/