QUOTE (burleson @ Jun 14 2010, 08:30 PM)
Are you changing from 32-bit to 64-bit?This error happens after you run @?/rdbms/admin/catupgrd.sql and then open the database:
ORA-39714: upgrade script utlmmig.sql failed
Cause: A normal database open was attempted, but the upgrade script utlmmig.sql failed to complete.
Action: Use the UPGRADE option when opening the database and then run utlmmig.sql.
>> compiled the invalid objects using utlirp.sql and utlrp.sql but of no use..
That won't help!You need to re-run utlmmig.sql
Thanks for the reply.
i am upgrading from 10.2.0.4 to 18.104.22.168
in the pst upgradation steps oracle db failed to open throwing the error in alert.log and trace file that ORA-39714: upgrade script utlmmig.sql failed
so i started the db in upgrade mode and i ran the script utlmmig.sql. but that script is throwing ERROR at line 1:
ORA-04063: package body "SYS.DBMS_STATS" has errors
ORA-06508: PL/SQL: could not find program unit being called: "SYS.DBMS_STATS"
ORA-06512: at line 2
as per the info i got from MOS docs and google search, i have compiled the INVALID objects and i ran this script again
but still i am getting the same error ..
i am not able to open the db normally..