ORA-04063 是一个 Oracle 数据库错误,具体信息为 "package body has errors"。这个错误表明某个 PL/SQL 包体(package body)中存在编译错误,导致该包体无法被正确加载或执行。 2. 可能导致ORA-04063错误的原因 包体中的代码存在语法错误:例如,SQL 语句错误、PL/SQL 逻辑错误等。 依赖的对象无效或不存在:包体可能...
ORA-04063: package body "DBSNMP.BSLN" has errors 问题描述: 警告日志出现报错: Sun Jun2800:00:012020Errorsinfile/u01/app/oracle/diag/rdbms/xxxxx/xxxxx2/trace/xxxxx2_j000_8274.trc: ORA-12012: erroronautoexecuteofjob "SYS"."BSLN_MAINTAIN_STATS_JOB" ORA-04063: package body "DBSNMP.BSLN" has ...
ORA-04063: package body "DBSNMP.BSLN_INTERNAL" has errors 问题描述: 警告日志出现报错: Sun Jun2100:00:002020Errorsinfile/u01/app/oracle/diag/rdbms/zbqdb/zbqdbi1/trace/zbqdbi1_j000_8787.trc: ORA-12012: erroronautoexecuteofjob "SYS"."BSLN_MAINTAIN_STATS_JOB" ORA-04063: package body "DBSNMP...
ORA-04063: package body "SYS.DBMS_AQADM_SYS" has errorsORA-06512: at line 11ORA-06512: at "SYS.DBMS_AQADM", line 415ORA-06508: PL/SQL: could not find program unit being called:"SYS.DBMS_AQADM_SYS"ORA-06512: at "SYS.DBMS_AQADM_SYSCALLS", line 893ORA-04063: package body "SYS....
Oracle Database Cloud Schema Service - Version N/A and later: ORA-04063: package body SYS.DBMS_REGISTRY_SYS has errors
The ABAP dump shows the following errors as the cause of the exception: ORA-04063: package body "SYS.DBMS_STATS_INTERNAL" has errors ORA-06508: PL/SQL: could not find program unit being called: "SYS.DBMS_STATS_INTERNAL" ORA-06512: at "SYS.DBMS_STATS", line 2045 ...
using dbca get errors below installing APEX * ERROR at line 1: ORA-04063: package body "APEX_030200.WWV_FLOW" has errors
ERROR at line 1: ORA-00604: error occurred at recursive SQL level 2 ORA-04063: package body "SYS.DBMS_METADATA" has errors ORA-06512: at line 10 解决办法: SQL> shutdown immediate SQL> spool /tmp/spool.txt SQL> startup upgrade
ORA-04063: package body "SYS.DBMS_METADATA" has errors ORA-06512: at line 10 解决办法: SQL> shutdown immediate SQL> spool /tmp/spool.txt SQL> startup upgrade SQL>@?/rdbms/admin/catupgrd.sql SQL> shutdown immediate SQL> spool off ...
ORA-04063: package body "SYS.DBMS_REGISTRY_SYS" has errors ORA-06508: PL/SQL: could not find program unit being called: "SYS.DBMS_REGISTRY_SYS" ORA-06512: at line 1 最终问题定位在DBMS_REGISTRY_SYS包失效,重新跑一下prvtcr.plb脚本即可解决: ...