ORA-39714: upgrade script utlmmig.sql failed

之前遇到一个i_obj4索引问题，导致创建表失败（大概是这样，具体问题记不得了），试过rebuild、重建索引等都失败，最后没有搞定；
最近在mos上看到了解决方法（How to Create/Rebuild Bootstrap Indexes (Doc ID 1587581.1)），因为没有当时问题的环境，所以也不能确定是不是可以顺利解决，不再有其它问题；
这个不是今天要说的重点；
重点是，当看到这个解决方法，就想找个测试环境刷一下这个脚本看一下，所以在一个用来测试的数据库中刷了@?/rdbms/admin/utlmmig.sql这个脚本，报obj$mig表不存在，当时也没有在意，报错就报错吧，想着反正也什么影响，就算了。
过了几天，用来测试的数据库重启了一下，问题来了：

1. [oracle@n1 ~]$ sqlplus / as sysdba
   
   
   SQL*Plus: Release 11.2.0.4.0 Production on Mon Sep 5 17:39:07 2016
   
   
   Copyright (c) 1982, 2013, Oracle.  All rights reserved.
   
   
   Connected to an idle instance.
   
   
   SQL> startup
   ORACLE instance started.
   
   
   Total System Global Area 1068937216 bytes
   Fixed Size    2260088 bytes
   Variable Size  331350920 bytes
   Database Buffers  729808896 bytes
   Redo Buffers    5517312 bytes
   Database mounted.
   ORA-01092: ORACLE instance terminated. Disconnection forced
   ORA-00704: bootstrap process failure
   ORA-39714: upgrade script utlmmig.sql failed
   Process ID: 3426
   Session ID: 21 Serial number: 3
   
   
   
   
   SQL> exit
   Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
   With the Partitioning, Automatic Storage Management, OLAP, Data Mining
   and Real Application Testing options
   
   

看到utlmmig.sql的时候，感觉好熟悉的样子，就是一时想不起来，想了好一会。
Doc ID 1587581.1里讲要把数据库以upgrade打开，上次刷脚本的时候忘得了。
下边以upgrade打开数据库，重刷了脚本，问题解决。
按理那个i_obj4的问题应该也能解决，下次遇到再一下（ 已验证不能解决i_obj4的问题，需要使用bbed）。

1. [oracle@n1 ~]$ sqlplus / as sysdba
   
   
   SQL*Plus: Release 11.2.0.4.0 Production on Mon Sep 5 17:40:38 2016
   
   
   Copyright (c) 1982, 2013, Oracle.  All rights reserved.
   
   
   Connected to an idle instance.
   
   
   SQL> startup mount
   ORACLE instance started.
   
   
   Total System Global Area 1068937216 bytes
   Fixed Size    2260088 bytes
   Variable Size  331350920 bytes
   Database Buffers  729808896 bytes
   Redo Buffers    5517312 bytes
   Database mounted.
   SQL> alter database open upgrade;
   
   
   Database altered.
   
   
   SQL> @?/rdbms/admin/utlmmig.sql
   
   
   View created.
   
   
   
   
   PL/SQL procedure successfully completed.
   
   
   
   
   Commit complete.
   
   
   
   
   Table dropped.
   
   
   
   
   Table created.
   
   
   
   
   Index created.
   
   
   
   
   Index created.
   
   
   
   
   Index created.
   
   
   
   
   Index created.
   
   
   
   
   Index created.
   
   
   
   
   Table dropped.
   
   
   
   
   Table created.
   
   
   
   
   Index created.
   
   
   
   
   Index created.
   
   
   
   
   Table dropped.
   
   
   
   
   Table created.
   
   
   
   
   Table dropped.
   
   
   
   
   Table created.
   
   
   
   
   PL/SQL procedure successfully completed.
   
   
   
   
   PL/SQL procedure successfully completed.
   
   
   
   
   88 rows created.
   
   
   
   
   60 rows created.
   
   
   
   
   Commit complete.
   
   
   
   
   PL/SQL procedure successfully completed.
   
   
   
   
   PL/SQL procedure successfully completed.
   
   
   
   
   1 row deleted.
   
   
   
   
   1 row created.
   
   
   
   
   Commit complete.
   
   
   
   
   PL/SQL procedure successfully completed.
   
   
   
   
   10 rows deleted.
   
   
   
   
   Commit complete.
   
   
   
   
   10 rows created.
   
   
   
   
   Commit complete.
   
   
   
   
   PL/SQL procedure successfully completed.
   
   
   
   
     COUNT(*)
   ----------
   60
   
   
   
   
     COUNT(*)
   ----------
   60
   
   
   
   
     COUNT(*)
   ----------
   60
   
   
   
   
     COUNT(*)
   ----------
   60
   
   
   
   
     COUNT(*)
   ----------
   60
   
   
   
   
     COUNT(*)
   ----------
   60
   
   
   
   
   PL/SQL procedure successfully completed.
   
   
   
   
   PL/SQL procedure successfully completed.
   
   
   
   
   PL/SQL procedure successfully completed.
   
   
   
   
   TIMESTAMP
   --------------------------------------------------------------------------------
   COMP_TIMESTAMP ACTIONS_EN 2016-09-05 17:52:32
   
   
   
   
   TIMESTAMP
   --------------------------------------------------------------------------------
   COMP_TIMESTAMP UPGRD_END  2016-09-05 17:52:32
   
   
   .
   Oracle Database 11.2 Post-Upgrade Status Tool 09-05-2016 17:52:32
   .
   Component Current      Version Elapsed Time
   Name Status     Number HH:MM:SS
   .
   Oracle Server
   .
   Upgrade Incomplete
   
   
   PL/SQL procedure successfully completed.
   
   
   
   
   Commit complete.
   
   
   Database closed.
   Database dismounted.
   ORACLE instance shut down.
   SQL> startup
   ORACLE instance started.
   
   
   Total System Global Area 1068937216 bytes
   Fixed Size    2260088 bytes
   Variable Size  331350920 bytes
   Database Buffers  729808896 bytes
   Redo Buffers    5517312 bytes
   Database mounted.
   Database opened.
   SQL> 
   
   
   
   
   

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/7417681/viewspace-2124569/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/7417681/viewspace-2124569/