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;
阅读更多
想对作者说点什么?

博主推荐

换一批

没有更多推荐了,返回首页