ITPub博客

首页 > Linux操作系统 > Linux操作系统 > ORA-06553

ORA-06553

原创 Linux操作系统 作者:xin2v 时间:2009-03-19 14:38:51 0 删除 编辑
SQL> conn webdba/webdba;
Error accessing package DBMS_APPLICATION_INFO
ERROR:
ORA-06553: PLS-801: internal error [56319]
  
 
解決步驟:
 
SQL> conn webdba/webdba;
Error accessing package DBMS_APPLICATION_INFO
ERROR:
ORA-06553: PLS-801: internal error [56319]
Connected.
SQL> conn mkldba/mkldba;
Error accessing package DBMS_APPLICATION_INFO
ERROR:
ORA-06553: PLS-801: internal error [56319]
Connected.
SQL> conn / as sysdba
Connected.
SQL> alter package standard compile;
Package altered.
SQL> conn  mkldba/mkldba
Error accessing package DBMS_APPLICATION_INFO
ERROR:
ORA-06544: PL/SQL: internal error, arguments: [56319], [], [], [], [], [], [],
[]
ORA-06553: PLS-801: internal error [56319]
ORA-06508: PL/SQL: could not find program unit being called
ORA-06512: at line 1
Connected.
SQL> select * from v$version;
BANNER
----------------------------------------------------------------
Oracle8i Enterprise Edition Release 8.1.7.0.0 - 64bit Production
PL/SQL Release 8.1.7.0.0 - Production
CORE    8.1.7.0.0       Production
TNS for Solaris: Version 8.1.7.0.0 - Production
NLSRTL Version 3.4.1.0.0 - Production
 
SQL>
SQL> select owner,object_name,object_type,status  from dba_objects where object_
name like '%DBMS_APPLICATION_INFO%';
 
OWNER
------------------------------
OBJECT_NAME
--------------------------------------------------------------------------------
OBJECT_TYPE        STATUS
------------------ -------
SYS
DBMS_APPLICATION_INFO
PACKAGE            VALID
 
PUBLIC
DBMS_APPLICATION_INFO
SYNONYM            VALID
 
OWNER
------------------------------
OBJECT_NAME
--------------------------------------------------------------------------------
OBJECT_TYPE        STATUS
------------------ -------
 
SYS
DBMS_APPLICATION_INFO
PACKAGE BODY       INVALID
 
 
SQL> show user;
USER is "MKLDBA"
SQL> conn / as sysdba
Connected.
SQL> conn mkldba/mkldba
Error accessing package DBMS_APPLICATION_INFO
ERROR:
ORA-06544: PL/SQL: internal error, arguments: [56319], [], [], [], [], [], [],
[]
ORA-06553: PLS-801: internal error [56319]
ORA-06508: PL/SQL: could not find program unit being called
ORA-06512: at line 1
 
 
Connected.
SQL> alter package DBMS_APPLICATION_INFO compile;
alter package DBMS_APPLICATION_INFO compile
*
ERROR at line 1:
ORA-04043: object DBMS_APPLICATION_INFO does not exist
 
 
SQL> show user;
USER is "MKLDBA"
SQL> conn sys/aa as sysdba;
Connected.
SQL> alter package DBMS_APPLICATION_INFO compile;
 
Package altered.
 
SQL>
 
SQL> conn webdba/webdba
Connected.
SQL> conn mkldba/mkldba;
Connected.
SQL>
解決之后又發生新問題,ORA-06554,執行下面SQL解決:
@utlirp.sql;

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/10325341/viewspace-573100/,如需转载,请注明出处,否则将追究法律责任。

上一篇: Oracle817不能exp
请登录后发表评论 登录
全部评论

注册时间:2009-03-19

  • 博文量
    45
  • 访问量
    65462