oracle 6508,【案例】Oracle报错ORA-06552 ORA-06553 ORA-006508解决办法

天萃荷净

Oracle研究中心案例分析：运维DBA反映Oracle数据库alert日志中出现大量ORA-06552 ORA-06553 ORA-006508报错，分析原因为存储过程异常导致，结合MOS官方解决办法。

下面数据库来至于一个朋友，他们生产数据库alert.log后台不到的停下面类似的错误，每次报错都是不同的存储过程名。

Errors in file D:\APP\LUOPING\diag\rdbms\orcl\orcl\trace\orcl_q000_8400.trc:

ORA-04045: errors during recompilation/revalidation of SYS.DBMS_AQADM_SYS

ORA-06552: PL/SQL: Compilation unit analysis terminated

ORA-06553: PLS-905: object SYS.AQ$_SUBSCRIBERS is invalid

ORA-06508: PL/SQL: could not find program unit being called: "SYS.DBMS_AQADM_SYS"

ORA-06512: at line 1

Mon Aug 11 10:55:55 2014

ORA-942 encountered when generating server alert SMG-4120

ORA-942 encountered when generating server alert SMG-4121

OCI error in kwqrNonDurSubCln is OCIStmtExecute : return value -1 code 4045 buf ORA-04045: errors during recompilation/revalidation of SYS.DBMS_AQADM_SYS

ORA-06552: PL/SQL: Compilation unit analysis terminated

ORA-06553: PLS-905: object SYS.AQ$_SUBSCRIBERS is invalid

ORA-06508: PL/SQL: could not find program unit being called: "SYS.DBMS_AQADM_SYS"

ORA-06512: at line 1

KSV 4045 error in slave process

*** 2014-08-11 10:55:26.426

ORA-04045: errors during recompilation/revalidation of SYS.DBMS_AQADM_SYS

ORA-06552: PL/SQL: Compilation unit analysis terminated

ORA-06553: PLS-905: object SYS.AQ$_SUBSCRIBERS is invalid

ORA-06508: PL/SQL: could not find program unit being called: "SYS.DBMS_AQADM_SYS"

ORA-06512: at line 1

OPIRIP: Uncaught error 447. Error stack:

ORA-00447: fatal error in background process

ORA-04045: errors during recompilation/revalidation of SYS.DBMS_AQADM_SYS

ORA-06552: PL/SQL: Compilation unit analysis terminated

ORA-06553: PLS-905: object SYS.AQ$_SUBSCRIBERS is invalid

ORA-06508: PL/SQL: could not find program unit being called: "SYS.DBMS_AQADM_SYS"

ORA-06512: at line 1

exp,rman,expdp这些工具都不能使用。

下面是处理过程。

直接tar的朋友数据文件过来操作的

1，修改文件的路径名

alter database rename file ‘Z:\APP\ADMINISTRATOR\ORADATA\ORCL\SYSTEM01.DBF’ to ‘D:\test\orcl\orcl\SYSTEM01.DBF’;<