IT博客汇
  • 首页
  • 精华
  • 技术
  • 设计
  • 资讯
  • 扯淡
  • 权利声明
  • 登录 注册

    ORA-06553: PLS-801: internal error [56327]

    小荷发表于 2014-12-05 03:13:48
    love 0

    今天收到一个客户的问题,数据库中的alertlog中报错ORA-06553: PLS-801: internal error [56327],

    Errors in file /mydb/db/oradata01/dbsepus/diag/rdbms/dbsepus/dbsepus/trace/dbsepus_cjq0_11056.trc:
    ORA-00604: error occurred at recursive SQL level 1
    ORA-06544: PL/SQL: internal error, arguments: [56327], [], [], [], [], [], [], []
    ORA-06553: PLS-801: internal error [56327]
    Mon Nov 17 14:11:04 2014
    Errors in file /mydb/db/oradata01/dbsepus/diag/rdbms/dbsepus/dbsepus/trace/dbsepus_cjq0_11056.trc:
    ORA-00604: error occurred at recursive SQL level 1
    ORA-06544: PL/SQL: internal error, arguments: [56327], [], [], [], [], [], [], []
    ORA-06553: PLS-801: internal error [56327]
    Errors in file /mydb/db/oradata01/dbsepus/diag/rdbms/dbsepus/dbsepus/trace/dbsepus_cjq0_11056.trc:
    ORA-00604: error occurred at recursive SQL level 1
    ORA-06544: PL/SQL: internal error, arguments: [56327], [], [], [], [], [], [], []
    ORA-06553: PLS-801: internal error [56327]

    测试export用户或者表,甚至查询dba_segments都会报错ORA-06553: PLS-801: internal error [56327]

    这个报错是因为Oracle的软件版本和之前restore进去的数据库版本不一致导致。如下即可修复:

    SQL> startup upgrade;
    SQL> @?/rdbms/admin/utlirp
    SQL> shutdown immediate
    SQL> startup
    SQL> @?/rdbms/admin/utlrp


沪ICP备19023445号-2号
友情链接