标签云
asm恢复 bbed bootstrap$ dul In Memory kcbzib_kcrsds_1 kccpb_sanity_check_2 MySQL恢复 ORA-00312 ORA-00607 ORA-00704 ORA-00742 ORA-01110 ORA-01555 ORA-01578 ORA-01595 ORA-08103 ORA-600 2131 ORA-600 2662 ORA-600 3020 ORA-600 4000 ORA-600 4137 ORA-600 4193 ORA-600 4194 ORA-600 16703 ORA-600 kcbzib_kcrsds_1 ORA-600 KCLCHKBLK_4 ORA-15042 ORA-15196 ORACLE 12C oracle dul ORACLE PATCH Oracle Recovery Tools oracle加密恢复 oracle勒索 oracle勒索恢复 oracle异常恢复 Oracle 恢复 ORACLE恢复 ORACLE数据库恢复 oracle 比特币 OSD-04016 YOUR FILES ARE ENCRYPTED 勒索恢复 比特币加密文章分类
- Others (2)
- 中间件 (2)
- WebLogic (2)
- 操作系统 (103)
- 数据库 (1,753)
- DB2 (22)
- MySQL (76)
- Oracle (1,596)
- Data Guard (52)
- EXADATA (8)
- GoldenGate (24)
- ORA-xxxxx (162)
- ORACLE 12C (72)
- ORACLE 18C (6)
- ORACLE 19C (15)
- ORACLE 21C (3)
- Oracle 23ai (8)
- Oracle ASM (68)
- Oracle Bug (8)
- Oracle RAC (54)
- Oracle 安全 (6)
- Oracle 开发 (28)
- Oracle 监听 (28)
- Oracle备份恢复 (586)
- Oracle安装升级 (96)
- Oracle性能优化 (62)
- 专题索引 (5)
- 勒索恢复 (84)
- PostgreSQL (30)
- pdu工具 (6)
- PostgreSQL恢复 (9)
- SQL Server (31)
- SQL Server恢复 (12)
- TimesTen (7)
- 达梦数据库 (3)
- 达梦恢复 (1)
- 生活娱乐 (2)
- 至理名言 (11)
- 虚拟化 (2)
- VMware (2)
- 软件开发 (38)
- Asp.Net (9)
- JavaScript (12)
- PHP (2)
- 小工具 (21)
-
最近发表
- 达梦数据库dm.ctl文件异常恢复
- Oracle Recovery Tools修复ORA-00742、ORA-600 ktbair2: illegal inheritance故障
- 可能是 tempdb 空间用尽或某个系统表不一致故障处理
- 11.2.0.4库中遇到ORA-600 kcratr_nab_less_than_odr报错
- [MY-013183] [InnoDB] Assertion failure故障处理
- Oracle 19c 202504补丁(RUs+OJVM)-19.27
- Oracle Recovery Tools修复ORA-600 6101/kdxlin:psno out of range故障
- pdu完美支持金仓数据库恢复(KingbaseES)
- 虚拟机故障引起ORA-00310 ORA-00334故障处理
- pg创建gbk字符集库
- PostgreSQL运行日志管理
- ora-600 kdsgrp1 错误描述
- GAM、SGAM 或 PFS 页上存在页错误处理
- ORA-600 krhpfh_03-1208
- VMware勒索加密恢复(vmdk勒索恢复)
- ORA-39773: parse of metadata stream failed故障处理
- sql数据库备份失败—失败: 23(数据错误(循环冗余检查)
- vmdk文件被加密恢复(虚拟机文件加密)
- 差点被误操作的ORA-600 kcratr_nab_less_than_odr故障
- win平台19c 打patch遭遇2个小问题汇总
标签归档:DBMS_SQLTUNE
数据库升级遭遇ORA-04063: package body “SYS.DBMS_SQLTUNE”
数据库从11.2.0.2升级到11.2.0.4,遇到一下错误
Oracle Database 11.2 Post-Upgrade Status Tool 08-21-2020 20:43:36 . Component Current Version Elapsed Time Name Status Number HH:MM:SS . Oracle Server . ORA-04063: package body "SYS.DBMS_SQLTUNE" 有错误 . ORA-06508: PL/SQL: 无法找到正在调用 : "SYS.DBMS_SQLTUNE" 的程序单元 . ORA-06512: 在 line 8 . INVALID 11.2.0.4.0 00:07:28 JServer JAVA Virtual Machine . VALID 11.2.0.4.0 00:01:45 Oracle Workspace Manager . VALID 11.2.0.4.0 00:00:20 OLAP Analytic Workspace . VALID 11.2.0.4.0 00:00:35 OLAP Catalog . VALID 11.2.0.4.0 00:00:57 Oracle OLAP API . VALID 11.2.0.4.0 00:00:12 Oracle Enterprise Manager . ORA-01422: 实际返回的行数超出请求的行数 . ORA-06512: 在 line 6 . ORA-01422: 实际返回的行数超出请求的行数 . ORA-06512: 在 line 5 . SP2-1506: START, @ 或 @@ 命令没有参数 . ORA-01422: 实际返回的行数超出请求的行数 . ORA-06512: 在 line 5 . SP2-1506: START, @ 或 @@ 命令没有参数 . ORA-01422: 实际返回的行数超出请求的行数 . ORA-06512: 在 line 5 . SP2-1506: START, @ 或 @@ 命令没有参数 . ORA-01422: 实际返回的行数超出请求的行数 . ORA-06512: 在 line 5 . SP2-1506: START, @ 或 @@ 命令没有参数 . ORA-01422: 实际返回的行数超出请求的行数 . ORA-06512: 在 line 5 . SP2-1506: START, @ 或 @@ 命令没有参数 . ORA-01422: 实际返回的行数超出请求的行数 . ORA-06512: 在 line 5 . SP2-1506: START, @ 或 @@ 命令没有参数 . ORA-01422: 实际返回的行数超出请求的行数 . ORA-06512: 在 line 5 . SP2-1506: START, @ 或 @@ 命令没有参数 . ORA-01422: 实际返回的行数超出请求的行数 . VALID 11.2.0.4.0 00:00:24 Oracle XDK . VALID 11.2.0.4.0 00:00:16 Oracle Text . VALID 11.2.0.4.0 00:00:33 Oracle XML Database . VALID 11.2.0.4.0 00:01:21 Oracle Database Java Packages . VALID 11.2.0.4.0 00:00:05 Oracle Multimedia . ORA-04063: package body "SYS.DBMS_SQLTUNE" 有错误 . ORA-06508: PL/SQL: 无法找到正在调用 : "SYS.DBMS_SQLTUNE" 的程序单元 . ORA-06512: 在 "SYS.UTL_RECOMP", line 865 . ORA-06512: 在 "SYS.UTL_RECOMP", line 878 . ORA-06512: 在 line 1 . VALID 11.2.0.4.0 00:00:53 Spatial . VALID 11.2.0.4.0 00:03:25 Oracle Expression Filter . VALID 11.2.0.4.0 00:00:08 Oracle Rules Manager . VALID 11.2.0.4.0 00:00:06 Oracle Application Express . VALID 3.2.1.00.10 Final Actions . 00:00:00 Total Upgrade Time: 00:18:38 PL/SQL 过程已成功完成。
查询mos发现类似解决方案
SQL> select owner, object_name, object_type, status from dba_objects where object_name = 'DBMS_STATS'; OWNER OBJECT_NAME OBJECT_TYPE STATUS ------------------------------ ----------------------------------------------------------------------------------------- --------------------------------------- ------------------- ------- SYS DBMS_STATS PACKAGE VALID SYS DBMS_STATS PACKAGE BODY VALID PUBLIC DBMS_STATS SYNONYM VALID SQL> select owner, object_name, object_type, status from dba_objects where object_name = 'DBMS_SQLTUNE' 2 / OWNER OBJECT_NAME OBJECT_TYPE STATUS ------------------------------ ----------------------------------------------------------------------------------------- --------------------------------------- ------------------- ------- SYS DBMS_SQLTUNE PACKAGE VALID SYS DBMS_SQLTUNE PACKAGE BODY INVALID PUBLIC DBMS_SQLTUNE SYNONYM INVALID SQL> alter package DBMS_SQLTUNE compile body; 警告: 更改的包体带有编译错误。 SQL> show error; PACKAGE BODY DBMS_SQLTUNE 出现错误: LINE/COL ERROR -------- ----------------------------------------------------------------- 0/0 PLS-00801: 内部错误 [phdite:node kind] 10210/5 PL/SQL: ORA-01775: 同义词的循环链 10210/5 PL/SQL: SQL Statement ignored 13917/7 PL/SQL: Statement ignored 16995/5 PL/SQL: SQL Statement ignored 17060/12 PL/SQL: ORA-01775: 同义词的循环链 17657/7 PL/SQL: Statement ignored 17660/31 PLS-00231: 函数 'SQLERRM' 不能在 SQL 中使用 19718/5 PL/SQL: SQL Statement ignored 19718/12 PL/SQL: ORA-01775: 同义词的循环链 19782/5 PL/SQL: Statement ignored LINE/COL ERROR -------- ----------------------------------------------------------------- 19782/17 PLS-00231: 函数 'BUILD_SQL_DETAIL_XML' 不能在 SQL 中使用 SQL> select owner, object_name, object_type, status from dba_objects where object_name = 'XMLCONCAT'; OWNER ------------------------------ OBJECT_NAME -------------------------------------------------------------------------------- OBJECT_TYPE STATUS ------------------- ------- PUBLIC XMLCONCAT SYNONYM VALID SQL> drop public synonym XMLCONCAT; 同义词已删除。 SQL> alter package DBMS_SQLTUNE compile body; 程序包体已变更。
重新跑升级脚本catupgrd.sql,一切正常
Oracle Database 11.2 Post-Upgrade Status Tool 08-21-2020 21:08:31 . Component Current Version Elapsed Time Name Status Number HH:MM:SS . Oracle Server . VALID 11.2.0.4.0 00:06:44 JServer JAVA Virtual Machine . VALID 11.2.0.4.0 00:00:00 Oracle Workspace Manager . VALID 11.2.0.4.0 00:00:00 OLAP Analytic Workspace . VALID 11.2.0.4.0 00:00:00 OLAP Catalog . VALID 11.2.0.4.0 00:00:00 Oracle OLAP API . VALID 11.2.0.4.0 Oracle Enterprise Manager . VALID 11.2.0.4.0 00:00:00 Oracle XDK . VALID 11.2.0.4.0 00:00:00 Oracle Text . VALID 11.2.0.4.0 00:00:00 Oracle XML Database . VALID 11.2.0.4.0 00:00:00 Oracle Database Java Packages . VALID 11.2.0.4.0 00:00:00 Oracle Multimedia . VALID 11.2.0.4.0 00:00:00 Spatial . VALID 11.2.0.4.0 00:00:00 Oracle Expression Filter . VALID 11.2.0.4.0 00:00:00 Oracle Rules Manager . VALID 11.2.0.4.0 Oracle Application Express . VALID 3.2.1.00.10 Final Actions . 00:00:00 Total Upgrade Time: 00:06:51 PL/SQL 过程已成功完成。
参考解决方案:Upgrade From 10G To 11G Fails On Dbms_sqltune : ORA-04063: Package Body “SYS.DBMS_SQLTUNE” Has Errors (Doc ID 1271490.1)
DBMS_STATS , DBMS_SQLTUNE_INTERNAL , DBMS_SQLTUNE Package Can Not be Recompiled during/After Upgrade reporting “ORA-04063″ , “ORA-06508″ . “ORA-06512″ (Doc ID 761961.1)