ORA-06553

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/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/10325341/viewspace-573100/