*ERRORat line 1: ORA-00942: table or view does not exist
【故障处理】ORA-31600和ORA-04063错误 有朋友在执行drop操作时,报了如下的错误,经过查询mos文档和远程协助最后终于处理了,记录下。 ORA-00604: error occurred at recursive SQL level 1 ORA-31600: invalid input value COMPATIBLE for parameter VERSION in function GET_DDL ORA-06512: at "SYS.DBMS_METADATA"...
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 SQL>@?/rdbms/admin/catupgrd.sql SQL> shutdown immediate ...
数据库升级ora-04063 DBMS_REGISTRY has error,在做Oracle数据库从11.2.0.1.0升级到11.2.0.2.8时,软件升级没有问题,实例升级没有问题,升级psu的时候。执行@?/rdbms/admin/catbundlepsuapply时,仅仅显示一部分信息,即终止apply。在dba_registry_history中未显示11.2...
数据库升级ora-04063 DBMS_REGISTRY has error 在做Oracle数据库从11.2.0.1.0升级到11.2.0.2.8时,软件升级没有问题,实例升级没有问题,升级psu的时候。 执行@?/rdbms/admin/catbundle psu apply时,仅仅显示一部分信息,即终止apply。 在dba_registry_history中未显示11.2.0.2.8的psu信息;...
ORA-12012: erroronautoexecuteofjob "SYS"."BSLN_MAINTAIN_STATS_JOB" ORA-04063: package body "DBSNMP.BSLN" has errors ORA-06508: PL/SQL: couldnotfind program unit being called: "DBSNMP.BSLN" ORA-06512: at "DBSNMP.BSLN_INTERNAL", line2073ORA-06512: at line1 ...
ERROR at line 1: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: ...
When tried to run utlrp script it throw below error.ChangesApplied JAN 2016 CPU PatchCauseSign In To view full details, sign in with your My Oracle Support account. Register Don't have a My Oracle Support account? Click to get started!
using dbca get errors below installing APEX * ERROR at line 1: ORA-04063: package body "APEX_030200.WWV_FLOW" has errors ORA-06508: PL/SQL: could not find program unit being called: "APEX_030200.WWV_FLOW" ORA-06512: at line 2...
数据库在使用DataPump导出时碰到了ORA-39125与ORA-04063。完整的ORA-39125提示是Worker unexpected fatal error in KUPW$WORKER.UNLOAD_METADATA while calling DBMS_METADATA.FETCH_XML_CLOB [OBJECT_GRANT:"GX_ADMIN"],在使用包DBMS_METADATA.FETCH_XML_CLOB时碰到错误。下面是对这个错误的解决过程。