Problém
SQL> startup ORACLE instance started.
Total System Global Area 9420095488 bytes Fixed Size 2289120 bytes Variable Size 1543504416 bytes Database Buffers 7851737088 bytes Redo Buffers 22564864 bytes Database mounted. ORA-01092: ORACLE instance terminated. Disconnection forced ORA-00704: bootstrap process failure ORA-39714: upgrade script utlmmig.sql failed Process ID: 3852 Session ID: 191 Serial number: 3
ORA-00704: zaváděcí proces skončil chybou ORA-39714: skript přechodu na vyšší verzi utlmmig.sql selhal Errors in file E:\ORACLE\diag\rdbms\orcl\orcl\trace\espis_ora_2768.trc: ORA-00704: zaváděcí proces skončil chybou ORA-39714: skript přechodu na vyšší verzi utlmmig.sql selhal Error 704 happened during db open, shutting down database USER (ospid: 2768): terminating the instance due to error 704 Instance terminated by USER, pid = 2768
ERROR at line 1: ORA-04063: package body "SYS.DBMS_SQLTUNE" has errors ORA-06508: PL/SQL: could not find program unit being called: "SYS.DBMS_SQLTUNE" ORA-06512: at "SYS.DBMS_STATS", line 24281 ORA-06512: at "SYS.DBMS_STATS", line 24332 ORA-06512: at line 4
Řešení
SQL> startup upgrade ORACLE instance started.
Total System Global Area 9420095488 bytes Fixed Size 2289120 bytes Variable Size 1543504416 bytes Database Buffers 7851737088 bytes Redo Buffers 22564864 bytes Database mounted. Database opened. SQL> drop public synonym XMLCONCAT;
Synonym dropped.
SQL> alter package DBMS_SQLTUNE_INTERNAL compile body;
Package body altered. @e:\oracle\product\11.2.0.4\dbhome_1\RDBMS\ADMIN\catupgrd
Upgrade From 10G To 11G Fails On Dbms_sqltune : ORA-04063: Package Body „SYS.DBMS_SQLTUNE“ Has Errors (Doc ID 1271490.1)